ADD and UPDATE Form, how to hide columns in ADD and show in UPDATE?

Hello everyone,

So I have this maintenance reports table which I can read from my app.
I want users of the app to be able to fix the reports and update the table from the Detail view with the Form that was generated automatically by the system, this works fine. this is the icon I see in the details view which allows UPDATES: 3X_b_d_bdb17ebc236f889e53173531e986e7788139c213.png
I have set that up so that the โ€œUPDATE columnsโ€ to fill with the Form (i.e. Photo after) are not visible in the Detail View, only in the form.

I also want users to ADD new reports to the table. And here is where I have the problem.
In the Primary view of the table I have this icon which allows users to ADD a new row or report: 3X_1_c_1c8dc5ea036f39f93508eae2c45debe8963531b7.png
So far, so good. The problem is that when they do this, because the columns for the UPDATES (i.e. Photo after)are set to be required, they are also required here. And that kind of makes no sense since itยดs a new report, you shouldnยดt have an โ€œafterโ€ picture.
I tried hiding them (UPDATE columns) using the Edit_If option with a ISNOTBLANK() expression, associated to the first columns (i.e. Report date). This works ok when the ADD form is empty, but as soon as I type the date, the other fields appear again.

Any ideas on how to bypass this?

PS. Im sorry I tried to keep the post as short as possibleโ€ฆ But Im not sure about my english, so I had to explain a bit better.

Solved Solved
0 9 1,331
1 ACCEPTED SOLUTION

@Nicolas_Feldman
You can choose to show/hide a column with Show_if expression like this which means:
if the expression evals to TRUE you are editing an existing record and shows it
if the expression evals to FALSE you are adding a new record and hides it

IN(
    [KeyColumn],
    TableName[KeyColumn]
)

You can also use the same expression in Required_if property of a column

View solution in original post

9 REPLIES 9
Top Labels in this Space