Jan 03, 2020 02:39 PM
Hi All,
Trying to fix a goof in our Airtable.
Backstory:
We programmed a certain formula to add in the year a record was created into the record name(i.e. 2019 =19). We pre made some of these records in December, and now need to duplicate the records and have all the duplicated records keep the same name. I hope you all have realized the problem with this… If you haven’t all new records now automatically signify it’s 2020 and no longer 2019.
My Idea is to add in a check box to the records we want to fix to say "If box = 1 then replace “DATETIME_FORMAT(CREATED_TIME(), ‘YY’)” With “19.”
Here is the Original Formula:
IF({Class} = “STR”, “ROS” & “" & {Instructor} & "” & {Class} & “" & {Strength ID} & "” & DATETIME_FORMAT(CREATED_TIME(), ‘YY’) & “" & {Playlist})
&
IF(NOT({Class} = “STR”), "ROS” & {Instructor} & “" & {Class} & "” & DATETIME_FORMAT(CREATED_TIME(), ‘YY’) & “_”& {Playlist})
This would spit out something like “ROS_EMILY_DANCE_20_3”
I know the above is not the prettiest thing, but I’m definitely just a beginner in this and any help would be appreciated!
TLDR:
I goofed in my auto naming formula cause I forgot about a little thing called years and how they worked.
Solved! Go to Solution.
Jan 03, 2020 06:23 PM
HI @Jerry_Leu - you can replace this:
DATETIME_FORMAT(CREATED_TIME(), 'YY')
with this:
IF(Checkbox, 19, DATETIME_FORMAT(CREATED_TIME(), 'YY'))
JB
Jan 03, 2020 06:23 PM
HI @Jerry_Leu - you can replace this:
DATETIME_FORMAT(CREATED_TIME(), 'YY')
with this:
IF(Checkbox, 19, DATETIME_FORMAT(CREATED_TIME(), 'YY'))
JB