Check multiple columns for valid_if restriction

Hello, hope you are doing great! i'm having the following problem, i have two tables:

1. Reservations

2. Payments received

 

Basically, i add a new reservation, then inside the same reservation i add new payments for it.

I have a virtual column inside the reservaitons table that calculates the amount left to be paid. 

The problem is that somewhere, somehow i added a valid_if limitation that makes not possible to delete a payment if the amount left to be paid is 0 or less (basically it says that i have received all the payment money and cant delete the payment)

The thing is that sometimes i make mistakes and enter a bigger amount of the total payment, so the valid_if restrictions activates and now i cant delete the payment.

I already manually checked the valid_if property of all the columns of those two tables but couldn't find anything, maybe i skipped by mistake but i have like 80 columns in each!

Is there any way to check in a simpler way (instead of entering each column) to see the valid_if restriction?

Hope someone can help me,


regards.

 

Solved Solved
0 3 172
2 ACCEPTED SOLUTIONS

You can download an app's documentation at the following option in the editor and check for valid_if in all the columns of the app as necessary by search in page oprion.

With this you need not open each and every column in the editor.

Automatic-App-Documentation 

 

View solution in original post

(I think Peter old post redirect has changed to unrelated page)

to access
Settings / Information / App Documentation

app-automatic-documentation.png

View solution in original post

3 REPLIES 3

You can download an app's documentation at the following option in the editor and check for valid_if in all the columns of the app as necessary by search in page oprion.

With this you need not open each and every column in the editor.

Automatic-App-Documentation 

 

(I think Peter old post redirect has changed to unrelated page)

to access
Settings / Information / App Documentation

app-automatic-documentation.png

Thank you both! @jballester @Suvrutt_Gurjar i've managed to find the column with the valid if that i needed to change.

Thanks again!!

Federico.

Top Labels in this Space