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:
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:
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.