Trying to recreate a form we have been using that is manually created and maintained. The data we need for the form is all in an Acumatica Project or related tables.
We have a need to render a series of checkbox fields from the project on the form with custom CSS to display a different design of a boolean field (0/1).
When the field is checked the output should be a Green Box with the word “YES” in the middle. If it is not checked, we want to show a Red Box with the word “NO” in the middle.
Doing some research I’ve found references to using an embedded image and creating picture boxes for the YES and NO images. This works with two picture boxes for each field, one for YES and one for NO. They are both visible = false and using a Visibility formula you set the correct one to visible based on the value being 0 or 1.
It would be nice to change the source of the image dynamically based on a formula using fi
We have a dozen or more fields we need to do this with on the report/form and to create and manage 24 pictureboxes and position them on top of each other is time consuming and a pain.
It would also be helpful to not have to do the image/pictureboxes concept and have a formula for setting the CSS Style based on the value.
It would also be useful to manually code the CSS Styles.
Does anyone know of a better way to do this?
Does anyone know of best practices to allow the same report to render properly in HTML and PDF?
Thank you.
Glenn
