Disable Button if double entry

1

Hello!

I have a button on Table A that adds a row to Table B. The issue is that sometimes the report that I upload to Table A has duplicate entries. Is there a way to disable the button of the 2nd entry (there is a key column used, so that would be the duplicate value to check for).

Thanks!

2

Hey @Samuel_Langford! I’m not so sure about an easy way to disable the button if there are duplicates, but I wonder if you could use a solution like this to see which rows are duplicates, and highlight just the button column in red with conditional formatting to better visually indicate that it contains duplicates and shouldn’t be pushed :thinking:

3

Thanks! I actually found a solution. For anyone else needing to do something like this -

I created a Double Entry number column and set it’s value to:
image

Then disabled the button if the Double Entry column != 1.
image

It only works if you have a key column you can compare, so it might not work for all problems like this. But it’s pretty handy.

4

Ohh LOVE that, nice!

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.