tmas73 Posted November 25, 2008 Share Posted November 25, 2008 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 Link to comment Share on other sites More sharing options...
Ocean West Posted November 25, 2008 Share Posted November 25, 2008 you could do it with a button and conditional formatting... using colors. stocksample.fp7.zip Link to comment Share on other sites More sharing options...
tmas73 Posted November 25, 2008 Author Share Posted November 25, 2008 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? Link to comment Share on other sites More sharing options...
Raybaudi Posted November 25, 2008 Share Posted November 25, 2008 It works well but your field prod_stock must be a number field, not a text field. Link to comment Share on other sites More sharing options...
comment Posted November 25, 2008 Share Posted November 25, 2008 Either that, or change the formula to: GetAsNumber ( YourTable::YourField ) ≥ n Link to comment Share on other sites More sharing options...
Raybaudi Posted November 25, 2008 Share Posted November 25, 2008 Another way, simpler to modify, is using a repeating field. stocksampleMod.zip Link to comment Share on other sites More sharing options...
tmas73 Posted November 25, 2008 Author Share Posted November 25, 2008 Great solutions, thanks! T Link to comment Share on other sites More sharing options...
Ocean West Posted November 25, 2008 Share Posted November 25, 2008 depending on your solution you could even display a status in a web viewer using css/html. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5770 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now