@Steve
From our message…
"I have a table with a list of places (and info about each place) we will call Table 1. The list of places in Table 1 we will call A, B, C and D. I then have several other tables that are used as different types of forms to fill out when personnel are at each location (let’s call one of these forms Table 2). These are linked via a Ref column to Table 1 based on the location names A, B, C or D. I then have a view based on Table 1 which is just a list showing A, B, C and D. When you click on A, you see inline views of Table 2, as well as inline views of other Tables I use as different types of forms related to that location. My goal is that when users click on A or B and see the inline view of the associated Table 2 rows, they will have the ability to view these rows, but not edit them or add new ones. However, when they click on C or D, they should be able to both edit and add new rows.
Changing the system add action did not remove it from the inline detail. It sounds like I could write expressions into every column’s “editable if” so that if the user adds a row to A or B they won’t be able to input anything, though this does not stop them from initially clicking “add” to begin filling out the form.
I attempted this in the table’s Edit action - NOT(OR([Name]=“A”, [Name]=“B”)) but it did not work. I feel like I need to put this same expression into the virtual reference column of Table 1 but that does not seem to be an option."
LinkedIn
Twitter
