2. PHPRunner General questions
  3. [SOLVED] database lookup autofill
This topic is locked
[SOLVED]

database lookup autofill

 		11/20/2023 1:52:34 AM
PHPRunner General questions
J
 jacktonghk authorDevClub member

Can I set a formalua in the autofill value? Currently it only allow me to pick a column from the lookup table, but I my requirement is based on Column A * Column B. Thank you!!
mbintex 11/20/2023

Then you will need a field event or calculate your value already in the lookup table.
admin 11/20/2023

You can modify the SQL query the of the Lookup table. Something like this will work:

select ColumnA * ColumnB as ColumnC
from LookupTable
J
 		jacktonghk authorDevClub member 11/23/2023

Modify the SQL is what I am doing. Thank you!!