Quicker way to add new record in grid edit

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
In one of our tables, we rely on grid edit to add new records.  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,.  This is really long way. Is there a quick way to add a new record in grid edit?  
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
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?     
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Yes, [Related Project] is just a number really, like any other number. Copy and Paste works best using IE as a browser.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Thanks.  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?  I cannot test it as i don't  have IE available to us.  
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Yes it will accept that number for Related Project.  Firefox also will work for copy and paste.