I am clicking on a report link and it is going to a single record in view mode. How do I get it to automatically open in edit mode.------------------------------George Bramhall------------------------------

To add to Mark's solution:If you want the record to open in edit mode, you can use the following: URLRoot() & "db/" & [_DBID of the child table] & "?a=er&rid=" & [Record ID# of child with maximum date]The only difference is that the user is being sent to the "edit record" (er) form instead of the "direct record" (dr) form.------------------------------Evan WestbrookPRIME DeveloperHarder Mechanical Contractors Inc.Portland OR------------------------------

If you set the form to display the records directly on the form as an embedded table, then the user can decide to open individual records in View or Edit Mode. In addition, you may choose to set the form property for the embedded report to be "editable" which would allow the users to to edit the child records in Grid Edit mode while editing the parent record.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

My report Link is in a report, not on a form. The link opens a record in a child table. It only opens in view mode., would like it to open in edit mode without the user having to anything.------------------------------George Bramhall------------------------------

Is there always only one child record maximum? ie the parent has either no children or 1 child?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

Actually this is a Date Summary field that is set to only show a single record, the record that is maximum in the child table. Sorry not a Report Link. See attached. ------------------------------George Bramhall------------------------------

Open a record automatically in edit mode

MarkShnier__You
Qrew Legend
6 years ago
If you set the form to display the records directly on the form as an embedded table, then the user can decide to open individual records in View or Edit Mode.

In addition, you may choose to set the form property for the embedded report to be "editable" which would allow the users to to edit the child records in Grid Edit mode while editing the parent record.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- GeorgeBramhall2
  Qrew Cadet
  6 years ago
  My report Link is in a report, not on a form. The link opens a record in a child table. It only opens in view mode., would like it to open in edit mode without the user having to anything.
  
  ------------------------------
  George Bramhall
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    6 years ago
    Is there always only one child record maximum? ie the parent has either no children or 1 child?
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------

Forum Discussion

Open a record automatically in edit mode

Related Content

PDF Document Generator, automatically attached to a record

Custom Record Titles

Formula URL Button to Open New Form and Check a Box

Using Grid Edit to Edit Multiple Records at Once

Record Details