Hi,
I am creating an application in sweet with attribute values and domains. I have a field "field2" that is auto-calculated based on another field "field1" using a script. The problem I have is that defining a calculation based on a script renders field2 read-only. The relationship from field1 to field2 is not one-to-one in every case and there may be multiple options for field2 based on field1 so it is not always populated. Where this is the case I need to be able to leave it blank and allow selection from a drop down list. I have a domain set up for field2 and have the allowed domain values and field correction set up to reduce the overall domain to just ones match the one-to-many results from field1.
the domain and field correction works if i don't have a calculation on, but with the calculation included, where the result is not calculated (due to no one-to-one) then it is left blank and read only so i cant select.
Any assistance would be greatly appreciated
Thanks
Chris
