Dont add items to data table if they already exist in the data table

Joseph Grogan shared this question 3 years ago
Answered

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

Comments (2)

photo
1

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


4bdadd21d35c21da77f2194eb3e6fd24


then click ok,


do an else statement if it returns true

photo
1

Hi


Thank you very much... :). works perfectly...