Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
6 years ago

Cross App Behavior

I have table relationships across apps. I have a master tables app, which feeds into two different management apps.

When I am in an management app, I have a projects table. I can 'add invoice' from this table, and this has a relationship to an invoice table in my master app. The relationship is one project has many invoices.

When I click add invoice, Quickbase smartly makes it not really look like I have left the project management app. This is perfect. However, if I save the invoice, or cancel out of it, it defaults me to the invoice table in my master app.

Is there a way for it to always default into the first app? I want my users to stay out of my master app, and just access tables.

Thank you.



------------------------------
Mike Tamoush
------------------------------
APIs and custom code
Relationships
  • BrianCafferelli's avatar
    BrianCafferelli
    Quickbase Staff
    6 years ago
    Hi Mike, you can update your Add Invoice formula to set the nextURL parameter to ensure that, every time a user clicks the button, they will always be redirected to the parent project:

    URLRoot() & "db/" & [_DBID_PROJECTS] & "?act=API_GenAddRecordForm&_fid_48=" & [Record ID#] & "&nextURL=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])

    One thing to note with this formula is, even if users click the button while on a Projects report, after adding the related invoice they'll be redirected to the form for the parent project record.

    ------------------------------
    Brian Cafferelli
    ------------------------------