In my "Admin System" application, I have three forms: Tasks, Task_System, Task_Core_System
"Task_Core_System" is a stateless form which is used to populate the "Tasks" form/table.
"Task_System" is a form/table that holds all of the system names that I want to assign tasks to.
"Tasks" form has a lookup field called "System" which references the "System" field in "Task_System"
"Task_Core_System" has an on-submit action script that populates "Tasks", including the "System" field.
This all works fine!!
...but...
I just went to add an additional lookup field into "Tasks" form called "System_Status" which also references the "System" field in the "Task_System" form. I was able to add this fine - However, I just tried to delete this same field and I'm getting the validation error that the field is referred to in the "Task_Core_System" --> Submit --> OnClick Script.
This field "System_Status" is definitely not referenced in the "Task_Core_Systems" script anywhere and for that matter, it's not referenced ANYWHERE else in my application... How could it be-I only just created it!
The field that IS referenced in this script is the Tasks.System field.
This must be happening because both fields are lookups to the same field in the "Task_System" form/table.
I did a test and added yet another lookup ("testx") to the "Tasks" form referencing the same "System" field in "Task_System" form... and sure enough, I cannot delete this field now either...
I did another test to check if the multiple lookup fields in "Tasks" were all being populated with my Submit-onClick script in "Task_Core_System", but they aren't... the script is behaving correctly and only the Tasks.System field is being populated.
The only problem is that I cannot now delete these other fields ("System_Status" or "testx" from my "Tasks" form) and I'm worried about what is going to happen next when I want to write scripts for the additional Tasks.System_Status or Tasks.testx fields. I could just disable my action script in "Task_Core_System" and delete these fields, but I think this is a bug that should be investigated.
Can Zoho Support please investigate this bug?
My application is shared and you may manually delete Tasks.System_Status field but please don't modify the Tasks.testx field as I will be working with this one.
Thanks