Forum Discussion

ReyTacardon's avatar
ReyTacardon
Qrew Trainee
6 years ago

Data Entry Form to have a field show the last entry when you open the Form to enter the next data

I have a data entry from with a field Version. When a User go into that form I want the latest entry for field version to auto-populate that field so that the User does not need to select it again for each entry. How do I do that?
  • If the workflow allows this, a user can  be viewing a record and use the more button to copy this record.  You can set in Field Properties if the field should auto populate on the Copy record.

    If that works, but locating the More .. copy this record button is too non-obvious for users, you can make a formula URL button to mimic that. Post back if you need help with that.
  • I'm a newbie so please bear with me, let me look for that Field Property and I'll post back. Thank you!
  • np, look for

    Auto-fill    Copy the value when using "Copy this Task" to add a new Task
    • ReyTacardon's avatar
      ReyTacardon
      Qrew Trainee
      Yup found this one in the bottom part of the Field Properties. 
  • There is an app I put in the Exchange called URL Formulas for Dummies which attempts to provide a bit of a tutorial.

    The formula for a Formula URL Button to "copy this record" would be this.


    URLRoot() & "db/" & dbid() & "?a=GenCopyRecord&rid=" & [Record ID#]

    You can choose a button appearance with a color or have it appear as a link (I would use a button as I think that links should be used more for navigation) and put it on the form and set the form properties to only show this field in View mode. 



  • Thank you sir! Also I found the "Copy this Entry" from the "More" Dropdown that you mentioned, that actually eliminates the need for another Button, so thanks for that too, but I will play with the Buttons too and try to at least do one in my app just to learn how to do it :)