Skip to main content
Question

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

  • June 28, 2019
  • 0 replies
  • 114 views
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?
    This topic has been closed for replies.

    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.
    • ReyTacardon
    • Author
    • Registered
    • June 28, 2019
    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
    • Author
    • Registered
    • June 28, 2019
    Can you send some guidance on how to create formula URL Buttons?

    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. 



    • ReyTacardon
    • Author
    • Registered
    • June 28, 2019
    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 :)
    Terms & ConditionsAccessibility statement