Initial Value in Dropdown is same as last entry (learning alternatives to VLOOKUP)

Hello! Just started to use Appsheet so apologies if this is very obvious.
I’m making a very basic calculator for the cost of bus transfer tickets in a remote area. People board and pay in groups instead of singly, and there’s currently only a CC machine on board, which doesn’t calculate prices or record the individual sales.
For the driver’s convenience, the Initial Value for the Date is set as TODAY().
There are several possible Departure Times which are selected from a drop down menu. But for the driver’s convenience it will be great to have the Initial Value in the Departure Time field to be the same as the the last entry, so they don’t have to select it every time.

Can anyone point me where to look for guidance here, or just what search terms I should use?
Thank you in advance?

Solved Solved
0 13 559
1 ACCEPTED SOLUTION

I believe since the "dep Time " is a range of selections from predefined values, you will need a LOOKUP() expression as mentioned before.

So please try with “Dpe Time” as Enum with base type as time and any of the LOOKUP ()expressions mentioned above.

View solution in original post

13 REPLIES 13
Top Labels in this Space