"Required value missing" in IM custom tab

Try unchecking the Required checkbox on the Edit tab for the column.

I have an Inactive checkbox on a new Custom tab, the first I've done with such a checkbox. If I enter other data, and attempt to exit the custom tab, I am asked to Save, and I click Yes. After that, I get another dialog box, which states that a "Required value is missing"; "Please enter a value for 'inactive', row 1".

The table originally allowed nulls in that column. I changed that column to default to 'N', but IM is still complaining about a missing value. If I check the checkbox and uncheck it again, it will let me save.

What do I need to do to get IM to save a 'N' by default without having to do that check/uncheck?

Thanks.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Try unchecking the Required checkbox on the Edit tab for the column.

I have an Inactive checkbox on a new Custom tab, the first I've done with such a checkbox. If I enter other data, and attempt to exit the custom tab, I am asked to Save, and I click Yes. After that, I get another dialog box, which states that a "Required value is missing"; "Please enter a value for 'inactive', row 1".

The table originally allowed nulls in that column. I changed that column to default to 'N', but IM is still complaining about a missing value. If I check the checkbox and uncheck it again, it will let me save.

What do I need to do to get IM to save a 'N' by default without having to do that check/uncheck?

Thanks.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Right…forgot the Required box is not on that edit style.

I assume that you have values for On and Off, “y” and “n” respectively?

Try making the column nullable again.  In my example of an inactive column, I’m not prompted for an update if I add a new row and leave the inactive checkbox untouched.

Ryan Creps:

Try unchecking the Required checkbox on the Edit tab for the column.

The field is a Style Type = CheckBox, so there's no Required checkbox on the Edit tab.

I've tried making the field a text box edited to be small CheckBox-like, and the Required checkbox in IM was unchecked (as is the default?), and then I didn't get asked to enter a value, but instead of a checkbox I got a one-character text box with a 'N' in it.

I change the field back to a CheckBox, so it looks the way it should, and the nag to enter a value returns.

Any other ideas? Thanks.

NO problem.  Glad you figured it out.

Figured it out. I needed to add a default value 'N' to the field properties -> General tab -> Tag field.

Thanks for your replies, Ryan.