Updating quotes being pulled from a snapshot field

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
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
Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb

Posted 9 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,006 Points 50k badge 2x thumb
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
Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb
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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,006 Points 50k badge 2x thumb
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))