The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Dec 22, 2022 01:48 PM
New to Airtable / Formulas and Automations 🙂 Hopefully someone out there can explain what im assuming is a basic SEARCH formula to me 🙂
I have created some automations using Zaiper to update a record based on a UNIQUE ID ( Video ID ) but i can only create a search function for that specific ID.
How would i go about creating a formula to SEARCH for a ID value that is 1 more than the previous one.
ie i can find "SC1" but i would like to create a formula that could find "SC2" , the 3 and so on. As i have a file naming convention that is sequential its needed to update each record through-out the workflow process.
Dec 23, 2022 12:50 AM
@Rlaurence83 Hi there! Why not to use a substring search pattern "SC" instead of "SC1"?
Dec 23, 2022 03:35 AM
Hm, I'm not entirely clear what you're trying to do here and thought I'd provide you with a potential way to populate a formula field with an ascending number in case that helped.
Here's the formula:
IF(
{Video ID} != "",
"SC" & (VALUE(SUBSTITUTE({Video ID}, "SC", "")) + 1)
)
Dec 23, 2022 05:32 AM
Thnaks adam ill give that a try. Im trying to have a specific record and field to update based on a frame.io action ( ie - video approved ) - as i number all my videos in sequential order i thought having a search function for the " find record" automation in zaiper to "look" for the video ID + 1 idk if thats even logical 🙂 lol
. Another member mentioned having some data stored in zaiper storage everytime a action is made and then call to it out in a search for record but that is a little over my head right now so trying something simpler that may work - appreciate the feedback