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

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I want a field to be editable in the view mode also, so that the viewer can select a value from the drop down value, based on which a certain section of the form will be visible or invisible.
Photo of Archana Bhalerao

Archana Bhalerao

  • 70 Points

Posted 2 years ago

  • 0
  • 1
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,522 Points 20k badge 2x thumb
>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
(Edited)