Button Formula

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • In Progress
Is there a way to create a button that will take you to the next related record? We are trying to create a form for schools where they can add up to 5 activities, after adding those 5 activities(I'm thinking related records) we would ask them for details about each activity. I would like a button to take them from the first activity to the next keeping them within their 5 records. Does that make any sense?

Photo of Luisana Cardenas

Luisana Cardenas

  • 194 Points 100 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
So there's a master table that your form is on, and then you have an Activities child table? And you have a button to Add Activity on the form on the master table? Or I guess that part of the workflow isn't critical - your point is that after the activities are added, your user is on the form on the master table, and you want them to be able to flow from edit related activity to edit related activity?

If I'm understanding you, you can accomplish this just by putting a Report Link field on the master form that has Related Activities. Once the user clicks into the first one, the native
 < Prev | ^ Return | Next > 
controls will do what you need them to do, no?
You could also build out a url button that uses an "invisible" report to duplicate some of that functionality with less reliance on the user to click the "right" record or report. There's some useful discussion at https://community.quickbase.com/quickbase/topics/next-available-record-based-on-an-empty-field about how to dynamically find conforming record IDs to plug into a URL formula that might be a promising line for this need.