Sep 26, 2022 05:40 PM
I’m not having success using Zapier Find Record.
Is my Zap Find Search Value query format in Step 4 off? (see screenshots: ZAP query value and AT field value match)
AirTable Automation
Step 0: send a Slack Message that includes the RecordID (from field with RECORD_ID())
Zapier Steps
Step 1: Monitors slack channel for New Messages
Step 2: Filters to ensure it is sent by Bot and contains a RecordID
Step 3: Formatter extracts the RecordID
Step 4:
using Formatter OUTPUT value to search the Record_ID() field, but tests return: # Failed to find a record in Airtable. Error from halted execution: Nothing could be found for the search.
Thanks for reading, appreciate any assistance!
Sep 26, 2022 07:58 PM
All looks good from your screenshots… but could the output of your formatter step possibly have a leading or trailing space? Sometimes it’s as simple as that :smiling_face_with_halo:
If so, you could add another formatter step to trim the output from step 3. Or use one script step in place of both formatter steps to save on task usage.
Happy to help further if the above doesn’t solve the issue, but it would be helpful to see a sample value from slack as well as more info on your existing formatter step :+1:t2:
Sep 27, 2022 02:01 PM
Ah. I had a leading in my message generation step. Tests are now working as expected. Thanks for your assistance!