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 LegendThere 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
------------------------------
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
------------------------------
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 Westbrook
PRIME Developer
Harder Mechanical Contractors Inc.
Portland OR
------------------------------
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 Westbrook
PRIME Developer
Harder Mechanical Contractors Inc.
Portland OR
------------------------------
- MarkShnier__Youyes, thx for the correction!
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- Thank you. How do I show the value (date) of the single record that I am linking to vs seeing a button or defined text which seem to be my only options with a URL formula field?
------------------------------
George Bramhall
------------------------------- MarkShnier__YouYou can make a formula rich text field as a hyperlink.
var text Words = ToText(Max Date Summary]);
var text URL =URLRoot() & "db/" & [_DBID of the child table] & "?a=er&rid=" & [Record ID# of child with maximum date];
// this last part is always the same
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
