I have a Survey database, and a table with 60 buttons in it. for each button, i have a computed field next to it, and all I want to do is have a check mark appear in the field when the user clicks the button. I am only versed in displaying icons in columns. Can anyone help me?
Subject: Show Icon in Field
60 buttons? Ouch. Maintenance nightmare here you come… ; - )
Anyway, to your issue. Your button just needs to do an @SetField call on the field in question. You can create a checkbox field that has only one possible value. Use your button to write that value to the field, refresh the field, and wahey, it will be checked.
Simple, no?
–
Subject: RE: Show Icon in Field
The @SetField command sounds right, but how do I physically get the green Check Mark Icon to show in the field?
Subject: RE: Show Icon in Field
I thought you just meant it was a conventional checkbox field. Why not just use that?
If you insist on your custom solution, then the only way you can really achieve this is to place you checkmark as a graphic in your form, and put some hide-when formula on it. The formula can then reference a hidden field that gets toggled by the button.
–
Subject: RE: Show Icon in Field
Whoa. Sometimes the obvious is right in front of me, and I never see it. Thanks for the info. I certainly appreciate it. Yeah, the customer INSISTS on the little happy graphic databse. They are all Marketing people, and choose frills over functionality.
Subject: Yeah, they’re nearly as bad as HR people
(WAS: Show Icon in Field)
Subject: Another alternative
You can add the checkmark as an image resource and then add the image resource to the form with a computed value based on whether the check box or field is modified.