EthanWinter
2 hours agoQrew Member
Interview form using multiple tables
Hey there. I'm trying to build a form that would be used during interviews with customers that represent ISPs or "networks." Each customer would be a new Network and that Network can have many Communities, Activities, Statistics, or Payments Plans associated with it. I'm running into several issues:
- When a network is new at the start of the interview, a record will not exist yet, so there cannot be a recordID yet. So, let's say an Interviewer enters information for Network X on page 1, then moves to page 2 to enter Communities affiliated with Network X. They would hit on the "Add Community" button page 2. A pop up opens but there isn't a network affiliated with the new Community record. I'm pretty sure I can get around this by making a rule or a button that forces the Network entry to be saved before moving to page 2. But I can't find a conclusive way to make a Save and Keep Working button and the default button is hidden at the end of the form.
- Let's say I save the network before moving to the next page. Now on Page 2 (Communities), if my interviewer hits a button to add Community, a pop up appears, they enter the information, and hit save. The pop up does not automatically redirect to the original interview form. It seems I would need to make a custom save button to do that.
Is there a more efficient way to build a data entry form in Quickbase that involves multiple tables without needing to build a bunch of custom buttons? I feel that I might be missing something obvious here.
Thank you