Feature Issue: Grid Edit - How can we get the 4 row constraint for copying/pasting expanded?

When you say a 4 row limit can you better explain your situation?  Are you trying to edit an existing record or add a new record and child records all at the same time?  If its the former, there may be a solution.

See attachment. JPG 1 of 5. These are the instructions the agency uses for its constituents to report in to us through Quickbase using the grid edit feature.

Page 2 of 5.

Page 4 of 5.

Page 3 of 5.

All of the jpgs are instructions for using our application. We customized the application to monitor 80 separate agencies with specific and unique identifiers in the application. Each profile for reporting is password protected and permissions accessible.  VM

Page 5 of 5.

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.

Thank you!

This makes 5 blank copies. What if i would like 5 copies, but with the same record information duplicated 5 times?