Soly - profile

Soly · Nov 22, 2022

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...

Soly · Nov 10, 2022

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...

Soly · Nov 09, 2022

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 ...

Soly · Jan 29, 2023

Hello @Melanie_Lemnios ,The formula you may use for your employee counter {Employee Count} is : IF(AND({Start Date} < {Given Day}, {End Date} >= {Given Day}), 1, 0) It puts 1 if the employee is present and 0 if he was absent that day, based on the st...

Soly · Jan 28, 2023

Welcome to the Airtable community @DanzTruong!For this, I recommend you to contact the Airtable support team directly via this link .As they will have the necessary tools to troubleshoot what you encounter, so that you can set up this authentication ...

Soly · Jan 26, 2023

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! 

Soly · Jan 26, 2023

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...

Soly · Jan 25, 2023

@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....

User Statistics

User Activity

How to adjust Date Formatting?

Create a formula that uses RIGHT() and LEFT() simultaneously

Creating several time slots ⌚

Re: Date Counting

Re: 2 Step Authentication - Can't submit phone number

Re: Retrieve deleted interfaces?

Re: Is there a way to expand the size of the Single & Multiple Field Select Editor Windows?

Re: Parse specific records from a lookup field?