Good afternoon, I’m using FORM SCREEN to include records in the table, but I need to check if there are duplicates within the table. Is there any way to do this or will I have to create a CUSTON SCREEN to check via Relation?

Yes, you can use the “new form screen” action to show a completely new screen with the current context. But why do you want that if you can just add these information in the current form you have ?

Hi Maxine, I need to check if there is already a similar record to not allow inclusion.

I don’t understand, I guess. CPF here in Brazil I think social security there.

form screen I could only check after the AD ROW.

You can use this screen values to your conditions and filters from the form itself: [image] That would allow you to see the result without submitting! Even better what you think ?

I need to check it through a RELATION otherwise I won’t be able to. There are a lot of records to check.

But I will save this information for other purposes. Very good. Thanks.

In this case, you probably want a helper table to save the form values in user-specific columns to be able to compute a relation from that data.

Show Form Screen

Ask for Help

ThinhDinh January 22, 2025, 12:25am 15

Here’s a classic thread from @Darren_Murphy .

Topic		Replies	Views
Determine if row exists in a table Ask for Help	11	2200	December 5, 2021
Duplicate rows Ask for Help	4	242	January 29, 2024
Check if current specific row entries match before adding new ones Ask for Help	7	742	March 6, 2023
Prevent duplicates from text entry Ask for Help	4	1424	September 20, 2022
Custom form screen question Ask for Help	25	1604	December 16, 2021

Show Form Screen

Related topics