Hi,
We are building a complex data entry form with Types, and CRED will be used to provide front-end data entry form.
We would like to calculate a "score", which will be based on the choices to some of the custom fields (radio or select).
Is it possible to assign a numeric value to a custom field's choice, without losing any information for the future (ie. if I won't be able to show "San Francisco" because it's now called "20", that's not good).
And then, to attach arithmetic operations (addition, division) to another custom field, so that we may show the results on the CPT, using VIEW ?
Is it possible to assign a numeric value to a custom field's choice, without losing any information for the future
Each option in a select or radio field will include a value and a label. As long as the value remains constant, you can replace the label as needed. So if the option selected has a label of "San Francisco" and a value of "20", then later you could change the label to say "San Fran" as long as the value remains "20". That shouldn't be a problem.
And then, to attach arithmetic operations (addition, division) to another custom field, so that we may show the results on the CPT, using VIEW ?
You could store an arithmetic operation reference in a select or radio field, including a different option for each type of operation (like 'plus', 'minus', 'times', etc). I can help you capture any values needed in custom fields, and I can help you display those values on the front-end of the site. Views isn't designed to perform complex mathematical operations, though. You'll most likely need to implement a bit of custom code that performs calculations as needed and returns the proper values.
