SQL searchable table for option list

Follow

Ciaran Walsh

June 15, 2016 16:06

I would like to be able to create a table and upload data to that table. For example Country, District, County, Village data.

I then would like to be able to enter a line of SQL to return the options based on previous selections. This would be MUCH easier to maintain and implement than the current way of creating lists with conditional values for each option.

5

• 

  matt July 11, 2016 13:53

  yes - any easy way of uploading list choices / answer choices would be better than the current system where I have to create all the choices manually

  1

  Comment actions Permalink
• 

  Tony Ruth January 19, 2017 16:55

  Hi Ciaran, just want to make sure I understand this request. Are you suggesting to replace JavaScript expressions with SQL statements instead?

   

   

  0

  Comment actions Permalink
• 

  Tony Ruth January 19, 2017 16:56

  @matt You can create new lists by uploading a CSV file using the updated Form Builder.

  0

  Comment actions Permalink
• 

  Ciaran Walsh January 23, 2017 10:57

  Hi Ryan,

  At the moment lists are separate entities and not linked. You have to then condition each option using conditional values.

  I would like to be able to upload data into a table from a csv file and then use a SQL statement question to search these values. 

  I think this would be easier to maintain lists and conditions. I hope this help. Happy to have a quick call about this if you wish.

  0

  Comment actions Permalink
• 

  Tony Ruth January 23, 2017 14:20

  Thanks for the follow-up and explanation Ciaran.

  0

  Comment actions Permalink
• 

  Permanently deleted user February 10, 2017 13:14 (Edited February 10, 2017 13:14)

  0

  Comment actions Permalink

Please sign in to leave a comment.