Display last form entry when refreshing

[drckarcher]

Hi,

I've got a simple form that allows me allocating staff (by name) to a particular room. It's always only one staff member per room. The staff names are in a dropdown list from a separate table.  Every time the form is submitted, it  is recorded with a timestamp and the results are displayed on a webpage ("Current allocation")

When reloading the form, I want the current (last saved allocation displayed, not the default (ie the first name in the list)

How do I do this?

Many thanks, Christian

 

 

[KlisaN137]

Hi, @drckarcher,

In order to show some field on the Form DataPage from the entry that has most recent timestamp, we can use the Virtual Field with Calculated Value with the following SQL statement:

SELECT TOP(1) field_we_want_to_show FROM tbl_test ORDER BY Time_Stamp_Field DESC

I'm not sure if I understand would you like to show last allocation based on some value from other field, so could you please elaborate a little bit more about the issue?

[ParkLoey]

Maybe you can use a combination of virtual field (use a select statement to get the latest value) and script to assign the value as default. I'm not really that skilled in creating scripts, but hopefully this gives you an idea

- LOEY