API_AddRecord

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I am adding new records using API_AddRecord, in the new record I want the user name field to be pre-populated. The username is a Proxy field (Its coming from API do query from another table). How do I go about pre-populating user field (pre-populating user field should also populate two other lookup fields related to username)?
Photo of Sania

Sania

  • 476 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
If you want the new record to be populated with the current user you can get that ID and populate the new record with that value, any field referencing that should populate names just fine. However if you want the user to choose who is populated in the new record you will need an Assign to user dropdown and use that fields value to populate the new field in the new record. 
Photo of Sania

Sania

  • 476 Points 250 badge 2x thumb
I want one record for each user.
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
Each user selected or just each user in the app? either way I think you would want to check out API_ImportFromCSV
https://help.quickbase.com/api-guide/importfromcsv.html
Photo of Sania

Sania

  • 476 Points 250 badge 2x thumb
The users are already in a table.