Button Formula
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 ...
Forum Discussion
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?
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.