My app structure has tables: Contacts, Tasks and Service Locations all referenced by its related Company. Said another way a Company has many tasks, service locations and contacts. A service location has a repairs table. Currently the Service Location Repair form has a place to enter an email address which is currently getting its initial value from the Service Location table via the expression [Service Location].[Manifest Email].
I’d like to get this value instead from the contacts table email column when their role selected from the enum is “Manifest” I was hoping to use an action that fires to change the value of the Service Location Repair table column “manifest email” when the role “Manifest” is assigned to that contact.
Tables Service Location Repair and Contact are not related. Is it possible to do this and what would the expression look like?
Perhaps a quicker way to do this would be to have the workflow PDF that is created from the service location repair from submission get is email address from the contact that has the role “Manifest” assigned to them but I’m not sure if that is possible either.
I’ve solved a lot of questions on my own but this one has me stumped. Thanks for your help.