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?
Page 1 / 1
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.
As for the translation, you can use the concept of a lookup table:
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.