That's just it. I don't have any code. I set mine up in a test form to see how I could get it to work but I have no idea how to implement it to do what I'm trying to do.
I had another form I created that does the same type of thing and had no combo boxes in it. That worked perfectly. Adding the multi-select combo boxes throws a wrench into the works. The OnChange of each input field has a call to a hidden button in the form using the following:
If(
ThisItem.Status = "Approved",
Select(FormUpdateButton)
)
The FormUpdateButton code is as follows:
If(
Or(
Not(ThisItem.Country = CountryValue.Text),
Or(
Not(ThisItem.'A' = ValueA.Value),
Or(
Not(ThisItem.'A1'.Value = ValueA1.SelectedItems.Value),
Or(
Not(ThisItem.'A2'.Value = ValueA2.SelectedItems.Value),
Or(
Not(ThisItem.'A1a' = ValueA1a.Value),
Or(
Not(ThisItem.'A1b' = ValueA1b.Value),
Or(
Not(ThisItem.'A1b1' = ValueA1b1.Text),
Or(
Not(ThisItem.'A3' = ValueA3.Value),
Or(
Not(ThisItem.'A3a' = ValueA3a.HtmlText),
Or(
Not(ThisItem.'A4' = ValueA4.Value),
Or(
Not(ThisItem.'A4a' = ValueA4a.HtmlText),
Or(
Not(ThisItem.'A5' = ValueA5.Value),
Or(
Not(ThisItem.'A5A' = ValueA5a.HtmlText),
Or(
Not(ThisItem.'B' = ValueB.Value),
Or(
Not(ThisItem.'B1'.Value = ValueB1.SelectedItems.Value),
Or(
Not(ThisItem.'B2'.Value = ValueB2.SelectedItems.Value),
Or(
Not(ThisItem.'C' = ValueC.Value),
Not(ThisItem.'C1' = ValueC1.HtmlText)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
)
,
Set(
varFormUpdated,
true
);
Set(
varStatus,
"Draft"
);
Set(
varNoticeSent,
false
);
,
Set(
varFormUpdated,
false
);
Set(
varStatus,
Blank()
);
Set(
varNoticeSent,
LookUp(
'PSMF Requirements',
ID = Value(IDValue.Text),
'Approval Notice Sent'
)
);
);
This is checking every required input field for changes. If there are changes, approval may be required so I'm using the results to expose the approval portions of the form when necessary.
But of course, the comparison of the A1, A2, B1 and B2 fields and their corresponding combo boxes on the form does not work. I get the error that a table can't be compared to a table. Have tried different variations such as adding .Value behind each. No difference. I tried replacing the ValueA1.SelectedItems with your filter code and that also doesn't work. I get an error about it expecting a single column table.
Again, all I'm trying to do is compare the saved values of fields A1, A2, B1 and B2 with the values in the corresponding combo boxes (ValueA1, ValueA2, ValueB1 and ValueB2) when a change is made. This ought to be simple.
Thanks for your help!
