Question
Shell India market private limited
IN
Last activity: 22 May 2023 3:29 EDT
Need to update the Dynamic layout name in section with Current Year and Previous quarter (auto populate according to the year)
Hi,
We have an requirement whereas we need to auto display the Dynamic layout name in section with Current Year and Previous quarter (auto populate according to the year) based on the current year.
Example: 2023 Q1
We are displaying the report from navigation pane for that we have called Harness, Inside Harness we have we have section. Inside section we have Dynamic layout and table, so here we are trying to update the title for the dynamic layout with the format of <Current Year><Previous Quarter>. This current year and previous quarter should auto populate, for example if we are in the 2023 Q2 , then the name should display 2023 Q2 QC Report, if we are in 2024 Q1, then name should auto display when user clicks the report 2024 Q1.
We are trying this with filed values in Dynamic layout instead of title. Please advise the best way to achieve this functionality
ING Nederland
NL
Hi @MadhuR16578287, in the dynamic layout click on the gear icon and in properties set the title to a property's value (say .ReportName) and then create a declare expression on this property which will calculate your "Year + Quarter+ Report Name". Please see screenshot below:
Shell India market private limited
IN
@SaurabhG7134 Hi, thanks for your support.
Can you please provide the declare expression for the property which will calculate "Year + Quarter+ Report Name"
or provide the expression below (i have created text property ReportName)
ING Nederland
NL
@MadhuR16578287 sure, please check the screenshot below:
Here, instead of AppName use the property you have created.
The expression: @year(@today())+" Q"+((@month(@today())+1)/4).