After through the documentation on DATETIME_PARSE() I’m not seeing the timezone respected when used in conjunction with either SET_LOCALE() or SET_TIMEZONE() for conversion of a string field containing date and time information. What am I missing her...
I have table where I’m tracking attendance versus enrollment of a training workshop. I’m using a name field that also has a lookup field displaying whether someone goes by a formal name or an alias. I have another field that has an array of all atten...
I have a Learning Course table that tracks courses with either a single session or dual sessions via checkbox fields. I have links to fields in this table that identify whether an enrollee has completed the relevant sessions(s). From there I have a c...
I’m have some datetime fields that I’m trying to format down to isolate the time. However, I’m seeing that there are some glitches with how the time renders based on time zone. My source datetime field is formatted to PDT, but the output appears to b...
I’ve created one automation that generates an Outlook Calendar Event when I add a record to a specific view in Airtable. Now, I want another automation to run that is triggered by someone submitting a form to register for that same Event as defined i...
Hi @Kamille_Parks , the REGEX worked! Thanks for that! What I had meant before of having “no effect” was that the CONCATENATE operator, “&,” didn’t produce any different results. I appreciate your time!
Thanks for your reply @Kamille_Parks. Unfortunately, this has no effect. I need to FIND either one or the other strings (Alias, or Name) within the Workshop Session Attendance field (which is an array of multiple linked records). Do you have any othe...