Dont add items to data table if they already exist in the data table
Hi
I have a data table that a user can add items to through a form. However I want to prevent the addition of a new item if the item already exists in the data table. How can I create a condition to check if the item is already there.
Thanks
Joseph
Add an Event to a button
On click -> set value
click on the whole data grid or data list then select calculated on the bottom part
then add expression
drag "Count" condition and inside it drag the "Filter" condition
inside the filler condition has two variables, on the first one go to data masters and drag the datas, on the second variable drag the textbox(the one that contains the name that you do no want to have duplicate)
after that, drag the not equal sign "≠" at the end of count and double click it and set it to 1
looks like this
then click ok,
do an else statement if it returns true
Add an Event to a button
On click -> set value
click on the whole data grid or data list then select calculated on the bottom part
then add expression
drag "Count" condition and inside it drag the "Filter" condition
inside the filler condition has two variables, on the first one go to data masters and drag the datas, on the second variable drag the textbox(the one that contains the name that you do no want to have duplicate)
after that, drag the not equal sign "≠" at the end of count and double click it and set it to 1
looks like this
then click ok,
do an else statement if it returns true
Hi
Thank you very much... :). works perfectly...
Hi
Thank you very much... :). works perfectly...
Replies have been locked on this page!