populate user ID to a field

  • 0
  • 1
  • Question
  • Updated 1 year 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,730 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k 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

  • 26,272 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.