This will trigger the workflow where the error occurs.
Please contact me should you need any additional information.
Thanks!
I am investigating now.
Ok, I am staying out of the app. Let me know if you need anything.
It is a bug.
Table โWorkOrdersโ contains two address fields.
As a result, when we retrieve the record from โWorkOrdersโ we look up the LatLong of those two address fields and store their LatLong values in two augmented fields at the end of the record. The sanity check is comparing the number of fields in the record (including the two augmented LatLong fields) and reporting that it did not find those two fields in the schema. The sanity check is not accounting for the two augmented field; therefore, it is reporting an error when there is none.
I am investigating how to fix the problem without entirely eliminating the sanity check.
I am not sure how long that will take but at least the problem is clear.
It must be addresses based on the references? I have Customer and Technician references which both have address information. Technicians are just a special type of Employee.
Iโm really surprised this is the first time its been encountered!! Is it because there are two addresses or would a single address have caused the same problem?
Are there any benign changes I can make to either have those fields in the schema or prevent adding the augmented columns. For example, if I added a LatLong column would this balance the sanity check? Thought is they are being added because I donโt have them already.
Anyway, I did discover a workaround by wrapping the DataChange Action in a dummy โexecute an action on a set of rowsโ Action. I can use that until a fix is madeโฆand hopefully I remember to come back and update!!
Thanks for investigating!!
The โWorkOrdersโ table contains the address fields โCustomer Addressโ and โJob Site Addressโ.
Whenever you have address columns we retrieve the LatLong for each address and stored those values in the data row in memory at the end of the data row. They are not written to the table. They are only used internally.
I am coding the change now. If testing goes well, the change should be released on Friday afternoon Seattle time.
Ah yes! They are Virtual Columns pulled from the references just so they can be seen on the Work Order.
I checked in the change. I tested it using your app and your actions now work.
I updated two records in your โWorkOrdersโ table while debugging and testing. I think they are โB - Customer 2โ and โC - Customer 2โ.
Thank you for your attention and quick turn around this bug!! It is very much appreciated!
User | Count |
---|---|
35 | |
34 | |
26 | |
23 | |
18 |