• State Suggested Answer
  • +4 person also asked this people also asked this
  • Replies 24 replies
  • Answers 2 answers
  • Subscribers 17 subscribers
  • Views 20780 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

How we can generate Calendar?

Aswini

Hi,

I want to generate Calendar.

I have 2 fields, month and year, If I select any( month,year) then that corresponding Calendar must be displayed in the grid format.

Can u please tell me , how can I implement this calendar?

Thanks In Advance

Aswini

  Discussion posts and replies are publicly visible

  • 0 in reply to ankitr0866

    HI Team,

    It works all fine but fails at DEC 2024

    is this fixed if Fixed can the you please shared me the Updated one

  • 0
    Certified Associate Developer
     in reply to NewBegineer

    Hi 

    I have attempted to resolve the issue, and this is the latest version of the code. Please take a look at it.

    a!localVariables(
  local!clicked,
  local!date,
  local!week: {
    "SUN",
    "MON",
    "TUE",
    "WED",
    "THU",
    "FRI",
    "SAT"
  },
  local!months: {
    "January",
    "February",
    "March",
    "April",
    "May",
    "June",
    "July",
    "August",
    "September",
    "October",
    "November",
    "December"
  },
  local!month: month(today()),
  local!year: year(today()),
  local!space: a!forEach(
    items: enumerate(
      weekday(date(local!year, local!month, 1)) - 1
    ),
    expression: " "
  ),
  local!dates: append(
    local!space,
    enumerate(daysinmonth(local!month, local!year)) + 1
  ),
  a!sectionLayout(
    contents: {
      a!cardLayout(
        contents: {
          a!richTextDisplayField(
            value: {
              a!richTextItem(
                text: " CALENDAR ",
                color: "#f59b42",
                size: "LARGE",
                style: "STRONG"
              )
            },
            align: "CENTER"
          )
        },
        style: "INFO",
        shape: "ROUNDED",
        marginBelow: "STANDARD",
        showBorder: false()
      ),
      a!cardLayout(
        contents: {
          a!columnsLayout(
            columns: {
              a!columnLayout(
                contents: {
                  a!cardLayout(
                    contents: {
                      a!columnsLayout(
                        columns: {
                          a!columnLayout(
                            contents: {
                              a!richTextDisplayField(
                                labelPosition: "ABOVE",
                                value: a!richTextItem(
                                  text: local!months[local!month] & ", " & local!year,
                                  color: "ACCENT",
                                  size: "MEDIUM_PLUS",
                                  style: "STRONG"
                                ),
                                align: "CENTER"
                              )
                            }
                          ),
                          a!columnLayout(
                            contents: {
                              a!dropdownFieldByIndex(
                                label: "Month",
                                labelPosition: "ABOVE",
                                choiceLabels: local!months,
                                value: local!month,
                                saveInto: {
                                  local!month,
                                  a!save(
                                    local!space,
                                    a!forEach(
                                      items: enumerate(weekday(1 / local!month / local!year, 1)),
                                      expression: " "
                                    )
                                  ),
                                  a!save(local!clicked, null()),
                                  a!save(local!dates, null()),
                                  a!save(
                                    local!dates,
                                    append(
                                      local!space,
                                      enumerate(daysinmonth(local!month, local!year)) + 1
                                    )
                                  )
                                }
                              )
                            }
                          ),
                          a!columnLayout(
                            contents: {
                              a!dropdownField(
                                label: "Year",
                                labelPosition: "ABOVE",
                                choiceLabels: 100 + enumerate(year(today())),
                                choiceValues: 100 + enumerate(year(today())),
                                value: local!year,
                                saveInto: {
                                  local!year,
                                  a!save(
                                    local!space,
                                    a!forEach(
                                      items: enumerate(weekday(1 / local!month / local!year, 1)),
                                      expression: " "
                                    )
                                  ),
                                  a!save(local!dates, null()),
                                  a!save(
                                    local!dates,
                                    append(
                                      local!space,
                                      enumerate(daysinmonth(local!month, local!year)) + 1
                                    )
                                  )
                                },
                                searchDisplay: "AUTO",
                                validations: {}
                              )
                            }
                          )
                        },
                        alignVertical: "BOTTOM"
                      ),
                      a!cardLayout(
                        contents: {
                          a!cardLayout(
                            contents: {
                              a!columnsLayout(
                                columns: {
                                  a!forEach(
                                    items: enumerate(length(local!week)) + 1,
                                    expression: a!columnLayout(
                                      contents: a!cardLayout(
                                        contents: a!richTextDisplayField(
                                          labelPosition: "ABOVE",
                                          value: {
                                            if(
                                              or(fv!item = 1),
                                              a!richTextItem(
                                                text: index(local!week, fv!item, ""),
                                                color: "NEGATIVE",
                                                size: "MEDIUM_PLUS",
                                                style: "STRONG"
                                              ),
                                              or(fv!item = 7),
                                              a!richTextItem(
                                                text: index(local!week, fv!item, ""),
                                                color: "POSITIVE",
                                                size: "MEDIUM_PLUS",
                                                style: "STRONG"
                                              ),
                                              a!richTextItem(
                                                text: index(local!week, fv!item, ""),
                                                size: "MEDIUM_PLUS",
                                                style: "STRONG"
                                              ),
                                              
                                            )
                                          },
                                          align: "CENTER",
                                          marginAbove: "NONE",
                                          marginBelow: "NONE"
                                        ),
                                        shape: "ROUNDED",
                                        showBorder: true,
                                        
                                      ),
                                      
                                    )
                                  )
                                },
                                marginBelow: "STANDARD"
                              )
                            },
                            padding: "NONE",
                            marginBelow: "NONE",
                            showBorder: false
                          ),
                          a!cardLayout(
                            contents: {
                              a!forEach(
                                items: enumerate(
                                  if(
                                    mod(length(local!dates), 7) = 0,
                                    quotient(length(local!dates), 7),
                                    sum(quotient(length(local!dates), 7) + 1)
                                  )
                                ),
                                expression: a!columnsLayout(
                                  columns: {
                                    a!forEach(
                                      items: (fv!index - 1) * 7 + enumerate(7) + 1,
                                      expression: a!columnLayout(
                                        contents: a!cardLayout(
                                          contents: if(
                                            index(local!dates, fv!item, " ") = " ",
                                            a!richTextDisplayField(
                                              value: a!richTextItem(
                                                text: index(local!dates, fv!item, ""),
                                                size: "MEDIUM_PLUS"
                                              ),
                                              align: "CENTER"
                                            ),
                                            a!richTextDisplayField(
                                              value: a!richTextItem(
                                                text: index(local!dates, fv!item, ""),
                                                size: "MEDIUM_PLUS"
                                              ),
                                              align: "CENTER"
                                            )
                                          ),
                                          showBorder: and(
                                            index(local!dates, fv!item, " ") <> " ",
                                            index(local!dates, fv!item, " ") <> "",
                                            
                                          ),
                                          link: a!dynamicLink(
                                            value: index(local!dates, fv!item, " "),
                                            saveInto: {
                                              local!clicked,
                                              a!save(
                                                local!date,
                                                date(
                                                  local!year,
                                                  local!month,
                                                  tointeger(local!clicked)
                                                )
                                              )
                                            },
                                            showWhen: and(
                                              index(local!dates, fv!item, " ") <> " ",
                                              index(local!dates, fv!item, " ") <> "",
                                              index(local!dates, fv!item, " ") <> ";",
                                              
                                            )
                                          ),
                                          shape: "ROUNDED",
                                          style: if(
                                            a!isNotNullOrEmpty(local!clicked),
                                            if(
                                              index(local!dates, fv!item, " ") = local!clicked,
                                              "#fc031c",
                                              if(
                                                and(
                                                  index(local!dates, fv!item, " ") = day(today()),
                                                  local!month = month(today()),
                                                  local!year = year(today())
                                                ),
                                                "#9dfc03",
                                                "NONE"
                                              )
                                            ),
                                            ""
                                          )
                                        )
                                      )
                                    )
                                  },
                                  alignVertical: "MIDDLE",
                                  spacing: "STANDARD"
                                )
                              )
                            },
                            showBorder: false(),
                            padding: "NONE"
                          ),
                          
                        }
                      )
                    },
                    padding: "NONE",
                    showBorder: true(),
                    style: "ERROR"
                  )
                }
              ),
              
            },
            showDividers: true()
          )
        },
        shape: "ROUNDED",
        showBorder: true(),
        style: "STANDARD"
      )
    }
  )
)

  • 0
    Certified Associate Developer
     in reply to NewBegineer

    hi,

    I have attempted to resolve the issue, and this is the latest version of the code. Please take a look at it."

    a!localVariables(
  local!clicked,
  local!date,
  local!week: {
    "SUN",
    "MON",
    "TUE",
    "WED",
    "THU",
    "FRI",
    "SAT"
  },
  local!months: {
    "January",
    "February",
    "March",
    "April",
    "May",
    "June",
    "July",
    "August",
    "September",
    "October",
    "November",
    "December"
  },
  local!month: month(today()),
  local!year: year(today()),
  local!space: a!forEach(
    items: enumerate(
      weekday(date(local!year, local!month, 1)) - 1
    ),
    expression: " "
  ),
  local!dates: append(
    local!space,
    enumerate(daysinmonth(local!month, local!year)) + 1
  ),
  a!sectionLayout(
    contents: {
      a!cardLayout(
        contents: {
          a!richTextDisplayField(
            value: {
              a!richTextItem(
                text: " CALENDAR ",
                color: "#f59b42",
                size: "LARGE",
                style: "STRONG"
              )
            },
            align: "CENTER"
          )
        },
        style: "INFO",
        shape: "ROUNDED",
        marginBelow: "STANDARD",
        showBorder: false()
      ),
      a!cardLayout(
        contents: {
          a!columnsLayout(
            columns: {
              a!columnLayout(
                contents: {
                  a!cardLayout(
                    contents: {
                      a!columnsLayout(
                        columns: {
                          a!columnLayout(
                            contents: {
                              a!richTextDisplayField(
                                labelPosition: "ABOVE",
                                value: a!richTextItem(
                                  text: local!months[local!month] & ", " & local!year,
                                  color: "ACCENT",
                                  size: "MEDIUM_PLUS",
                                  style: "STRONG"
                                ),
                                align: "CENTER"
                              )
                            }
                          ),
                          a!columnLayout(
                            contents: {
                              a!dropdownFieldByIndex(
                                label: "Month",
                                labelPosition: "ABOVE",
                                choiceLabels: local!months,
                                value: local!month,
                                saveInto: {
                                  local!month,
                                  a!save(
                                    local!space,
                                    a!forEach(
                                      items: enumerate(weekday(1 / local!month / local!year, 1)),
                                      expression: " "
                                    )
                                  ),
                                  a!save(local!clicked, null()),
                                  a!save(local!dates, null()),
                                  a!save(
                                    local!dates,
                                    append(
                                      local!space,
                                      enumerate(daysinmonth(local!month, local!year)) + 1
                                    )
                                  )
                                }
                              )
                            }
                          ),
                          a!columnLayout(
                            contents: {
                              a!dropdownField(
                                label: "Year",
                                labelPosition: "ABOVE",
                                choiceLabels: 100 + enumerate(year(today())),
                                choiceValues: 100 + enumerate(year(today())),
                                value: local!year,
                                saveInto: {
                                  local!year,
                                  a!save(
                                    local!space,
                                    a!forEach(
                                      items: enumerate(weekday(1 / local!month / local!year, 1)),
                                      expression: " "
                                    )
                                  ),
                                  a!save(local!dates, null()),
                                  a!save(
                                    local!dates,
                                    append(
                                      local!space,
                                      enumerate(daysinmonth(local!month, local!year)) + 1
                                    )
                                  )
                                },
                                searchDisplay: "AUTO",
                                validations: {}
                              )
                            }
                          )
                        },
                        alignVertical: "BOTTOM"
                      ),
                      a!cardLayout(
                        contents: {
                          a!cardLayout(
                            contents: {
                              a!columnsLayout(
                                columns: {
                                  a!forEach(
                                    items: enumerate(length(local!week)) + 1,
                                    expression: a!columnLayout(
                                      contents: a!cardLayout(
                                        contents: a!richTextDisplayField(
                                          labelPosition: "ABOVE",
                                          value: {
                                            if(
                                              or(fv!item = 1),
                                              a!richTextItem(
                                                text: index(local!week, fv!item, ""),
                                                color: "NEGATIVE",
                                                size: "MEDIUM_PLUS",
                                                style: "STRONG"
                                              ),
                                              or(fv!item = 7),
                                              a!richTextItem(
                                                text: index(local!week, fv!item, ""),
                                                color: "POSITIVE",
                                                size: "MEDIUM_PLUS",
                                                style: "STRONG"
                                              ),
                                              a!richTextItem(
                                                text: index(local!week, fv!item, ""),
                                                size: "MEDIUM_PLUS",
                                                style: "STRONG"
                                              ),
                                              
                                            )
                                          },
                                          align: "CENTER",
                                          marginAbove: "NONE",
                                          marginBelow: "NONE"
                                        ),
                                        shape: "ROUNDED",
                                        showBorder: true,
                                        
                                      ),
                                      
                                    )
                                  )
                                },
                                marginBelow: "STANDARD"
                              )
                            },
                            padding: "NONE",
                            marginBelow: "NONE",
                            showBorder: false
                          ),
                          a!cardLayout(
                            contents: {
                              a!forEach(
                                items: enumerate(
                                  if(
                                    mod(length(local!dates), 7) = 0,
                                    quotient(length(local!dates), 7),
                                    sum(quotient(length(local!dates), 7) + 1)
                                  )
                                ),
                                expression: a!columnsLayout(
                                  columns: {
                                    a!forEach(
                                      items: (fv!index - 1) * 7 + enumerate(7) + 1,
                                      expression: a!columnLayout(
                                        contents: a!cardLayout(
                                          contents: if(
                                            index(local!dates, fv!item, " ") = " ",
                                            a!richTextDisplayField(
                                              value: a!richTextItem(
                                                text: index(local!dates, fv!item, ""),
                                                size: "MEDIUM_PLUS"
                                              ),
                                              align: "CENTER"
                                            ),
                                            a!richTextDisplayField(
                                              value: a!richTextItem(
                                                text: index(local!dates, fv!item, ""),
                                                size: "MEDIUM_PLUS"
                                              ),
                                              align: "CENTER"
                                            )
                                          ),
                                          showBorder: and(
                                            index(local!dates, fv!item, " ") <> " ",
                                            index(local!dates, fv!item, " ") <> "",
                                            
                                          ),
                                          link: a!dynamicLink(
                                            value: index(local!dates, fv!item, " "),
                                            saveInto: {
                                              local!clicked,
                                              a!save(
                                                local!date,
                                                date(
                                                  local!year,
                                                  local!month,
                                                  tointeger(local!clicked)
                                                )
                                              )
                                            },
                                            showWhen: and(
                                              index(local!dates, fv!item, " ") <> " ",
                                              index(local!dates, fv!item, " ") <> "",
                                              index(local!dates, fv!item, " ") <> ";",
                                              
                                            )
                                          ),
                                          shape: "ROUNDED",
                                          style: if(
                                            a!isNotNullOrEmpty(local!clicked),
                                            if(
                                              index(local!dates, fv!item, " ") = local!clicked,
                                              "#fc031c",
                                              if(
                                                and(
                                                  index(local!dates, fv!item, " ") = day(today()),
                                                  local!month = month(today()),
                                                  local!year = year(today())
                                                ),
                                                "#9dfc03",
                                                "NONE"
                                              )
                                            ),
                                            ""
                                          )
                                        )
                                      )
                                    )
                                  },
                                  alignVertical: "MIDDLE",
                                  spacing: "STANDARD"
                                )
                              )
                            },
                            showBorder: false(),
                            padding: "NONE"
                          ),
                          
                        }
                      )
                    },
                    padding: "NONE",
                    showBorder: true(),
                    style: "ERROR"
                  )
                }
              ),
              
            },
            showDividers: true()
          )
        },
        shape: "ROUNDED",
        showBorder: true(),
        style: "STANDARD"
      )
    }
  )
)

© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.