Forum Discussion

ZintJoseph's avatar
ZintJoseph
Qrew Captain
7 years ago

Updating quotes being pulled from a snapshot field

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...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
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))