Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Keep Record setting when formula runs

599 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello everyone! 

I have this table:

Skærmbillede 2022-12-08 kl. 14.58.44.pngThe issue right now is that when I in 'Næste gang?' selects an option, fx. 'Daily' or 'Weekly', the Record will update and get a new deadline based on my choise (daily or weekly). However the Record also looses all it's data, fx. Assignee and the 'How often' all the way to the right (let me show you): 

Skærmbillede 2022-12-08 kl. 15.04.14.png

 How do I change this, so that the Record will appear in the right Group when updated? 

3 Replies 3

Hmm, I'm having trouble understanding your table. From what I can tell, you have four fields with data: Task, Date, Yes/No, Frequency/How Often. I'm not sure what "Næste gang?" is, since what you describe sounds like a dropdown that interacts with a script or automation. My best guess based on the information provided is that your script/automation creates a new record and copies the record name, but not the other data associated with the record – if so, then the solution is to edit the script/automation to include the data.

Hello  @Andy_Lin1 

Thanks for getting back! 

So 'Næste gang?' would be "When should the deadline for this task be next time?" -> the user can then choose between 'A week', '1 day' or '3 days'. 

Skærmbillede 2022-12-09 kl. 09.37.15.png

 Then the field 'Næste deadline' (Next deadline) looks at the choice of the above and automatically adds the next date. Is it in this formula I should add the data for the rest of the Record, fx. Assignee?