I'm trying to query the current table to retrieve the latest entry made by the current user and post it to a new form. I'm having a tough time comin up with the right formula to make this work so any help is appreciated (even suggestions on the formula names or expressions can also do). Thanks!
Let's start low tech. If you run a report for "My entries" filtered by where the [Record owner] is "the current user" and sort it by [Date Created] at the top. The the user can View the top record to view and use the "More" button to add a similar record.
The next step in complexity would be to have the same report but had a button on the report to "Add Similar". That is quite easy to do and I can help you with that. That is what I recommend.
The next level of complexity would be to have a table of users and do a reverse relationship to float up the values of all the fields you need to have to add a new record up to the User record from the child record of data records which has the maximum record ID# - ie the most current record,.. Then make a URL formula URL button to click to create the new record or to put up an Add Record form with the fields partially filled in. So the user would navigate to their own record and then click a button there to create the next similar record.
So those are the three choices you can go with. Let me now how fancy you want to get with this.
The expected action is when the user makes a new entry, a button (formula URL field) should be available to take him to a new form with the values of his latest and last entry recorded in the new record.
The button on its own should query the last record of the user from the table, redirect to a new form page and populate the record. Hope I have conveyed it clearly. Thanks!