I liked the SQL package to use in the Form as a live value.
An ID is sent to my form. And in the form itself, several fields must display specific values, taking them from the same table in the database.
Ie: [2] - > Live - > "SQL query»
In "settings" for first write on:
Select column column1 from table#__, where id=…
Second:
Select column column2 from table#__, where id=…
And so on.
I am afraid that it is not quite effective, causes increased load on the server and it is more correct to make a single request:
Select column1, Column2,... from table#__, where id=…
Codec Pack?
Hi, yes code pack would help here onBeforeRender should be the right event but I am not sure it is early enough for live values to take effect in rendering, if not you will need to directly affect rendered html and value properties.
Ok thank you Kias