Hello,
I have formatted the date but the hour displayed shows 1 hour less.
How can I display the exact time in hours and minutes in the field {date formatted} ?
The formula I use is :
DATETIME_FORMAT({Time slots},‘DD-MM-YYYY à HH:mm’)
How can we so...
Hi!
I created a field that concatenates the last name and full name in a table.
I am trying to write a function that takes the 2 letters first letter of the first name and 2 last letters of the last name.
But it only returns the 2 first letters of th...
Hi!
I would like to write a script that automatically creates time slots one week in advance.
These time slots are every Tuesday and Wednesday from 9am to 2pm (6 time slots/day).
For now, I type them manually but there is certainly a better way… Let ...
Awesome @rarenstein ! Yes, the trash keeps tables, views , fields , extensions , and records that have been deleted in a base in the past seven days. This article explains how the trash works in detail. Well done!
Hi @MettaSong !That's a great question. I have not found yet a built-in feature to make the window bigger so that you can see more options at once, or drag the corner to expand it.However, as a suggestion, I have found that at the bottom of the windo...
@kbob13 wrote:[...]I want to only display the guest names that have the "media" affiliation and not the others.[...] I think that creating a view with a filter at the {Affiliation type} displays only the guest with the Affiliation type that you want....
Hi @maureen !You may have to create 3 tables to make it work. One for your products, one for the Categories and one for the Subcategories. Then link the Subcategories to the Categories with the Lookup field type. In your {Products} table create a sin...
Hi @StudioStein !I watched the screen recording and it may be a synchronisation issue between your account and Airtable. First, make sure that the attachment does not exceed 5gb because it is the maximum size. If it doesn't then proceed to do the fol...