Input Form - Validation Rule to check that a value does not Exist

MaybornGDI

started a topic over 2 years ago

It would be a good addition to be able to make sure a value added to a field on a form does not exist within the data i.e. must be unique.

Example adding a new Product.

The SKU code is the Unique key.

So when I created new product this must be unique within the Data

If I enter 001 on the form I would like it to check the Field SKU Code in the Data and if it exist fail the validation.

Thanks

Mark

Michael Nordström
said 7 months ago

Hi,

this feature request will not be implemented. The suggested functionality is already possible hy using a Qlik expression similar to this:

If(Count(Distinct {1<[Product Group Desc]={'Column([Text1])'}>} [Product Group Desc])=0,If(Column('Text1')='',0,1),0)

Kind regards

Michael

Please note your unique ticket reference (#18259) and URL https://community.vizlib.com/helpdesk/tickets/18259