Custom Tab - How do you allow only one row of data to be created in a custom screen?

You could put a unique index on the table’s inv_no column.  It would prevent this from the SQL Insert, although the error message may not be very useful.  In the past, what I’ve done is to make the editable row fill in (most of) the screen so it is more apparent to the user that is intended to be a single row per entity (performance in this case).

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Mason Wright
Sent: Tuesday, February 21, 2017 1:34 PM
To: Ryan Creps <rcreps@tessituranetwork.com>
Subject: [Tessitura Technical Forum] Custom Tab - How do you allow only one row of data to be created in a custom screen?

I'm working on a custom screen within Performance Production Elements under Ticketing Setup. I've got the updatable custom screen working just fine, I just need to know if there's a way to prevent users from adding more than one row of data using a custom screen.

I mostly wanted to know if it was possible to disable the "Add" button on the bottom of the screen after a row had been added, but if anyone else has ideas I'm very open to those.

Custom Screen with too many rows

This image shows what I don't want users to be able to do. Any help would really be appreciated.

Thanks,

Mason

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!

You could put a unique index on the table’s inv_no column.  It would prevent this from the SQL Insert, although the error message may not be very useful.  In the past, what I’ve done is to make the editable row fill in (most of) the screen so it is more apparent to the user that is intended to be a single row per entity (performance in this case).

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Mason Wright
Sent: Tuesday, February 21, 2017 1:34 PM
To: Ryan Creps <rcreps@tessituranetwork.com>
Subject: [Tessitura Technical Forum] Custom Tab - How do you allow only one row of data to be created in a custom screen?

I'm working on a custom screen within Performance Production Elements under Ticketing Setup. I've got the updatable custom screen working just fine, I just need to know if there's a way to prevent users from adding more than one row of data using a custom screen.

I mostly wanted to know if it was possible to disable the "Add" button on the bottom of the screen after a row had been added, but if anyone else has ideas I'm very open to those.

Custom Screen with too many rows

This image shows what I don't want users to be able to do. Any help would really be appreciated.

Thanks,

Mason

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!