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?

You can in fact use API_ImportFromCSV as a GET method so you could build a blob of CSV data in the formula language and add multiple records with one API call via a formula. Conceptually you would use a formula like this but I have not tested it (there could be a typo or bad assumption concerning field types) and you will certainly have to make modifications based on your fields and table structure:

var Text $csvdata =
ToText(+1) & "," & & "," & & "\n" &
ToText(+2) & "," & & "," & & "\n" &
ToText(+3) & "," & & "," & ;

URLRoot() &
"db/" &
[_DBID_YOUR_TABLE_NAME] &
"?act=API_ImpportFromCSV" &
"&records_csv=" & $csvdata &
"&clist=6.7.8" &
"&apptoken=xxxxxxxxxxxxxxxxxx";

You have to be careful building the CSV blob if quotes are needed and use URL encoding where necessary. I really don't recommend doing this as using script is the preferred and more flexible solution. But if you are stuck in a world where forces beyond your control are forcing you to use only formula URLs at least you do not have to use multiple rdr parameters to add multiple records.

This method is not foolproof if you are attempting to add a lot of CSV data as URLs have a maximum allowed length which varies by browser:

http://stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers