How can I make a field editable every time a record is opened, even in view mode?

It seems like you're trying to add a field to the table and a form, and then you want to create a form rule to hide or show sections based on its value.

To accomplish your goal without a script, users will need to be able to open the record to edit. Create a copy of the form you want to use. Customize the form, and for each of the form elements except the one you want to control the view, select the checkbox that says "Read-only (even when used for data-entry)."

Add your sections and save the form. Go back into customize and add dynamic form rules that will show and/or hide sections based on what the user chooses in the dropdown.

That should do the trick.

In View mode you will not be able to edit the record.  

So, you would need to remove the view option on the report  and then either have a button to open the record in edit mode or else have the user just use the native edit button

>In View mode you will not be able to edit the record.  

This is the most preposterous thing I heard all day.  Go ahead and just click on the [Text] field and start typing - your changes will be updated to the record without further navigation.

Edit My View ~ View Record
https://haversineconsulting.quickbase.com/db/bmkz323rr?a=dr&rid=1

The screenshot below shows my edit of the record in view mode:



Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=560