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...
Hey everyone
Having problem with an automation when a record is checked, a copy of the record is made in another table. The problem is that it works ok when doing it slow and one record at the time, but I want to take all the checked records at the s...
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 ...
Hi @Andrey_Kovalev it looks great the only thing is that you have change the autonumber to numbers so the second Monday starts on 8. Will be interesting to see how it moves after midnight! Thank you again for your time and solution!Best regardsJesper