Ideas

Date Formatting for Exports to Excel

5

Login To Vote

Date Formatting for Exports to Excel

Core

In every grid where there’s an option to export results to Excel, Rock exports date fields as text (or custom fields that behave like text), rather than as proper date fields. This causes issues when trying to sort the spreadsheet by date, as the sorting doesn’t work correctly (See the example of what it's like to sort by birthdate below).

While there are workarounds in Excel, such as using formulas or advanced formatting options, these solutions require a level of expertise many users may not have. For those unfamiliar or untrained, it can be confusing and frustrating to deal with these types of data issues.

If Rock exported data into Excel with formatting that matched the corresponding data types natively, this problem would be resolved, and users wouldn’t need to perform additional steps. (Having a similar principle apply to other types of fields for example money would be ideal as well)


Sort.png


Photo of Jason HarveySubmitted by Jason Harvey, Grace Church of Overland Park  ·   ·  Core
Remove Votes
Login to add a comment...

Submission Success Tips

Cultivate your ideas for maximum impact with these helpful submission tips that will increase the chances of your brilliant concepts becoming reality.

  • Clear Title: Craft a straightforward and descriptive title that instantly conveys the essence of your idea.
  • Concise Description: Provide an idea description that is succinct, ensuring it effectively communicates the concept without unnecessary verbosity.
  • Provide Additional Details: With a concise description complete, now provide any other details that are needed to better understand the requirements.
  • Thorough Ministry Need Review: Provide a comprehensive overview of the ministry need your idea addresses, emphasizing its significance.
  • Cover the WHY: Clearly articulate the rationale behind your idea, explaining why it's essential and how it aligns with the organization's goals and mission. Oftentimes a clear "why" sheds light into other possible options.