If you're setting it up to run from a button - you can throw some jQuery in a formula-url and make your api call - parse the response - and throw that in your field. Since your question is specific to how to get the user ID - here is an example of how you might do it in QB (using a formula-url) --
var text url = "https://yourrealm.quickbase.com/db/main?a=API_GetUserInfo&email=youremail";
"javascript: {
$.get('" & $url & "', function(response, success) {
var userId = response.getElementsByTagName('user')[0].getAttribute('id');
console.log(userId);
})}"
The $.get makes the API call - then as I typed it above should parse it out and log it to your console. From there - you can make another API_EditRecord call with another $.get request and store the true value of the userid in a field somewhere or take whatever action you need from there.
Chayce Duncan | Technical Lead
(720) 739-1406 |
chayceduncan@quandarycg.com Quandary Knowledge Base