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