blue
Forum Replies Created
-
Forum: Plugins
In reply to: [Calculated Fields Form] Making the calculated fields responsiveOkay, thank you, this might be the cause of the problems I have with resetting. I will modify the code and check again.
Forum: Plugins
In reply to: [Calculated Fields Form] Making the calculated fields responsiveI’m doing something like this:
if(fieldname1 == 9) AND(ACTIVATEFIELD(fieldname2|n), ACTIVATEFIELD(fieldname3|n), ACTIVATEFIELD(fieldname4|n), IGNOREFIELD(fieldname5|n), IGNOREFIELD(fieldname6|n), IGNOREFIELD(fieldname7|n));
else return AND(IGNOREFIELD(fieldname2|n), IGNOREFIELD(fieldname3|n), IGNOREFIELD(fieldname4|n), ACTIVATEFIELD(fieldname5|n), ACTIVATEFIELD(fieldname6|n), ACTIVATEFIELD(fieldname7|n));Forum: Plugins
In reply to: [Calculated Fields Form] Making the calculated fields responsiveI was able to resolve the two problems. But, the showing/hiding of fields based on custom dependency rules seem to be slow and sometimes requires clicking on the page. Is there a reason for this?
Forum: Plugins
In reply to: [Calculated Fields Form] Making the calculated fields responsiveOkay, that works, thank you.
There are also two issues with the reset button:
- The HTML field that lists the content of calculated field does not get empty after resetting even though the original calculated field becomes empty.
- Initially, the form loads properly with all the needed fields. After resetting, some fields (that use custom dependency rules) disappear. Then, I have to toggle between the choices to show those fields again.
Please advise on how to fix these two problems.
Thanks.
Forum: Plugins
In reply to: [Calculated Fields Form] Custom dependency rulesOkay, what about the opposite of IN (not equal to)?
Forum: Plugins
In reply to: [Calculated Fields Form] Custom dependency rulesOkay, no problem, there was actually an issue with the field and I have resolved it. Another question, how do I combine these OR statements?
if( OR(fieldname1 == 1, fieldname1 == 2, fieldname1 == 3, fieldname1 == 4) )Forum: Plugins
In reply to: [Calculated Fields Form] Using letters in calculationsI actually had a mistake in the fieldname1 equation but I fixed it and everything is working fine now, thanks.
Forum: Plugins
In reply to: [Calculated Fields Form] Using letters in calculationsI implemented what you suggested exactly, just like this:
CODETOCHAR(SUM(64, fieldname1))But it ignores the ‘fieldname1’ and instead returns the character @ (character #64).
Forum: Plugins
In reply to: [Calculated Fields Form] Using letters in calculationsThe operator ‘String.fromCharCode’ does not work when I use a variable inside the brackets. I need to do something like this ‘String.fromCharCode(25+fieldname1)’. How to make this work?
Forum: Plugins
In reply to: [Calculated Fields Form] Using letters in calculationsOkay, thank you. Another question, how do I convert a fraction to a simpler one (e.g. 5/4 to 1 1/4)?
Forum: Plugins
In reply to: [Calculated Fields Form] About rounding numbersOkay, but I need to round to the nearest 0.5 which is not possible with PREC. Is there a solution for this?
Forum: Plugins
In reply to: [Calculated Fields Form] About applying two radio buttons to the same fieldsYes, I did adjust the equation for my fields but it still doesn’t work. But that fine, I found a workaround.
Forum: Plugins
In reply to: [Calculated Fields Form] About applying two radio buttons to the same fieldsI tried your last code but it doesn’t work.
Forum: Plugins
In reply to: [Calculated Fields Form] About applying two radio buttons to the same fieldsOkay, thank you. I can implement this myself based on the code you provided. Another question though; does work work for both radio buttons and dropdown list?
Forum: Plugins
In reply to: [Calculated Fields Form] About applying two radio buttons to the same fieldsI have a question regarding the example you provided about the dependency rules, is it possible to disable choices on the second dropdown list based on the selected choice in the first dropdown list?