populate user ID to a field

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
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
Photo of Geoffrey

Geoffrey

  • 1,980 Points 1k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 2,100 Points 2k badge 2x thumb
I read the post and do not like the native way. I would suggest the api call. You'll need the users email so could just have a field on the form. You'll need to implement the IOL technique if you have already. Feel free to contact me if you need coding help. Chuck@chuck.support
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
> ... do not like the native way. ... You'll need to implement the IOL technique




Goofus employs the IOL, BOL and SW techniques with QuickBase to achieve the impossible.




Gallant uses only native QuickBase features and waits for proper releases.
Photo of Patrick Dunn

Patrick Dunn

  • 480 Points 250 badge 2x thumb
Hi Chuck. I've implemented the IOL technique, but I'm struggling to do the rest. In a form, when a user dropdown changes, I want to run  API_GetUserInfo for the user chosen in the dropdown and then populate a field of the form with the user's userID. Any suggestions would be greatly appreciated.
Photo of QuickBasePros (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 5,264 Points 5k badge 2x thumb
What would you use the ID# for, out of interest?
Photo of Patrick Dunn

Patrick Dunn

  • 480 Points 250 badge 2x thumb
I have an app in which I've added @mycompany.com as a user - granting all registered users of my firm basic access to the app, which includes access to a profile table. Users can create a profile for themselves and in so doing identify the role the user should have in the app.

Once the form is populated, a formula URL field button will appear. The button will use the API_AddUsertoRole call.

So to answer your question, I want to use the userID within the API_AddUserToRole call. 

Make sense? Happy to discuss! I'm eager for any assistance.