Quicker way to add new record in grid edit

Question

In one of our tables, we rely on grid edit to add new records. &nbsp;Since there are a lot of records, normally we have to to the last page and then start scrolling until we find a blank row,. &nbsp;This is really long way. Is there a quick way to add a new record in grid edit? &nbsp;

quickbasecoachd · Answer

A low tech solution is to have the users work from a report called My Records entered Today where the filter is [Date Created] equals the current date and [Record owner] is the current user.

That will likely be a very short report.

arshadkhwaja · Answer

Thanks. Seems workable. Will try this after discussing with guys. Another option is to provide users with the related project iD and have them import the data. But it is fraught with danger.

Can users directly enter a number for the related project when copying and posting in the related project column?

quickbasecoachd · Answer

Yes, [Related Project] is just a number really, like any other number. Copy and Paste works best using IE as a browser.

arshadkhwaja · Answer

Thanks. &nbsp;The question was we copy and paste and pre populate the Excel sheet with a project iD, would the related project column accept a number obviously in IE environment? &nbsp;I cannot test it as i don't &nbsp;have IE available to us. &nbsp;

quickbasecoachd · Answer

Yes it will accept that number for Related Project. &nbsp;Firefox also will work for copy and paste.

Forum Discussion

Quicker way to add new record in grid edit

Related Content

Using Grid Edit to Edit Multiple Records at Once

Edit Multiple Records at Once with Grid Edit

Custom Record Titles

Record Picker in Grid Edit

Embedded Grid Edit Report Pre-filtered Conditional Dropdown