Hello!
@Melanie_E_Magdalena and I built and supported just such a plugin with a team of 15 using for support. It was a massive productivity machine! We are familiar with both API’s and have custom code to connect the two.
We’d love to have a meeting ...
Hello!
The reason for this is the IF statement needs to be wrapped in a SET_TIMEZONE and declare the desired timezone. You can find those here: https://support.airtable.com/hc/en-us/articles/216141558-Supported-timezones-for-SET-TIMEZONE
Howdy -
@Melanie_E_Magdalena and I had a crack at this for you - not sure how variable your data is, but with the samples you gave, try this:
LEFT(RIGHT(Name,5),1)
where {Name} = the field name
Hope that helps!!
Grant
