1b.app
Link copied -

Checking for the existence of a record when adding

Congratulations!
Please tell me, is it possible to add data using the action "Add entry to the directory based on the value of an additional process field" or maybe there are other actions for such a check?
Before creating, it is necessary to check the presence of such a record for a certain field and, if it exists, issue an error or update the value (you can choose). Because at the moment I have constant duplications.
Is this possible or what is the cost of such a modification? Thank you!
Original question is available on version: ua

Answers:

Good afternoon. Tell me what the action settings look like
05.02.2025, 14:33
Original comment available on version: ua

Пчолкін Віталій Володимирович
Група активної реабілітації, Голова правління
Leave a message in this thread and the user's contacts will be shown to you
Thank you!

There are no special settings there, it's essentially a register of organization members, I need it to not create duplicates, and if necessary, update the data in a specific record.
05.02.2025, 16:22
Original comment available on version: ua

Judging from your reference, the duplicates that can be created are complete duplicates of a line. And if you count a duplicate as a piece of a line, then such a check will not work.
You can set the registration number to only unique values ​​and the action will not create a new record in the table as long as there is a record with that number.
To edit/delete a value from the directory, you can use the action "Edit directory entry based on process fields"
05.02.2025, 17:03
Original comment available on version: ua

Пчолкін Віталій Володимирович
Група активної реабілітації, Голова правління
Great! Thank you very much, I couldn't understand the essence of this setting before, now I understand, it should work)
05.02.2025, 17:46
Original comment available on version: ua

Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter. Log in and comment