The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hello fine people!Here's what I have and am trying to do... any help would be greatly appreciated!!Customers order a product from us and can choose a recurring subscription - either once a month, three months, bi-annual, or annual.What I'd like to do...
Hello - I could use some help with a formula or automation to get what I'm trying to achieve to happen.We have job numbers that are coded as follows:23 = year1 or 2 = office identifier0001 = job number for the yearExample: 2310023 What I need to happ...
I have this formula to pull the time from a date/time column…
DATETIME_FORMAT(SET_TIMEZONE({Submitted at}, ‘America/Chicago’),‘h:mm’)
Is there a way to have AirTable recognize this as a number?
Here’s what I need, if someone would be so kind as to assist…
I have a Submitted at column which tags the date/time the record was created from a form entry.
I have a Completed column which tags the date/timestamp when the Completed box is checked, w...
I have a similar issue, but mine is displaying a different hours altogether.
The timestamp in my “Submitted at” field I have is 8/3/2022 17:23 …
Should return 17, yes?
I’m getting 22.
Formula is as follows:
DATETIME_FORMAT({Submitted at},'H')