Create user form: Populate a string attribute with a SQL query or JS

[FCaremoli]

Hi all

We have an attribute string and we want to automatically populate it during the user form update (update user request). It is possible to do it by an SQL or a javascript query?

We want also to manually change the value if necessary.

The attribute is mapped to an usercolumn. 

For example:

I have user with a phone number equal to +01 23456789 and I want to have in the phone number field only 23456789 as the default value and make it editable.

Thanks.

@JustSalva @nfraternali

[avinashchhetri]

@FCaremoli,

Just following up on your question, if you update the value shown in the form from 23456789 to say 98765432, what would you want to do next ?

1) Update the Phone Number attribute (where it was initially picked up from) as +01 98765432

2) Update the Phone Number attribute with just the updated value 98765432

3) Keep Phone Number as is, instead update the different attribute, say CP40, with the updated information ?

[FCaremoli]

We want to do exactly as your first option. In that way if the someone change the phone number the prefix (+01) remains the same

@avinashchhetri @JustSalva @nfraternali 

[rushikeshvartak]

You can validation that number should start with +01 & user can add whatever number he need

[FCaremoli]

Thank you for your effort but unfortunately we can't do like that.

During the create user form we ask the user to select the "prefix" from a single select from SQL query attribute and to insert the "suffix" into a string attribute than we merge the two value into the "suffix" usercolumn. Now in the update user form we want to auto-populate it by separating again those two value. Unfortunately for the "suffix" we can't do that since for a string attribute seems impossible to populate it with an SQL or JS.

@rushikeshvartak @JustSalva @nfraternali