Change 'Add New' action to a populated enum list

[JBGreenpaths]

Hello,

I have a form that populates a field (account) based on the page the action was on  (account details page). This also sorts a contact table to populate the contacts associated with that store. This all works great, however the 'add new' button on the list (in the instance where a contact doesn't already exist or there's a need to add an additional contact, opens a form without the store populated. I believe it's a system generated add new but I can't figure out where to customize that. My thinking is that if I do a lookup by userID for the last row on the previous form, it will populate the necessary store but I can't figure out where to do that. 

[Denny774]

Hey man,

it's simple. You forgot to set the Contact "Is part of" Store in the Field Settings 😅

[JBGreenpaths]

Yeah, I tried that but it doesn't work. The stores page uses an action that adds a row to another table and opens a new page, this interaction page, the interaction page has a ref to both stores and contacts which populates fine, unless I try to add a new one.

[Denny774]

Hey,

that's even simpler 😄
Interaction Page Dataset.[Contact].[Store] = Interaction Page Dataset.[Store]

[JBGreenpaths · Accepted solution]

Nah, that doesn't work either. I used the initial value and a lookup for the maxrow and it works great. 

[Denny774]

Hey,

maxrow works but is not a good solution imo. What if two users add a new contact at the same time? 😅

[JBGreenpaths]

Maxrow by userid