Hi,
I have the following columns (column types):
Below are two use case scenarios when I am entering data in my form:
Scenario 1 Meeting Start and End Date are within the same day:
Scenario : Meeting Start and End Date span over more than one day:
I also do not know if the column type I select for Meeting Duration can handle both a time format needed for Scenario 1 as well as be able to input โAll Dayโ in Scenario 2
Any advice on how best to go about this?
Would it be easier if you use Time field for both Start time and End time? Then you would not need to think about the date change.
Hi Aleksi
I not with you. Please elaborate on your proposal
Instead of:
Use:
I would also like to use the Calendar view. I thought you needed date and time to be separated? Or is there another way
Now when I read your post again, I probably understood your request wrongly, sorry about that. If you are using โMeeting Start Timeโ and โMeeting End Timeโ, why do you need to fill the โMeeting Durationโ at all?
In short, the users I am designing the app for think it would makes things easier the less they need to use their brainโฆ
A example of โworking forwardsโ inputing data in the form:
The idea is to be able to have a step up or step down increment button similar to that found in the number column type. I just need to have this working with time instead
They then asked if the app is able work backwards using the same data as above.
All this without needing to do much thinking from the user side in managing all the variables.
Maybe I should just concentrate for now in just managing time and leave date as there will only be a few instances where a meeting spans over more than one day and this might be a bit to complicated to work out how to manage those variables.
So this concept reminds me of my fuel expenditure app I downloaded from the play store (Sygic Fuelio)
I am pretty sure that this can be done with relevant expressions in initial values of relevant columns. Probably also might need make use of Reset If expressions.
I can see quite a few uses cases for this kind of setup
For example, they work a bit with product costing, pricing, gross margins, profit, discounts, markupโs etc
Take a look at this calculator online app, that demonstrate similar experience to what I am after
https://www.omnicalculator.com/finance/margin
This can calculate variable backwards and forwardsโฆso to speak
Do you think appsheet has the capability to make the same kind of app?
I am thinking that I probably need to have a reset button somewhere as the app will probably not able to change values โon the flyโ like the app sort of does.
It would be great if I can have the above experience and integrate it with other data in the app.
This is where app sheet is extremely powerful!
For example:
I have a list of products with the following columns and example values
I then want to see what Net price margins after discount will be at a given discount. Or maybe what discount can I give at a certain margin:
So the idea is to play with different variable and the app calculates what is missing, when there is enough info added to do so.
I have no problem using DateTime using one column as Steve mentioned above. I just want to be able to use the Calendar view that seem to require Date and Time to be seperated.
Sorry for the long message, but maybe you have a better idea of what I wanting to achieve and to get an idea of what app design is possible to do in future.
How about if you use a simple number field with 15 increments and then you convert it back to End DateTime value when the Start Date and Time value is set (or the opposite)?
It was one of my considerations.
Questions
1.1. If notโฆ must use an expression that splits datetime into two virtual columns? One for date and another for time and then use these in the calendar view?
1.2. What expression do I use for the virtual column if this is what you are suggesting?
2.1. I created another two columns to experiment as using them as a datetime type.
What expression would I use that will calculate Meeting End from Meeting Start if the Meeting Duration is either of the following column types options
2.1.1 Duration
2.1.2 Number as suggested by you and factoring in question 1
2.1.3 Time
The following produced and error
[Meeting Start] + [Meeting Duration]
What am I missing?
You can calculate the duration from the number field like
FLOOR([DURATION]/60)&":"&RIGHT(โ00โ&MOD([DURATION],60),2)&":00"
Thanks for the help, but the number type does not seem to be a good option as it gets a bit complicate to interpret how many hours and minutes something when you are input the value into the form without have a virtual column to check with the interpreted duration of the number.
Is then possible to calculate [Meeting End] from
[Meeting Start]+[Meeting Duration]
Where [Meeting End] and [Meeting Start] are a datetime column type and [Meeting Duration] is either a Duration or a Time column type?
I was looking at the following help documents and notice them mentioning the following about duration.
Going to see if that make a difference.
Note that each of HOUR() , MINUTE() , and SECOND() accept as input a Duration value, not a Time value. To convert a Time value to a Duration value, subtract another Time value. For instance, to convert the current time-of-day to a Duration :
TIMENOW() - "00:00:00"
.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |