Forum Discussion

Qrew Trainee

3 months ago

Button to Add Record via Pipeline, and refresh Record

Hi All, I am having troubles trying to via a button to add a new record then refresh the current record. As a button can't trigger a Pipeline, I've created a checkbox field to act as a trigger fiel...

formula query

MarkShnier__You
3 months ago
Here are some thoughts and resources.
discussion blog here https://community.quickbase.com/discussions/quickbase-discussions/using-code-pages-to-refresh-with-a-delay/83697
Code page example app here https://resources.quickbase.com/db/bq8kmgrcq/72b77352-3b9d-495e-932f-1cd9f1b15fa3
An alternative is to power through that button to add the child record using the URL formula syntax thus providing a good user experience to see the child record on refresh, but use a Pipeline to write back the RID of the newly created record to its parent. Your user probably does not need that immediately on refresh. You would trigger the Pipeline on the creation of the child record.
Put the child table in a Tab such that by the time the user opens the tab, the pipeline will have run. I vividly recall being at an in person EMPOWER event when Automations first came out and QuickBase used that sleight of hand to allow time for the Automation to complete.

MarkShnier__You

Qrew Legend

3 months ago

Here are some thoughts and resources.

discussion blog here https://community.quickbase.com/discussions/quickbase-discussions/using-code-pages-to-refresh-with-a-delay/83697
Code page example app here https://resources.quickbase.com/db/bq8kmgrcq/72b77352-3b9d-495e-932f-1cd9f1b15fa3
An alternative is to power through that button to add the child record using the URL formula syntax thus providing a good user experience to see the child record on refresh, but use a Pipeline to write back the RID of the newly created record to its parent. Your user probably does not need that immediately on refresh. You would trigger the Pipeline on the creation of the child record.
Put the child table in a Tab such that by the time the user opens the tab, the pipeline will have run. I vividly recall being at an in person EMPOWER event when Automations first came out and QuickBase used that sleight of hand to allow time for the Automation to complete.

GrantK
Qrew Trainee
3 months ago
Hi Mark,
Thanks for the tips. I managed to get it working using the code page sample. I didn't get around to trying point3&4 but understand the thought process and will remember it for possible future requirements. Thanks again for your assistance.