I’m having some continued problems getting with related entries into a table and getting a workflow to execute the way I would like, so I’m hoping the community of experts could possibly give some pointers.
The main table is TWUAOrders with the most important fields:
[ReportingRequirement] - EnumList (“In-State”,“Out-of-State”,“Other”)
[Related WaterUseDatas] - Ref to WaterUseData Table
[Most Recent WaterUseData] - Selects only the last entries for [Related WaterUseData]
Related table WaterUseData:
[Date] - This gets generated based on a dynamic expression from the TWUAOrders info
[Amount_Pumped] - Ideally needs to be required
[TWUAUseCategory] - Enum (“In-State”,“Out-of-State”,“Other”)
Workflow:
Option 1 -
Needs to get triggered on WaterUseData ‘ADD’ but only after the TWUAOrders Ref has a current entry for each of the “In-State”,“Out-of-State”,“Other”. This is accomplished by comparing the current WaterUseData [TWUAUseCategory] against the last selected choice in the TWUAOrders entry and will only get executed then. I have an action button in the TWUAOrders_Detail view for each of the 3 options so this current setup is highly dependent on the user clicking these action buttons in the proper sequence. Is there a possibility under this scenario to save a WaterUseData row and then proceed to the form of the next WaterUseData form?
Option 2 -
Have a single action button under TWUAOrders_Detail that automatically creates each of up to 3 entries in the WaterUseData where it sets the [Amount_Pumped] to ‘null’, then navigates to the TWUAOrders [Most Recent WaterUseData] inline table in quick edit mode at which time the [Amount_Pumped] would be required so that the user has to overwrite the null values. Workflow would then trigger only if the [Most Recent WaterUseData] [Amount_Pumped] values are not null. Again this scenario also heavily relies on the user to actually change the null values as apparently the quick edit on a table does not enforce the required [Amount_Pumped] field if that field uses an expression for the required_if check.
If anyone has a different approach I would also very much appreciate any input.
LinkedIn
Twitter
