Share
Report
146I have two tables that have a 1TN
ProjectRegister and ProjectRunRegister
When the child table adds multiples of the parent, I want it to take the ProjectNo Parent primary column data i.e ZMZ-0001 and then add R01 or R02 depending on how many of that project instances there are already in the child (ProjectRunRegister), as to multiple runs of the same project over time. It will also have the date as to when that run was launched, this value will go in its own (child) primary column entry, for other tables to draw off.
i.e ZMZ-0001-R01-22110 (yyMMdd)
I can use the workflow process to draw other column data and related entities fine, it's just the sequencing and assessing the amount of that entity that is already present as to identifying the R number
I was hoping I could do something like the below, but I don't think Workflows process will run like a calculated column, I realised the SEQNUM will just count up regardless of knowing how many of that entity runs already exist, even if it could anyway.
{ProjectNo(ProjectRegister)}-R{SEQNUM:2}-{DATETIMEUTC:yyMMdd}
I want to achieve something like the following
ZMZ-0001-R01-221111
ZMZ-0002-R01-221214
ZMZ-0001-R02-230130
ZMZ-0001-R03-230215
ZMZ-0482-R01-230220
Previously I could use formulas in canvas apps for the entries, but I am making model driven forms, I'd like to stick to using a workflow if I can as it seems to be quicker than power automate, but I don't know if its capable of the additional requirements.
What would you do?
All responses (
Answers (
