Best Of
Re: Getting Buzz message when a form submitted
Atieh, because today, you can't have an App Studio form submission start a workflow.
Ideally, either the form submission could start a workflow OR the form submission dataset would support dataset alerts. Neither of those things are possible right now, unfortunately. The form submission starting a workflow should be available soon.
A happy medium might be building a table card that visualizes the form submissions, and creating an alert based on a new value landing on that table card.
Full-Size Card Background Color and Filters Background Color
I have created DOMO dashboards with a color scheme that is in-line with my web application. The embedding of the dashboard is seamless. However, When I expand on a card, the background is the defualt white background. Additionally, when I click on the filter icon in my application, the filters bar is also the default color of the DOMO application. How do I edit the color scheme of the filter bar's background and the background of the card when it is expanded?
ekishab
Re: How to get Gross Sales from Shopify?
According to their documentation Net Sales is Gross - Discounts - Returns + Taxes + Shipping so you should be able to back into Gross sales with:
Gross = total_price + total_discounts + returns - total_tax - total_shipping_price_set_presentment_money_amount
Refunds/Returns isn't included in the All Orders report in the API, you'll also need to pull the Refunds report.
How to get Gross Sales from Shopify?
My team and I are in the process of building datasets from Shopify's API but we are not able to get the gross sales amount to match with the gross sales amount in the Shopify's dashboard.
Does anyone have any insights on this?
We selected the report "All Orders". We have played with all columns, total_price, subtotal_price, total_discounts, total_tax and others.
Thanks
Re: Mass Renaming Columns
Sounds like you are going to want your select columns json data to look like this:
{"name":"A_Date"},{"name":"A_Invoice #"},{"name":"A_VV#"}
One easy way to do this in a text editor would be to do a find and replace and replace "name":" with "name":"A_
This should prefix each of those columns with A_
Re: Mass Renaming Columns
@AdamC To have the syntax appear for the "rename", you need to at least rename one of them before copying.
Jmoreno
Re: Can I run a Stored Procedure to an external MS SQL and import resulting dataset?
Thanks Chris! I had been trying to do it with a standard SQL connector to no avail. Workbench seems to be the lynchpin to making all of this happen for us.
I appreciate the help!
Barb
Re: Table, compare several month-over-month
Hey Rodriguez,
Do you mind sharing the code for this table specifically from the 3rd field to the end. Trying to replicate this same table and can use your help. Thanks alot
Re: Scheduled Report - Excel Attachement
Would also like to see scheduled reports in Excel vs CSV. The formatting of table cards is completely removed when exported to csv, including rows with subtotals. This makes it difficult for the end user to properly interpret the data that is being sent.