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.
Please correct me if i’m wrong. I don’t see a CASE statement in Airtable.
It’s a classical one but still very useful if you can avoid unreadable nested IF statements :
CASE (
condition1; Statement if condition1 is TRUE; statement if condition1 is FA...
What do you thing about making the Field Type Symbol Optional in views (A, $, …).
The benefit i see is polishing the UI for non geeks users and gain some pixels in the header for all of us.
Thx
Hi again,
I’d like to know if i can “NAME” and “SAVE” a filter and use it furthermore by selecting it from a list ?
In case it doesn’t exist, i think that it could be helpful as a standard feature for some of us.
Regards
Max-Antoine_EDIGHOFF:
Try this:
CONCATENATE(Formation , " - " , DATETIME_FORMAT({Date de début}, ‘DD-MM’), " - " , DATETIME_FORMAT({Date de fin}, ‘DD-MM’))
I presume that
“Formation” is the name your training course field.“Date de début” is the...
Thanks W_Vann_Hall, i didn’t find the old post. I understand that the debate ended on a 50-50 pro and cons. In this case, a good solution could be " MAKE IT OPTIONAL ". After all, most of the time, developers are technically responsible for the ap...
Another way:
You can try this and use the optional parameters if needed and make sure you are in US format ( didn’t try myself !).
DATETIME_PARSE ( “’”
& MONTH( {Hire Date} )
& “-”
& DAY( {Hire Date} )
&"-"
& YEAR(TODAY(), [ format ], [‘locale’] )
Date Field Default Value
In the meantime, it might be useful for you to use the keyboard shortcut Ctrl + ; (or ⌘ + ; on Mac). This will automatically put in the current date/time into a datetime field (“current” here means “the time at which the...
Hi !
The filter needs a field and a constant (a value)
or
A field and a second field to work.
I don’t think that you can use a formula (?!)
So you may need to first ADD those fields before using them in a filter.
i.e
Field “this_month” of type FORMUL...