Skip to main content
Question

Updating quotes being pulled from a snapshot field

  • February 1, 2018
  • 0 replies
  • 96 views
I have a material price table and a quote table that takes a snapshot of the price when each items is quoted. My issue now is that I have multiple quotes note ordered yet and need to update the prices in the quote. Is there a way to create a formula button in each quote that will take a new snapshot of the new pricing and auto update the single quote

      Joey,
      I believe that if you de-link the lookup and then re-link it, then the snapshots will refresh.  Can you contact me directly via the info in my website QuickBaseCoach.com and I will do that code for you at no charge and then post it back here after.
      Mark
      • ZintJoseph
      • Author
      • Registered
      • February 2, 2018
      Is there a way to force the snapshot after a record is created. My issue at this point is I have added a second snapshot field and need to use that for new values. It is blank at this point so I need to force a snapshot on old records
      not tested but the code would be like this

      var text Delink = urlroot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
      & "&_fid_99=";

      var text Relink = urlroot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
      & "&_fid_99=" & [Related Parent];
       
      var text DisplayRecord - urlroot() & "db/" & dbid() & "?a=-dr&rid=" & [Record ID#];

      $Delink  
      & "&rdr=" & URLEncode($Relink)
      & URLEncode("&rdr=" & URLEncode($DisplayRecord))
      Terms & ConditionsAccessibility statement