Forum Discussion

GrantK's avatar
GrantK
Qrew Trainee
22 days 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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend

Here are some thoughts and resources.

  1. discussion blog here https://community.quickbase.com/discussions/quickbase-discussions/using-code-pages-to-refresh-with-a-delay/83697
  2. Code page example app here https://resources.quickbase.com/db/bq8kmgrcq/72b77352-3b9d-495e-932f-1cd9f1b15fa3
  3. 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. 
  4. 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's avatar
GrantK
Qrew Trainee
21 days 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.