Apr 15, 2022 07:46 AM
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.
Apr 15, 2022 10:47 AM
Apr 15, 2022 11:01 AM
Does that require the field to be a Formula field? It’s currently a Date field, and I’d like to keep it that way so that I can update it manually.
Apr 15, 2022 05:14 PM
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