This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hey GuysI have a dynamic datefield (updates thru automations) that begins from todays date and records 10 days ahead. Is there a way to write a formulafield that ranks the date with numbers 1-10, i.e so todays date is 1 and tomorrow 2 and so on? I co...
Hey guysIm stuck with a problem with some formulas, I got some real good help from @Andrey_Kovalev in December but now I'm stuck, so please if someone could advise. Long story short, I have 10 records (Mon-Fri odd and even weeks)and I want the date t...
Hey guysI have a brain drain problem with how I should set up a dynamic date formula, I have 2 tables in a base, one for odd weeks and one for even weeks. They both just contain 5 records, one for each workday. I have separate fields where the curren...
Hi guys, have been sitting with this a couple rounds now and can’t get it right. Im extracting a telephone number from a column in Airtable, but when there is no phone number or the word message I get the famous #ERROR. How can I get Airtable to just...
Hey everyone
Having a bit of problems with this script.
I have a tasklist and at the end of the record I have a delete button.
When I press the button I want it to delete just that record. But when I use this script it seams to delete just any of the...
Thank you @Brian_Swanson , but I don't want to count in weekends. I have a calendar mon-fri for 2 weeks that the date is updated every midnight by automation. So if today is Wednesday th 3rd may would be number 1, yesterday should be number 10, tomor...
Hey @Micki_O_Neil Thank you so much for your time on this, but I still get an error when trying to type in the formula, it says it causes a "Circular reference".Have I written the formula wrong or is something missing?IF({Odd even}=0,IF(MOD(WEEKNUM(T...
Hi @Micki_O_Neil Yes sort of, Record 1-5 is always Uneven weeks, 6-10 is Even weeks. So when Today (yesterday 16th of january) is passed it will become January the 30th instead. Just a date change. So when Today (17th of January) has passed record 2 ...
