Skip to main content
Question

Documents with many records action

  • July 27, 2018
  • 0 replies
  • 97 views
I have a lot of documents that can have many records (Revisions) and many task.  I want to create an action in which when I add a new record (Revision C) that the old record of that document (Revision B) will change in status.   Basically that only the latest revision will be "in use" and the others will be "closed".  
This topic has been closed for replies.

Rather than an Action which would require the system knowing which Record ID# to edit, I suggest a different approach.  I suggest making a summary maximum of the [Record ID#] of the revisions and then look that up down to the Revisions.

Then you can have a formula which calculates if the revision [Record ID#] = the most recent (Highest) Revision [Record ID#]. 

There are enhancements on that technique if you like to mark Revisions as Valid in case you need to roll back and disqualify a recently loaded Revisions.  In that case the system would take the highest [Record ID#] of valid Revisions in that Summary Maximum field.
  • ArchiveUser
  • Author
  • Quickbase Alumni
  • July 27, 2018
I'm not sure I follow you.  Are you saying inside the document table I could create a formula that would change old revisions to closed or that the status would be a formula?  
I already have where the maximum revision status is shown on the document, but I want to make sure the previous records (revisions) get closed out once new ones develop for that related document.
Iļæ½m suggesting that the status of a Document would be a formula field and not a manual drop down data entry field.
Terms & ConditionsAccessibility statement