Stock Checkbox Rating

[tmas73]

Hi,

I have a stock field "prod_stock" that displays the products stock "5". I would like to have a checkbox rating from 0-20, so when you have 5 Stock Items, 5 checkboxes are checked.

_ _ _ _ _

|_|_|_|_|_|X

How could I do this?

Thanks

[Ocean West]

you could do it with a button and conditional formatting... using colors.

stocksample.fp7.zip

[tmas73]

Genius solution, but there seems to be a problem if you go above 10. The Checkboxes dont work, I believe because of 1 and 10s. Anyway to get around that?

[Raybaudi]

It works well but your field prod_stock must be a number field, not a text field.

[comment]

Either that, or change the formula to:

GetAsNumber ( YourTable::YourField ) ≥ n

[Raybaudi]

Another way, simpler to modify, is using a repeating field.

stocksampleMod.zip

[tmas73]

Great solutions, thanks!

T

[Ocean West]

depending on your solution you could even display a status in a web viewer using css/html.