I am trying to Lookup the ParticipantID from the Participants table and it currently works thanks to another post here on the forum but I only want it to calculate when the FullName column is not empty. You can see that row 2 is showing the number 2 but FullName is empty. Heres the current formula: Participants.lookupOne(id=$id).ParticipantID
Hi @JadynnMarshall ,
You can use dot notation to pull this value in from the Participants table, simplifying your formula. Use $FullName.ParticipantID to pull the Participant ID for the linked record. If no record is selected yet, then nothing will show in this column.
Thanks,
Natalie
WHOA!! did you just complete in less than 10 minutes what it took over 3 hours and over 30 LLM prompts to still fail at…? THANK YOU, THANK YOU, THANK YOU!!
