Default SQL:SELECT value

id3000

New member
Hello Eugenio.
First, thank you for your help regarding my last posts.

Is it possible to add a WHERE criteria based on a $_GET field in the SQL:SELECT default value definition of a field in the forms configurator ?

For example, i would like to set for a field a default value like "SQL:SELECT max(my_field) FROM my_table WHERE my_key=$_GET['other_key']", assuming that $_GET['other_key'] is already passed by dadabik of course...
 

eugenio

Administrator
Staff member
Hello,
at the moment the SQL: default value can be used just together with an hard-coded custom SQL query, it cannot contain variables.
 
Top