Am I missing something or Airtable does not have an input method to select a user (aka Collaborator)?
What I want to do: create a script that first asks to select a user.
I know I can create a workaround (below) but that is not my question... is there really no Collaborator input?
(we are also missing a Date input since at least 3 years apparently - only solution is to parse text... for real?)
Automatable workaround, for those interested:
- create a table, call it "Users" or something
- set two fields, Name (type: Formula) and Collaborator (type: User)
- set the formula in Name to just display the Collaborator
- then create one record per actual user of your base
- (optional) create an automation running at fixed time intervals that will look for all users (base.activeCollaborators) and add/remove records accordingly
Now in your scripts you can create a form asking for a user using the input.recordAsync method.
I am baffled to seem to have to build this myself.