Question: Lookup from External data source


1 comment

  • Avatar
    Jacob Shapley

    Hi Dan. We have a similar need. We have accomplished it by pushing the data from the external data source (SQL Server in our case) into iFormBuilder in two pieces: 1) An option list that has the "name" as LABEL and the table's primary key value as KEY_VALUE then 2) A smart table that contains all the fields from your external table that you want to display, including the primary key (which you can import via csv or POST/PUT via the API). We then use the ZCDisplayKey function to link the option list choice to the smart table. I'm sure support could provide more info.

    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk