0

Multi-Choice (Dynamic) Field

Ahhh, Multi-Choice (Dynamic).... Truly a wild animal.

 

I have a dynamic multi choice field to select multiple records in a table, staff. How do I get the Staff.'Employee Name' to display in a formula from the multi choice field?

 

I've tried:

let ids:=concat(numbers('Assigned to');
record(Staff,ids).'Employee Name'

I can't even get the past the syntax errors. Please HELP!

1 reply

null
    • Fred
    • 2 yrs ago
    • Reported - view

    The issue is you have a collection of Ids that you have to somehow iterate through one at a time to get the Employee Name. So you need to put in a for loop.

    Here is something off the top of head:

    let ids:= numbers('Assigned to';
for loop1 in ids do
record(Staff,loop1).'Employee Name'
end

    this will create a csv string of Employee Name.

Login to reply

Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 1Replies
  • 107Views
  • 2 Following