ContributionsMost RecentMost LikesSolutionsRe: Return field value after saving from a formula URLThat's a brilliant idea. Thanks Mark! ------------------------------ Bill Burrrell ------------------------------ Return field value after saving from a formula URL So I'm not sure this is possible without some major reworking. I have a formula URL that passes some info to create a new parent record. What I need is to pull on of the parent record fields and return it once the parent is saved. The parent record contains projects and information on them and the child record is quotes. So when a quote is awarded we want to make the project record. From the Project Record I'm looking to return the Project Number to the Quote so I can link them. I've attached the code I have so far. URLRoot() & "db/" & [_DBID_PROJECTS] & "?a=API_GenAddRecordForm&_fid_317=" & URLEncode ([Record ID#]) //transfer Division information to new project & "&_fid_6=" & [Division] //transfer Quote Name to new project as Project Name & "&_fid_75=" & [Quote Name] //transfer Customer information to new project & "&_fid_49=" & [Related Customer] //transfer Contact information to new project & "&_fid_25=" & [Related Contact] //transfer Estimated Cost information to new project & "&_fid_46=" & [Estimated Cost] //transfer Tendered Amount (Subtotal/Contract Amount) information to new project & "&_fid_45=" & [Quote Sub Total] & "&z=" & Rurl() ------------------------------ Bill Burrrell ------------------------------ Download Report and Mark entries as downloadedSo I'm trying to setup a system that gets me a file of a set of entries from one table. I need it as a .xlsx, but I can convert the file from a .csv easy enough. I also need to mark all entries that are exported as exported. I'm hoping to get do everything from a single click, up to the export anyway (the file conversion can be done manually). So I'm currently looking at using a URL button to launch a code page. I'm using a report to pass the fields/data to be used and exported. I've managed to get the URL button to work. But I'm struggling with setting up the code page, mostly since I don't have much experience with Javascript. This has been enough to get the button to function for the download, but I'm having a hard time figuring out the next steps. I've got this far mostly by taking a large number of examples from others on here and playing around a bunch. I'm assuming I'll have to use the DoQueryCount and EditRecord APIs in a loop of sorts to update each record. I've got a simple checkbox, [Exported], for tracking the files that have been exported. Any advice/suggestions would be appreciated. //URL button code var text GetReport = "?a=q&qid=10"; var text DownloadReport = "&opts=csv"; URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=42" & // code page "&url=" & URLEncode(URLRoot() & "db/" & Dbid() & $GetReport) & //passed to code page for marking records downloaded "&rdrurl=" & URLEncode(URLRoot() & "db/" & Dbid() & $GetReport & $DownloadReport)//passed for final redirect //Code Page <!DOCTYPE html> <html> <head> <script> var urlParams = new URLSearchParams(window.location.search); var url = urlParams.get('url'); var rdrurl = urlParams.get('rdrurl'); window.open(url,'Print'); window.location.href = rdrurl; </script> </head> </html> ------------------------------ Bill Burrrell ------------------------------