is it possible to run an automation before save?

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • In Progress
Hi All,

I have a summary field called total in parent table, and in the detail table i have the values,

Now i have to capture the summary field value in the history table , before i save the detail table values when there is a change in the details table.

is it possible to run the automation before the save , so that i can run a action to capture the old summary value

its urgent , can some one please help

Thanks
Photo of Pushpakumar Gnanadurai

Posted 1 month ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 57,418 Points 50k badge 2x thumb
I suggest that you trigger an Automation to record the Parent summary value upon any add modify delete change to the child records. Then you will always have the complete history. You do not need to record anything in the instant before the save, just record everything after the save and you will have a compete history.
Hi ,

The moment i change the value in detail table , the summary is recalculated . Now the parent has the new summary value. 

Automation will run only after the save. So it is of no use . 

Before the automation triggers , the value in the parent table changes.

Thanks
Pushpakumar
can you please suggest is there any other way possible. I cant use snap shot since it is a formula based field
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 57,418 Points 50k badge 2x thumb
There is no problem with what I suggested. Just record the value of that summary field in a history table after each edit of the child tables records, What are you seeing as the problem with that solution?
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 57,418 Points 50k badge 2x thumb
I suggest that you try my solution and then post back if there is a problem.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 28,924 Points 20k badge 2x thumb
There are multiple ways to do this with script. Unfortunately I am not going to create a demo as it would be very specific to choices I might make in an implementation and may not map to your situation as your question is rather broad (no table, relationship, field details).

>its urgent , can some one please help

If you need individual assistance feel free to contact me off-world using the information in my profile:

https://getsatisfaction.com/people/dandiebolt