ContributionsMost RecentMost LikesSolutionsRe: Create Child Record, Save and then Edit button The child record does not get created ...getting these errors. Create Child Record, Save and then Edit button When I press this URL button it just hangs. Any ideas? I am getting this code from Magic Buttons The button: URLRoot()&"db/"&AppID()&"?a=dbpage&pagename=createchildsaveandedit.html&targetdbid="&[_DBID_Estimator]& "&referencefield=11"& "&rid="&[Record ID#]& "&apptoken=xxx" The code page: <!DOCTYPE HTML> <html> <body> <script> const urlParams = new URLSearchParams(window.location.search); const rid = urlParams.get('rid'); const apptoken = urlParams.get('apptoken'); const targetdbid = urlParams.get('targetdbid'); const referencefield = urlParams.get('referencefield'); const xhttp = new XMLHttpRequest(); xhttp.onreadystatechange = function() { if(this.readyState == 4 && this.status == 200) { const response = this.responseXML; const redirectUrl = "https://" + window.location.hostname + "/db/" + targetdbid + "?a=er&rid=" + response.getElementsByTagName("rid")[0].textContent + "&rl=bbv"; location.href = redirectUrl; } }; xhttp.open("GET", "https://" + window.location.hostname + "/db/" + targetdbid + "?a=API_AddRecord&_fid_" + referencefield + "=" + rid + "&apptoken=" + apptoken, true); xhttp.send(); </script> </body> </html> SolvedRe: Suggestions on writing a pipeline that.... Good idea. Thanks ------------------------------ George Bramhall ------------------------------ Re: Suggestions on writing a pipeline that.... I have done as you mention for new records. Unfortunetly we have been creating this history of price changes for awhile and now the user wants to know the delta for all the existing history records (thousands). So how do I go back and insert the previous effective date and previous price in each of the records in history? How do I write a query to a previous record if the previous effective date is unknown (variable durations between effective dates) ------------------------------ George Bramhall ------------------------------ Re: Suggestions on writing a pipeline that.... yes I thought of that but I would have to write specifc query for each next record. I have thousands of records that need to be searched. More detail: Record 1 has an effective date and a price. Record 2 has an different effective date (duration between dates is variable) and a new price. I want to enter the previous price from record 1 in record 2 so that I can calculate the price delta from Record 1 and Record 2. The changes need to be made for thousands of records each with it's effective date and price, I am only finding the price delta between the previous effective date record and the next effective date. ------------------------------ George Bramhall ------------------------------ Suggestions on writing a pipeline that.... Any suggestions on a pipeline that searchs thru a table looking for a record with a date, capturing a number value in that record and then searching the same table for a record with the next date (next date that follows the prior record date) and then inserts the captured value in a different number field in the "follow on date" record. ------------------------------ George Bramhall ------------------------------ Re: I am not adding a row to my Google Sheet but getting this message when trying to synch pipeline. Interesting. Thanks for doing this research Chayce! ------------------------------ George Bramhall ------------------------------ Re: I am not adding a row to my Google Sheet but getting this message when trying to synch pipeline. In my other Google Channel pipelines that are getting triggered the is_shared: falsedoes not appear when synching. The sheet is shared with Anyone that has the link. ------------------------------ George Bramhall ------------------------------ Re: I am not adding a row to my Google Sheet but getting this message when trying to synch pipeline. Yes, I am adding a row and the pipeline does not get triggered. Question, if I create a row and then delete the data in the row and then add the row again does this count as adding a row or since I had already put data in that row I can no longer add data to that row? ------------------------------ George Bramhall ------------------------------ I am not adding a row to my Google Sheet but getting this message when trying to synch pipeline. Subject line is wrong, I AM adding a row .... What does this mean? ------------------------------ George Bramhall ------------------------------