[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 |
J
|
jacktonghk authorDevClub member 11/23/2023 |
Modify the SQL is what I am doing. Thank you!! |