Hello,
I am attempting to customize the Vendor maintenance screen to add a checkbox associated with a user defined date field.
Is this possible. I am unable to select the date field when attempting to set it up. It does show other non-date user defined fields
*This post is locked for comments
Use a text box object for the date field. Then you will be able to select a user date field and then an integer or character field for the check box (or use an unbound control.)
I'd agree with Gregory Smith's suggestion of an unbound field for the checkbox if you don't need to store whether it was checked or not, otherwise use a different (date or numeric) user field for the checkbox and display the date (a different user field) in a second control if they need to edit it.
They actually just want a checkbox and then an associated date field to indicate the expiration date.
Another way you can do it is to add an unbound field into the screen for the check box and then use SetBufferValue to set the user date field based upon the check event of the check box.
Of course you also have to use the GetBufferValue and SetObjectValue statement to read the user date field and set the unbound control used for the check box accordingly on the Vendor ID check event.
I don't think you can do that as the checkbox object can only be associated with a type that can be True/False (Integer or Character). I assume that you want to use the date field because your other user fields are already being used. If so you could use one of the unused S4Future fields but in that case you might have a conflict with a future version that uses that same field.
A better approach might be to create a custom table with a link to the vendor ID table and include it with the screen to store the results of the Check Box. It's more programming because you have to include the table with the screen and write code to handle the database updates, deletes and insertions to the custom table.
What is your reason for using a checkbox with a date field? There may be a way to do it, but a checkbox only allows two values, in this case probably "1900-01-01" for false and some other arbitrary date for true. Are all the other user fields already in use?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (