Timesheet App questions

[xnbsx]

Apologies if these questions have been asked and answered before…

I used the Timesheet App template which has worked out great!

I have 2 issues id like to solve though.

• If all my users log in with their associated email, is there a way to automatically have their name display when clocking in? Id like to keep the option for them to choose anothers name in case the foreman wants to help out his workers and put their time, but id like to save a step for them by having their name auto populate.

• I added a “Lunch” field which is using “Duration” as TYPE. Is there a way to have the scrolling hours/minutes pop up instead of having them have to enter the number, and also a colon?

Thanks so much in advance!

[Andrian_Andreev]

Hello and welcome!

The answer to both questions is yes! Now how to do it:

1:
You need to learn about reference. This video helped me a lot when i started :

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

All you need to do is let the option as editable in order for them to be able to change it.

2:
This can be done with the choice of the type column. Select the column as enum type:

And then in Values you can put what you want as much as you want.

Or if you want to keep it as a duration type all you need is to use the reference method as suggested above.

I hope this helps!!

[xnbsx]

Thanks…

Enums do not work with decimals though. Ill have to do research on the references.

[Andrian_Andreev]

one thing that is really important before you start any app is to format the column in the type as intended in google sheet as well as in appsheet. I used to have some problems because of that.

[PowerSheetAcade]

Hi, @xnbsx

1. To automatically complete the name you must use app fomula -> USERNAME ().

[xnbsx]

I just figured that out when adding it to the timestamp!