Jump to content
  • 0
Colnocode

Save original quote

Question

Hi All,

 

We create quotes with Caspio. Each quote has a varying number of records with information such as selected services, quantities , notes etc etc.  (One table)

We often have a number of revisions where we add/change/delete quote records. However, we would like to keep a copy of a quote (all records) once presented;  so that we can refer back to it.  We would like to have many quote and many versions of a quote versions.

I cannot figure how to 'back-up' a quote so we can make changes without loosing the previous version. (Thought to copy the table but that will copy all quotes - not a solution)

Any idea please.

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

I had this type of workflow before.

My workflow is: When updating the Record, it will not really "Update" the record, but it will need an approval first before the actual record is updated. I don't know if that makes sense :D
But think of it as, getting an approval first before updating the Data. 

 

I guess that would work on this type of workflow. 

It's a very crazy trigger, what is does - is it deletes the #inserted record (with conditions of course) then moves the #inserted to another table. This way, unless the conditions on the delete block is met, it will not consider the record updated.

One work around that I could think of, without the trigger is to maybe, just create a submission form below the Reports, so there you can submit the Suggested change.
Or maybe just create something like an audit trail like this one:

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...