Sheets and Selectable lists

Need help
1

In my app I have a view where, in two places, the inputs from a Selectable list “drop down” from a Sheet method are being used. In this App the user needs to select (pick):

Bill to Company - Held in BillCo Groupon the main view

User Primary - Held in Primary Group

In both cases the users can only select from the current list of Companies in the DB.

The selected company can be the same or different for each element.

I’m trying to figure out if I can use 1 sheet with the selectable list (Company) for both selections. Both selections pull from a list of Companies in my DB. …

The primary view opens a sheet element when the users click on the group for entering the Primary Company. I load the Selectable list with all the companies and then I set the custom property of the group on the primary view to the Company thing for the selection. Then I set a Text element on the primary view for the Company Name. When the view is saved to create the record - I set the Company ID in the DB to the Company ID in the Custom Property of that group…. I need to do the exact same for the “bill to” item in the primary view.

I don’t want to have to create the sheet and selectable list every time I need to select a company on a single form.

My initial Rookie thinking was that I could somehow pass the sheet element a variable telling it what item I was trying to set - but…

In summary is there a way to create a sheet element, with a selectable list item and use it to set several properties on the primary view who’s input must be a selection from the same DB list.

2

@rickleehamilton Yes, you can do this with one sheet by making it dynamic. Instead of hardcoding it for “Primary” or “Bill to,” add a custom state or input on the sheet that tells it which field it’s setting. When the user opens the sheet, set that state to either “Primary” or “Bill to.” Then, when a company is selected, write it back to the correct field on the main view based on that state.

Basically, one sheet, one selectable list, and a little conditional logic to know which property to update. No need to duplicate the sheet for each field.