I will pay you $100 (USD) via PayPal to develop the following template. I will release it as a free template to demonstrate this type of Master/Detail processing with multi-function forms. Since it is a template, it should be “best practice”. It is a teaching tool rather than an actual app so the interface doesn’t have to be “pretty” or “sophisticated”, just simple, clear and functional. Feel free to make suggestions and clarify any uncertainties you have.
The app has basic Sign Up, Log in, Log Out, Profile maintenance functions. This is only a secondary concern so don’t spend unnecessary time on it.
The index page has a simple message: “This template shows how to manage Master/Detail data structures using multi-function forms. It is a teaching tool for a concept rather than the basis for an app.”
Data
A Master can have zero or more Details (one to many).
A Detail belongs to a single Master (one to one).
Master has the following fields:
Name
Type
Description
Detail has the following fields:
Name
Master (required, the Master that owns this Detail, selected from a drop-down)
Type
Field descriptions
Names are text and required. The app removes leading and trailing and reduces multiple embedded blanks to one after the name is entered. Master names must be unique. Detail names must be unique within the Master they belong to.
Types are required, selected from a drop-down based on an option set. There is one option set for Masters and a separate set for Details. There are two sample entries in each option set, the actual text doesn’t matter.
Descriptions are text and required. Any contents are acceptable. No processing is done on them.
Functions
New allows users to create new records
Update allows users to change fields on existing records
Display allows users to see the information but not add, change or delete anything
Delete allows users to delete existing records.
Display allows a class of users to review records without allowing them to add, change or delete anything.
When the Delete button is clicked, the app displays the corresponding pop-up and requires the user to confirm the delete by clicking a Delete button on the bottom. If they delete a Master, the app deletes all its Details as well. In this case, the app informs the user of the consequence of the action.
There is a pop-up for Master and another for Detail. Each pop-up handles the four functions listed above. Each pop-up has a Cancel button as well as the New/Update/Delete function button. The YouTube video “Processing data in popups | Bubble.io tutorial” shows how to do this if you need it.
Use case
User selects a Master from a drop-down
App shows the name, type and modified date of the Master in a one-row repeating group with Display, Update and Delete buttons. There is a separate New button to add new Masters.
App shows the name, type, and modified date of Details (if any) for the selected Master in a repeating group with many rows. Each row has Display, Update and Delete buttons. There is a separate New button to add new Details.
When the user clicks New, Display, Update and Delete buttons, app shows the corresponding Master or Detail pop-up. After the function is complete the pop-up workflow resets the input fields and hides the form.