Hi. I’m looking for some help for a formula.
We’ve created a button that adds several pre defined tasks to our local organization table, and we currently have a date offset on each task that defines the number of days before the event that the tasks should be performed (due date). I’d like to automatically add the Due dates for each task based on this offset. Preferably with a popup text box or a date input when hitting the automation button.
Here is what I’ve got so far. This is a table of my Norwegian table of project (column 2), task name (column 1), due date (column 3) and offset (column 4).
My current “Create event” button does the following (I’ll translate to English to make it more understandable)
[DB Master Task].Filter(CurrentValue.Project=[External event]).FormulaMap(
[DB Local Task Table].AddRow(
[DB Local Task Table].Project, CurrentValue.Project,
[DB Local Task Table].Title, CurrentValue.Title,
[DB Local Task Table].Due Date, CurrentValue.Due Date,
[DB Local Task Table].Offset, CurrentValue.Offset
Are there any way to prompt the user for an input with a text box? Or would I have to add a date picker field that you use as an input before the button is hit?
And how would you suggest that I incorporate the “add due date based on offset and user input”?
Would it be as simple as something like this (replacing just the one line above)?
[DB Local Task Table].Due Date, CurrentValue.Offset + DateInputfield,
Any suggestions are appreciated, as I’m a pretty novice scripter