You’re offline. This is a read only version of the page.
2
I have a list with a list called "Clients". One of the fields is "Protocol ID".
I have another list called "Investigator List" where they choose the "Investigator Protocol ID" as a look up to the client list's Protocol ID. And an "Investigator Name" field.
I have a third list called "Schedule Monitoring Visits" where they choose the "Site Visit Protocol ID" as a lookup to the client list and "Investigator" as a lookup to the Investigator list.
I want the Investigator lookup in the Site Visit list to be filtered based on the "Site Visit Protocol ID" choice.
I've tried:
Filter(Choices([@'Schedule Monitoring Visits'].'Investigator Name'), 'Investigator List'.'Investigator Protocol ID'.Selected.Id = DataCardValue13_1.Selected.Id)
Where DataCardValue13_1 is the card value of the Protocol ID in the Scheduling Monitoring Visit list.
But it's throwing an error for 'Investigator List'.'Investigator Protocol ID'.Selected.Id.
I'm wondering if it's because I'm trying to match two lookup fields?
Hi @infoCRA ,
Please try below formulas for the Investigator Combo box:
Items:
Share
Report
All responses (
Answers (
Filter(
Choices([@'Schedule Monitoring Visits'].'Investigator Name'),
Value = LookUp(
'Investigator List',
'Investigator Protocol ID'.Value = DataCardValue13_1.Selected.Value
).'Investigator Name'
)
Best regards,
