Forum Discussion
MarkShnier
12 years agoQrew Cadet
While there is no native "setting" to control how many blank lines are presented to the use in Grid Edit, you could have a URL formula button which the user could press to add blank child lines. This is an example of such a formula I used for another client. It adds 5 blank lines and re-displays the record. It could be modified to add more than 5 lines - say maybe 8 or 10 lines) and it could also be modified to present the record to the user in Grid Edit mode.
The formula variable for ADDRecord would need to be modified to update the child records with the correct values in the two fields you need to populate "automatically" - those first two fields to user now copies down. I see that one of those fields is the YYYY year, so either that could always pick up the correct YYYY by formula based on today's date to else one could do a reverse lookup relationship to have the Parent record know what the most recent YYYY was of the Child records.
var text AddRecord =URLRoot() & "db/" & [_DBID_QUOTED_ARCHITECT_BUDGET_PRICES] & "?act=API_AddRecord&_fid_6=" & URLEncode ([Record ID#])& "&apptoken=xxxxxxxxxxxxxxxxxx";
var text EditRecord=URLRoot() & "db/" & DBID() & "?a=er&rid=" & [Record ID#]& "&apptoken=xxxxxxxxxxxxxxxxxxxxxxxx";
$AddRecord& "&rdr=" & URLEncode($AddRecord)& URLEncode("&rdr=" & URLEncode($AddRecord))& URLEncode(URLEncode("&rdr=" & URLEncode($AddRecord)))& URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($AddRecord))))& URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($EditRecord)))))
Feel free to contact me via my profile information if you want to discuss this person to person.
The formula variable for ADDRecord would need to be modified to update the child records with the correct values in the two fields you need to populate "automatically" - those first two fields to user now copies down. I see that one of those fields is the YYYY year, so either that could always pick up the correct YYYY by formula based on today's date to else one could do a reverse lookup relationship to have the Parent record know what the most recent YYYY was of the Child records.
var text AddRecord =URLRoot() & "db/" & [_DBID_QUOTED_ARCHITECT_BUDGET_PRICES] & "?act=API_AddRecord&_fid_6=" & URLEncode ([Record ID#])& "&apptoken=xxxxxxxxxxxxxxxxxx";
var text EditRecord=URLRoot() & "db/" & DBID() & "?a=er&rid=" & [Record ID#]& "&apptoken=xxxxxxxxxxxxxxxxxxxxxxxx";
$AddRecord& "&rdr=" & URLEncode($AddRecord)& URLEncode("&rdr=" & URLEncode($AddRecord))& URLEncode(URLEncode("&rdr=" & URLEncode($AddRecord)))& URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($AddRecord))))& URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($EditRecord)))))
Feel free to contact me via my profile information if you want to discuss this person to person.
JasonGordon1
9 years agoQrew Member
Thanks for the quick reply! Luckily the most our users will paste a max of 7 rows at a time so we'll be OK. Just wanted to make it as easy as possible.