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...
App builders
Forms
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
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.