I’m new to Airtable (and just bad at coding in general), and I’m stuck on what I think must be a very simple problem.
Four days per week, I want to create a new record that is due tomorrow. As in, on Monday at noon, a task appear that is due Tuesday. On Tuesday, it’s due Wednesday, etc.
I’ve tried putting various formulas into my ‘Due Date’ field, but I keep getting a “Could not convert string to date” error.
I want to be able to add due dates manually for other tasks, I just want this specific task to have the due date automatically added.
You cannot use a formula directly as an automation value. This, you must get the value of tomorrow’s date from somewhere else. Here are some possible sources