Parabola does not support scheduling rules based on the value of a cell. Feel free to post that in the #feature-requests section of our community forum.
Try updating your subscriber data in Campaign Mailer instead. Their documentation notes that you can make a
PUT request to your subscriber resource.
This video shows how you can trigger an email campaign using a specified date field. They seem to use the values in the
Birthday column field to trigger the automation journey.
The values in that column are set to 12:00 am UTC. We’ll those the dates into Unix seconds so we can calculate and adjust the hours. The Format dates step should do the trick.
Using an Insert if/else column, we can target your
Timezone column to create a new column called
Calculator and set the value to
61,200 seconds, since 9:00 am PST is 17 hours ahead of 12:00 am UTC. Add a new rule for every timezone in your dataset.
The Insert math column will allow us to add those seconds to your original date.
Lastly, we can convert that back into a standard format using another Format dates step.
The new column will be an added field to your subscriber list. Hopefully, that value can be used to trigger when an email is sent!