In Form 1, I can add a location, items, and the item barcode.
In Form 2, I can only change the location column. I should still be able to view the other columns but not edit them.
I have tried using editable_if where I can only edit the column if it is empty. However, when I am filling up Form 1 and click away from one of the input fields, I am not able to edit that field anymore. How can I make this work?
You have to create two slices. One for add. One for updates. After creating the slices, create two different Form views in the UX tab.
Add this formula to your editable_if CONTEXT(“View”)=“slice_name_adds_form” afterward
For those columns that should only be editable in Form 1, set Editable? to the expression:
(CONTEXT("View") = "Form 1")
See also:
@Steve Would this work the same if there is only 1 form that does both the edits and the adds?
Yeah, it should work with both adds and edits.