I am tracking badges earned each year for a kids club. I have a member table that contains info about each member, such as what grade and club they are currently in. I plan to create a Badge table that will contain the names and dates for badges earn...
I have a date in CurDt and I want to add YrOffset to it and end up with a new date in a date format. YrOffset can be negative, positive or 0. I’m not sure how to do it.
I’m working on an app to keep records for a children’s club. We try to get their birthdays, but sometimes they don’t know the year they were born. Is there a way to enter only the month and day?
Ultimately I want to use the date to calculate the age,...
I.m new to Airtable. I’m trying to concatenate the nickname if the field isn’t empty or the first name if no nick name then a space then the last name. It puts NaN in the field. Here is my code in a formula field:
CONCATENATE(IF(nickname="",First,ni...
Sorry I couldn’t respond sooner. My area was without power for awhile, then I had to do some major changes to a non-profit website I maintain.
I manually created the screenshots.
The lnkmenu field links to the menu database which contains one record ...
I changed srt2 to load the contents of sort, then in sort I used this formula so if srt2 is blank I create the initial string, but if srt2 isn’t blank I copy the initial string back into sort.
IF(srt2=BLANK(),CONCATENATE(srtyr&"-"&ClubN&name),srt2)
I...
Since I’m new to this particular app, I may have done something wrong, but when the year is changed the year in the Badges record also changes.
I have 3 tables:
Main - contains 1 record which contains the date that is changed at the beginning of our ...
That won’t work for what I’m trying to do. Here are some examples for the sort field in the Badge table:
THIS YEAR
20205.3Tina (other fields)
20203.2Cari (other fields)
NEXT YEAR
20216.1Tina (other fields)
20213.3Cari (other fields)...
