Question: Lookup from External data source

Follow

Dan Charlesworth

May 07, 2015 16:11

Is it possible to hold a lookup from an external data source.

An example of what I am trying to achieve...

I am building a questionnaire for auditing farms for existing farmers. We have already a database populated with farmer names and identifications, when a livestock buyer visits the farm to go through the questionnaire I would like the ability for the buyer to select the farmer from a list which auto populates the farmers details from the database.

1

• 

  Jacob Shapley June 03, 2015 16:27

  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.

  0

  Comment actions Permalink

Please sign in to leave a comment.