Hi, was wondering if anyone has a workaround for assigning a user in a workflow from a trigger user collection? In the screenshot I want to make the assignee the only user in the “specialists available” user collection.
I am using Airtable so am wondering if a formula, lookup or rollup will help to select just one linked record?
I’d like to avoid creating a duplicate linked record field with a limit of one if possible but will if needed.
Change the “Specialists available” field to be limited to one specialist. You’ve said you don’t want to do that.
If you know that that field will only ever have 1 linked record in it, then you could use a “For each…” action to loop over each “specialist available” and then create a record for each… assuming there’s only one then this will have the same affect as what you’re hoping to achieve