People sign up for an online class through our google form. I’d like to be able to Zap the form entries into Bloomerang (we have been sending to sheet, downloading csv, uploading into Bloomerang). I’m stuck because we have historically translated the date chosen (eg: Tuesdays, starting May 27 at 7pm CT) to a “Class Code” that we use in Bloomerang to sort people by which class they are taking. For the example given, the class code looks like: 527257 (MonthDateYearTime). Any suggestions on how to make this happen automatically?
Question
How to automate Google Form entries into Bloomerang with class codes assigned based on dates chosen
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
- 34008 replies
Hi
First, I recommend using a different DateTime convention that will always be unique and can’t be confused.
e.g. Tuesdays, starting May 27 at 7pm CT as 527257 (MonthDateYearTime) does not account for AM/PM.
e.g. Is 112257 Jan 1 or Nov 12?
Instead, try using an ISO timestamp format. (info)
e.g. YYYY-MM-DDTHH:mm
Plus, an ISO timestamp will always auto sort.
+14- Zapier Orchestrator & Solution Partner
- 34008 replies
As for the translation, you can use the concept of a lookup table:
+11- Community Manager
- 9662 replies
Hi
How did you get on with Troy’s suggestions here—did they do the trick?
Want to make sure this gets sorted, keep us posted on how it’s going! 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.