I have 100 records in a table with the same status "ready for publication". How can I use the "Find records" action to only retrieve the first found record?
Solved
one row from the table
+2Best answer by kuovonne
The “Find Records” action currently cannot be limited to just the first record.
I sell automation helper scripts that includes a script that will identify and output the first record ID from a “find records” action. You can then use that record ID in future actions.
If you need record values from that first record, you can create a formula field in the table with the RECORD_ID() function. Then do a second “find record” action based on the record ID.
+29The “Find Records” action currently cannot be limited to just the first record.
I sell automation helper scripts that includes a script that will identify and output the first record ID from a “find records” action. You can then use that record ID in future actions.
If you need record values from that first record, you can create a formula field in the table with the RECORD_ID() function. Then do a second “find record” action based on the record ID.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.