Open a record automatically in edit mode
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 ---------------...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIf 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
------------------------------
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
------------------------------
- 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__YouIs 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
------------------------------
------------------------------
George Bramhall
------------------------------- MarkShnier__YouThere is not a way to make it behave differently with a simple setting.
But if you go back to that relationship and lookup that summary maximum date down to the child records, you can then create a new summary field to obtain the maximum [Record ID#] of the children where the date matches that Maximum date.
Then you can make a formula URL button to click on to directly edit that record.
The formula would be like
URLRoot() & "db/" & [_DBID of the child table] & "?a=dr&rid=" & [Record ID# of child with maximum date]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
