Page Refresh Challenge and Symptom
I have a two have formula field buttons with different yet similar functionality. The first one: Clones an existing table record, with its related detail records, that a user is viewing/editing...
Forum Discussion
Typically writing script is beyond what developers offer for free on this forum. I suggest you contact Dan directly and engage him to do the work. I have used Dan in the past myself when non native coding is required.
Actually I frequently post scripts for unique solutions to forum questions and I am tending towards only posting to threads with script solutions. My priorities in answering questions generally involve promoting using script to solve novel problems or demonstrating that some seemingly "impossible" or "difficult" problem is in fact readily solvable with script.
To be honest and not meaning to offend anyone, I can't keep up with the volume of daily messages since the move to the new forum software and in a lot of cases the person answering the question is putting way more effort into clarifying the issue than the original poster (this does not apply to your question - no offense intended). And a lot of times the original poster does not even include a question mark in their message - that makes no sense to me.
But in any event, I think you need code similar to this:
I didn't test it but you should be able to make progress by filling in the parameters {dbid, dbidWidgetDetails, dbidWidgets, apptoken, #######, #######} and pasting the script into the console and examining the debug statements.
Beyond that advice, feel free to contact me off-world if you need individual assistance implementing this solution using the information in my profile:
https://community.quickbase.com/people/dandiebolt
To be honest and not meaning to offend anyone, I can't keep up with the volume of daily messages since the move to the new forum software and in a lot of cases the person answering the question is putting way more effort into clarifying the issue than the original poster (this does not apply to your question - no offense intended). And a lot of times the original poster does not even include a question mark in their message - that makes no sense to me.
But in any event, I think you need code similar to this:
(function(){
var dbid = "";
var dbidWidgetDetails = "";
var dbidWidgets = "";
var apptoken = "";
$.ajaxSetup({data: {apptoken: apptoken}});
var urlAzureAPI = 'http://#######.azurewebsites.net/api/########?db=${dbidWidgetDetails}&rid=${kRid}';
var urlProcessed = '${dbidWidgets}?act=API_EditRecord&rid=${kRid}&_fid_60=true';
var urlRefreshRecord = '${dbidWidgets}?a=dr&rid=${kRid}';
console.log(kRid);
console.log(urlAzureAPI);
console.log(urlProcessed);
console.log(urlRefreshRecord);
$.get(azureAPI)
.then(function(response) {
console.log(response);
$.get(urlProcessed, function(xml) {
console.log(xml);
document.location = urlRefreshRecord;
});
});
})();I didn't test it but you should be able to make progress by filling in the parameters {dbid, dbidWidgetDetails, dbidWidgets, apptoken, #######, #######} and pasting the script into the console and examining the debug statements.
Beyond that advice, feel free to contact me off-world if you need individual assistance implementing this solution using the information in my profile:
https://community.quickbase.com/people/dandiebolt