Formula text button to create Quick Base Action (Add Record) and redirect to that record

Question

I have a formula text button in a table to check a box in one table, fire an Action to create a new record in another table. Right now the formula takes me back to the original table. I need to go to the record in the new table.

quickbasecoachd · Answer

I suspect that will be impossible as to redirect to that newly created record, you would need to know the Record ID, and that is not know at the time the button is pushed.

One solution would be to redirect the user to a report of records created just now (in that table of records that the Action created). So a report sorted by date created, newest on the top and created in the last minute.

I was going to suggest a report of records a "I" created today by the current user, but I think that the [Record Owner], unfortunately is the Action Owner and not the Current user.

So basically land the user on a report where the top record on the report is likely the one that just was created.

_anomdiebolt_ · Answer

Why not just bind a script to your button and use some simple JavaScript to call API_AddRecord and redirect to precisely the URL you want? The features that QuickBase has added (I am looking at you actions) perform a specific task but in a hardcoded way and don't have any extra configuration if you don't see a control in the graphical interface.

Just go all in on using script any these and other obstacles evaporate.

paulvorster1 · Answer

Hi Dan, can you maybe supply me with an example of your statement above, as I am trying to do exactly the same?

quickbasecoachd · Answer

Paul,can you explain what you are trying to do?&nbsp; Maybe there is a non script solution.&nbsp; If you use a regular API to API_AddRecord and suffix it with &amp;disprec=1 then it will land the use on the newly created record.

paulvorster1 · Answer

Hi Mark, thank you for responding swiftly...I am in the process of developing a Customer Call Centre and the the call centre agent needs to Verify the Customer Details as "Passed" or "Failed". &nbsp;The trick of these two buttons are, the record hasn't been created yet. &nbsp;I have managed to get "Passed" working, by using the "SaveAndNextTab.js" provided by Alex Wilkinson (https://community.quickbase.com/quickbase/topics/how-do-i-create-a-button-that-allows-the-user-to-continue-to-the-next-tab). &nbsp;I am now struggling to configure the "Failed" button, because it doesn't go to the next tab, but it goes to a different tab or different form. &nbsp;I hope this makes sense...in essence I need to register the record, update the checkbox for "Failed" and move to a tab or a form to provide comments for Failure. &nbsp;As I have realised, you need to run two separate calls, 1. Creating the Record, and 2. redirecting to the Tab/Form (I know you have provided a solution to go back to a report, but unfortunately the call centre agents works against time, and they need to click on a new tab or form). &nbsp;I am willing to share my app as well, if you want to look at the code?&nbsp;

Forum Discussion

Formula text button to create Quick Base Action (Add Record) and redirect to that record