Is there a way to make the Display Name of a view read the current dayโs date and time, to where it reads something like โThursday | March 22, 2018โ or even โThursday | March 22, 2018 | 4:32 PMโ?
Solved! Go to Solution.
Yes you can do that. You need to find the correct formula for your requirements. For example if you write CONCATENATE(TODAY()) it wil show you the view name like 3/22/2018.
Itโs dynamic, have you tried putting the expressions you want in the dynamic view display name, and itโs not working?
Yes you can do that. You need to find the correct formula for your requirements. For example if you write CONCATENATE(TODAY()) it wil show you the view name like 3/22/2018.
Sorry guys I was overthinking this. Iโm working on the expression now, and am trying to call for the day of the week but canโt find anything on calling the day of the week for AppSheet. Am I missing something?
Was thinking something like this would get me thereโฆ
CONCATENATE(WEEKDAY(TODAY()) , " | ", TODAY(), " | ", TIMENOW())
โฆ but the first argument(?) is returning a 5 which Iโm assuming means the 5th day of the week,
but Iโm looking for the word Thursday. Still working on it though.
You need to convert the day from the weekday number likeโฆ
SWITCH(WEEKDAY(TODAY()), 1,โSundayโ, โฆ 6,โFridayโ, โSaturdayโ)
@Aleksi - I would like to have the current month name shown as a display name. I was trying to use the now() function, but can only get the month number. Based on your SWITCH suggestion, would I have to do the same but enter the array of month names? (ughโฆ)
Yep.
Thanks @Aleksi_Alkio that did it!
Currently working on the TODAY() field trying to get it to display March 22, 2018. Initially thought I could get this done with TEXT(TODAY(), โmmmm d yyyyโ) but itโs saying the TEXT function is used incorrectly. This is where Iโm at nowโฆ
CONCATENATE( SWITCH(WEEKDAY(TODAY()), 1,โSundayโ, 2, โMondayโ, 3, โTuesdayโ, 4, โWednesdayโ, 5, โThursdayโ, 6,โFridayโ, โSaturdayโ), " | ", TEXT(TODAY()), " | ", TIMENOW() )
I also thought I could get the TIMENOW() to display as 1:45 PM instead of 13:45:25 by using TEXT(TIMENOW()) and that isnโt working either. Iโm in way over my head on this one lol
thanks @Steve I appreciate your answer - is there a way to add the year (or more specifically, the last 2 digits of the year (i.e. 19))?
Would that be (switchโฆ) + " '"+ (concatenate (today()) โYYโ)
SWITCH(...) & " " & RIGHT(YEAR([Date]), 2)
Perfect!
Thanks so much @Steve - I couldnโt get the '19 (specifically the โ ) to come out quite right so I just removed the Right & the 2 โฆ now it shows April 2019 - blah, blah, blah.
Yeah, AppSheet doesnโt like quoted strings that include an apostrophe as the first character for some reasonโฆ
User | Count |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |