Auto populate field with past info.

[asd22]

Hello,

I have a contract form where users enter their information. Currently, the form automatically populates details such as the address, but the bank account number still has to be entered manually. Is there a way to have the bank account number auto-populate if the user has already provided it once? Note that the bank account number is not stored in the sys_user table but in a separate CONTRACT table.

[Ankur Bawiskar]

@asd22 

how is the auto populating working?

Are you using some GlideAjax to bring info and then set on form fields?

If yes then bring the Bank account number as well from the related table and populate it

what did you start with and where are you stuck?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[asd22]

The other user info is populated from the sys_user field that i have a setvalue on. But the bankaccount number is part of the u_contract table. and its stored in the contract form thats sent in when a person fills in the contract info. The only place i think i can get the bankaccount from is looking up past contracts of a user and getting the number from there

[Ankur Bawiskar]

@asd22 

then what's the linkage between the user and u_contract table?

without this linkage how will you know which bank account to fetch from "u_contract" table?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[asd22]

thats what im unsure of, the u_contract gets info from sys_user table.  as you can see here, this is on a sent in contract, in ther "personal info" these are the fields that show up

the bottom two fields are from the u_contract while the others are info taken from the user  sys_user

[Ankur Bawiskar]

@asd22 

we don't know the table structure and the linkage in your instance.

unless you share we can't help.

If my response helped please mark it correct and close the thread so that it benefits future readers.