How do I connect a drop down to a SQL datasource?
HI,
How do I have a drop down list pull in data from my MSSQL server table? Or If I have to I can have it batch the data in from a CSV file.
But I need to fill a drop down with our data and then based on what my user selects - give a sub result. Exactly how 'category' and 'subcategory' work .
If I need to I can use API, CSV to populate my drop down list, Insert directly into SQL table, etc. WHat is the method to accomplish this? Using python script to read a csv?
Can't seem to find any info on this. Seems like it should be baked into this product.
How do I have a drop down list pull in data from my MSSQL server table? Or If I have to I can have it batch the data in from a CSV file.
But I need to fill a drop down with our data and then based on what my user selects - give a sub result. Exactly how 'category' and 'subcategory' work .
If I need to I can use API, CSV to populate my drop down list, Insert directly into SQL table, etc. WHat is the method to accomplish this? Using python script to read a csv?
Can't seem to find any info on this. Seems like it should be baked into this product.