- May 7, 2010 at 1:41 pm #488
Is it possible to have more than 1 custom format on a numeric field. i would lilke a field to equal either 0 or 100 & if not then a message of some sort be displayed!May 7, 2010 at 2:04 pm #5246
in your ‘branch’ where you set the condition, go to the ‘advanced’ and there you can then construct your condition for this
not sure what you mean though on the ‘more than one custom format’. Do get back on that if the above isn’t helpingMay 7, 2010 at 2:45 pm #5248
I have a table where i would like a column to input the totals into another field.
this field should then always equal to 0 or 100.
the mentality behind this is that each row entered will have a column for percentage of usage. if there were 4 rows added then each rows percentage should ultimately total 100. if there is no usage then this column would equal 0
hope that makes senseMay 7, 2010 at 3:59 pm #5249
have a look at how you can do column calculations on table fields here
This will give you your total and then you can use this field to ‘validate’ that it equals 100 or 0 before you allow the users to proceed either to ‘submit’ or to the next page
You must be logged in to reply to this topic.