I know how to create record and display by using the "&disprec=1" tag. I also have used the example code page that allows you to pause and refresh. I would like to combine, as in my use case when I create the parent, I have actions fire which create 3 children. On mobile, it refreshes before the children are created, so i want to add a pause. However, I cannot get it to create the parent, pause, then display the parent. Any ideas?------------------------------Mike Tamoush------------------------------

Yep, that's exactly what I am doing. Except, consider this scenario. Max Record ID = 100. Thus, when I run the code page, I land on Record ID 101 (100+1). Perfect. Now this scenario: Max Record ID =101. User deletes Record 101. Now Max Record ID =100. Thus, next record created will be 102, but the code page will try to navigate to Max Record (100) + 1, or record 101 (which has been deleted). Two possible solves I see: Make it so the user can't delete the max record. Or, make an action so that if the max record ID is deleted, a 'dummy' orphaned child is created, thus ensuring that the next Record ID created will still be Max + 1. I went with option 2 and it is working. The real issue is we keep saying we want the Max ID + 1, but in reality we want the NEXT Record ID created, which USUALLY is the Max ID + 1, but not always. The above action now makes it always that way.------------------------------Mike Tamoush------------------------------

Can you not use the same code page approach? Have your button save the record and use the %%rid%% to pass in a parameter like &rid=%%rid%%, then in your code page grab the parameter from the URL and redirect the user back to the page after a setTimeout()------------------------------Chayce Duncan------------------------------

That probably would work if I knew Javascript. As it is, all I can try to do is modify the existing code page which I have tried and failed miserably. Turns out you can't really just guess your way through a programming language :)------------------------------Mike Tamoush------------------------------

Actually that wont work. The problem is I am not on the parent record when it is 'saved'. I am on a grandparent (though, at the time of the button push, it is not a parent or grandparent, it is a single record). I push a button and it runs the AddRecord API, adding a child. I want to delay, and then land on this child. I would need to somehow pass the RID of the new child.&disprec=1 performs some sort of magic that auto displays the newly created record. I would somehow need to know what magic it performs, and pass that magic into the code page. Though it did just dawn on me, i can look up the max record id in the child table, and navigate to 1 more than that.....if I can figure out how to pass that +1 record ID to the code page....ill try it. Update - I am not good enough at javascript to modify the code page, but I suspect my idea would work. But, i would need a parent table to get the max record id and pass it back through, which i can do but is a bit annoying...not sure there are any other solutions though. ------------------------------Mike Tamoush------------------------------

The Max Record ID# would probably only work if the child creation is sequential no? Can you guarantee that the new grandchild is sequenced correctly? From your description the easiest and best solution is still javascript where by instead of having your current button create the record - you move it to a code page, add the record, get the response back and then redirect the user. The best I can offer is some generic functions though that would get you moving: const tempToken = (dbid) => { return new Promise((resolve,reject) => { var headers = { 'QB-Realm-Hostname': 'your realm name', 'QB-App-Token': 'your app token, 'Content-Type': 'application/json' } fetch(`https://api.quickbase.com/v1/auth/temporary/${dbid}`, { method: 'GET', headers: headers, credentials: 'include' }) .then(res => { if (res.ok) { return res.json().then(res => resolve(res.temporaryAuthorization)); } return res.json().then(resBody => reject({status: res.status, ...resBody})); }).catch(err => reject(err)) }) } const upsert = (token) => { return new Promise((resolve,reject) => { var headers = { 'QB-Realm-Hostname': 'your realm name', 'Authorization': `QB-TEMP-TOKEN ${token}`, 'Content-Type': 'application/json' } var body = { to: 'target dbid data: [ { "field": { value: ""}, "field": { value: ""}, "field": { value: ""}, } ], mergeFieldId: commit.mergeFieldId, fieldsToReturn: [3] } fetch('https://api.quickbase.com/v1/records', { method: 'POST', headers: headers, body: JSON.stringify(body) }) .then(res => { if (res.ok) { return res.json().then(res => resolve(res)); } return res.json().then(resBody => reject({status: res.status, ...resBody})); }).catch(err => reject(err)) }) } //invoke functions tempToken("").then((token) => { upsert(token).then((res) => { var newRid = res.metadata.createdRecordIds[0] window.location.replace("/dbid/?a=dr&rid=" + newRid) }) }) ------------------------------Chayce Duncan------------------------------

Create Record, pause, then display record

17 Replies

ChayceDuncan
Qrew Captain
4 months ago
Can you not use the same code page approach? Have your button save the record and use the %%rid%% to pass in a parameter like &rid=%%rid%%, then in your code page grab the parameter from the URL and redirect the user back to the page after a setTimeout()

------------------------------
Chayce Duncan
------------------------------
- MikeTamoush
  Qrew Commander
  4 months ago
  That probably would work if I knew Javascript. As it is, all I can try to do is modify the existing code page which I have tried and failed miserably. Turns out you can't really just guess your way through a programming language :)
  
  ------------------------------
  Mike Tamoush
  ------------------------------
  - MikeTamoush
    Qrew Commander
    4 months ago
    Actually that wont work. The problem is I am not on the parent record when it is 'saved'.
    
    I am on a grandparent (though, at the time of the button push, it is not a parent or grandparent, it is a single record). I push a button and it runs the AddRecord API, adding a child. I want to delay, and then land on this child. I would need to somehow pass the RID of the new child.&disprec=1 performs some sort of magic that auto displays the newly created record. I would somehow need to know what magic it performs, and pass that magic into the code page.
    
    Though it did just dawn on me, i can look up the max record id in the child table, and navigate to 1 more than that.....if I can figure out how to pass that +1 record ID to the code page....ill try it.
    
    Update - I am not good enough at javascript to modify the code page, but I suspect my idea would work. But, i would need a parent table to get the max record id and pass it back through, which i can do but is a bit annoying...not sure there are any other solutions though.
    
    ------------------------------
    Mike Tamoush
    ------------------------------
SimonH
Qrew Cadet
4 months ago
Sounds like a good use of the this magic button
https://www.youtube.com/watch?v=GCpXhYQM-w8

You would just need to make a slight modification to the code page to insert a pause

------------------------------
Simon H
------------------------------
- MikeTamoush
  Qrew Commander
  4 months ago
  Actually, might not even need the pause using that magic button Simon. Ill take a look, thanks!
  
  ------------------------------
  Mike Tamoush
  ------------------------------

Forum Discussion

Create Record, pause, then display record

17 Replies

Related Content

Bulk create child records from selection list

Button: save the new record and edit the new record

Create a formula duration over 5 years

How to add list of attachments on child record from parent record

Filter records based on table connection

Recent Discussions

When the Expiration Date is On or Before Today, Change the Contract Status to Expired

Forms help

'Is Set' in Pipelines

Share your feedback on the new Qrew Discussions

Empower Next Week!