Use added user field(s) as variables for forms sql statement

[nub74]

Hi,
it works but how I can set the statement ($t) as form sql data source?

[Janusz]

normally in the same php code you can read data from other tables as in the example just before and set form sql following this post:

https://forums.nubuilder.cloud/viewtopic. ... 953#p19320

[nub74]

Hi Janusz,
now everything is working properly.
Thank you very much for your help.
One last thing: is there a way to import data from external databases already populated
so that nuBuilder generates its own keys?
Thanks again.

[Janusz]

Hi,

so that nuBuilder generates its own keys?

I am not sure if I properly understood you question but in php you can generate the ID with: (and probably attache it to imported records)

Code: Select all

$string = nuID()

for example in my case for all my tables I use INT with auto increment defined on the DB level (as mytable_id) - so no need to set anything more.