Hi,
In the FORM view, i need to display Time duration Start and end, by grouping start time and end time together for user to set them.
currently the way i have it , app sheet is showing it seperately as below. which is not looking good.
(Current view as below, its messy as i have 4 seperate line items for check in start, end and checkout start and end, which is not User friendly and clumsy to set.)
I have seen on some video on app sheet where it was done.
i like this view to be as below: grouped together: side by side.
Check-in Time window :
[<START TIME>] [<END TIME>]
Check-out Time window:
[<START TIME>] [<END TIME>]
Any help is appreciated.
Solved! Go to Solution.
It is not possible to have two input fields display on the same line.
Something like?
CONCATENATE([<START TIME>]," ",[<END TIME>])
You may need to use this if the date or time formats are not displaying correctly
no i meant the fields to enter the time , instead of one line for each time, for enter and exit row
i need one row for two fields grouped together enter time and exit time.
So rather than someone entering:
[<START TIME>]=09:00
[<END TIME>]=12:00
You want them to be able to enter say "0900 1200", then thats possible. But makes any formulas a bit more ocmplicated.
Alternatively, Appsheet has a duration type column where for the above example you could instead get them to enter "03:00:00".
Thanks for the response, im basically not looking for a formula but rather a display issue of having two times entry or date in a single row
It is not possible to have two input fields display on the same line.
User | Count |
---|---|
18 | |
11 | |
11 | |
8 | |
4 |