GeoffreyHarmuth
8 years agoQrew Captain
populate user ID to a field
I need to be able to extract a user ID from a selected user.
The process is as follows:
When I select a user in a form, I would like to have a formula text field that populates the UserID from that user field. I have read a similar article:
https://community.quickbase.com/quickbase/topics/extract-user-id-from-a-user-name
But i need a bit of help with the formula that needs to be inputted into the field. Also, because its an API call, would I have to use a URL formula field and then run the script in that way?
If I can just get all the user information into a field, I can then run the following formula in another field: Left(Right([User Field],"<"),">") to extract the ID only
Please can someone assist with the format of the API call formula: API_GetUserInfo
Thanks
The process is as follows:
When I select a user in a form, I would like to have a formula text field that populates the UserID from that user field. I have read a similar article:
https://community.quickbase.com/quickbase/topics/extract-user-id-from-a-user-name
But i need a bit of help with the formula that needs to be inputted into the field. Also, because its an API call, would I have to use a URL formula field and then run the script in that way?
If I can just get all the user information into a field, I can then run the following formula in another field: Left(Right([User Field],"<"),">") to extract the ID only
Please can someone assist with the format of the API call formula: API_GetUserInfo
Thanks