Table Card > Export to Excel formatting
Hi,
I've noticed something when exporting a Table card into Excel.
Example:
on the card , Date fields show as 2016-11-09
when send/export to Excel it shows up as 9-Nov-2016
is there a way to set the format in which the columns will be once the user export it to excel ?
on export , column 1 as Tex , column 2 as short date, column 3 as long date/time, column 4 as currency 2
etc.
Thanks
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'
Best Answer
-
Hello @Godiepi,
Great question. Sadly there is not an easy way to define the formatting of the column before it is exported.
Through beastmode you can format columns slightly.
For date columns we can use: Date_Format() to change visual of the date. -- This will convert the column to be a string
To shorten a date from a date/time we can use: DATE(`date_time_column`)
Hope this helps!**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Answers
-
Hello @Godiepi,
Great question. Sadly there is not an easy way to define the formatting of the column before it is exported.
Through beastmode you can format columns slightly.
For date columns we can use: Date_Format() to change visual of the date. -- This will convert the column to be a string
To shorten a date from a date/time we can use: DATE(`date_time_column`)
Hope this helps!**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
It would be great if we could format each column to export, sometimes clients ask for reports to be sent out in certain format. we are trying to put them in Domo so that our clients can export them anytime, but the export cannot be formatted. Could it be added as an Idea ? Thanks
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
Please search the ideas exchange and then suggest it as an idea in case someone else has not yet submitted it.
Thanks!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive