Help

Using Automations to Find record within an array

Topic Labels: Automations
344 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