Help

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.

Using Automations to Find record within an array

Topic Labels: Automations
565 0
cancel
Showing results for 
Search instead for 
Did you mean: 
rbosworth
4 - Data Explorer
4 - Data Explorer

I am creating a raffle ticket lookup system to enter in sold raffle tickets and then find the ticket winner info once a winner is determined.

I start the process by entering a phone number and a starting ticket number along with how many tickets were purchased. This creates an array of every ticket that person purchased in a field.

rbosworth_0-1692667668286.png

In another table, I have basket 1, then enter the winning ticket number. I created an automation that searches the arrays - when the ticket number is found it updates the record for the persons telephone number. Then a txt message goes out to the winner.

rbosworth_1-1692667792335.png

 

This worked great for a few weeks. Now, it updates the winner with every entry - so every phone number from every buyer comes in. 

rbosworth_2-1692667824214.png

How do I make this work?

0 Replies 0