Can I display a field on multiple forms but only allow it to be edited from a nominated form?
I have a very simple setup:
A single spreadsheet holds details of jobs that need to be completed.
I use a Slice to filter only items that have not been completed and use it as a datasource for a Table List.
When I select an entry a Detail form displays the record. I use a Quick Edit field on that form to help organise the jobs
When the Edit button is pressed a Form displays the record I need to edit PLUS a few info only records. E.g. I don’t want to be able to edit the Pre-Delivery comments on that form, only the Post Delivery Comments. However I want to display the Pre-Delivery comments.
I want to create a completely separate form to enable the Pre-Delivery comments, and other relevant fields to be entered and/or edited.
How do I make a field only Editable on selected form(s) but still able to be displayed on other forms