Hi Zoho,
I have a drop-down field (
Insurance_Type) with "Other" choice.
On user input, I have a script checking for previous entries with the field's value (with a few other variables):
Current_Same_Insurances_List = (Insurance_Sub[((Project_Name == input.Project_Name && Ship_Name == input.Ship_Name) && Insurance_Type == input.Insurance_Type)].Internal_ID).getall();
this works great with the build-in choices in the drop-down field. when I use the "other" option, it does not work.
I've tried coping the "other" input to a new sting field - got an empty field (like nothing was entered on the "other" text field).
even worse: After submitting a form with an "Other" value, if I fetch the list of values for this field - the "Other" value is listed like all the rest, but if I try to fetch a value based on the "Other" field - I get nothing!
Example: (entered "OtherInsTset" on Insurance_Type -> Other)
Ins_Other_Ins_List = (Insurance_Sub[Project_Name == Ins_Project && Ship_Name == Ins_Ship].Insurance_Type).getall().distinct()
=> getting
Increased Value,War Risk,H&M,OtherInsTset => perfect.
Current_Same_Insurances_List = (Insurance_Sub[((Project_Name == Ins_Project && Ship_Name == Ins_Project) && Insurance_Type == "OtherInsTset")].ID).getall();
=> getting an empty list!!!
Any suggestions how to handle this?
Thanks.