ArborRose Coach

@calvert_schaefer - I see what you are saying. There is no option for keeping the leading zeros when you use that connector. I think you need to submit to Domo Support. Is there a reason for using that connector rather than just upload a spreadsheet under the data center?

I’d like to see webinars that explore working with data collections as opposed to standard datasets. For example, writing to a data collection using Python in the ProCode editor and then interacting with that collection in a workflow. It would also be great to dive deeper into how manifests play a role in that process.…

Let's see if we can get conversation going and get you working. Domo workflows may be representing the duration in ISO 8601 format. Such as P3D (3 days), PT2H (2 hours. If that's the case, you could try calculating daysUntilEnd as the number of days between current datetime and product end date. If the number is 5, convert…

Sample data: Product,Sales Product A,1200 Product B,950 Product C,870 Product D,1500 Product E,400 Product F,200 Product G,1750 Product H,300 Product I,100 Product J,600 ETL: Group By: Rank: Gives: Then create beast mode as Product Group: CASE WHEN `Top N` <= 5 THEN `Product` ELSE 'Others' END

Create an ETL and use the Rank and Window tile to rank products by sales. Or beast mode with something like RANK() OVER (ORDER BY SUM(`Sales`) DESC) Once you have a ran defined you can create a beast mode CASE WHEN {rank} < = 5 THEN `Product` ELSE 'Others' END

@ColemenWilson I'm not smart enough for that fancy math. I have to use fingers and toes.

Using what I showed. If the week ends on Sunday, the formulas change to DATE_ADD(`StartDate`, CASE WHEN WEEKDAY(`StartDate`) = 1 THEN 0 ELSE 8 - WEEKDAY(`StartDate`) END) DATE_ADD(`ActualEndDate`, CASE WHEN WEEKDAY(`ActualEndDate`) = 1 THEN 0 ELSE 8 - WEEKDAY(`ActualEndDate`) END) I don't have raw detail records to match…

Why can't you do it on a card? CompanyName,PositionDateCreated,DateFilled,StartDate,EstimatedEndDate,ActualEndDate,LastDateWorked Company A,2014-02-25,2014-02-25,2014-03-07,2024-01-01,,2025-05-14 Company B,2014-05-21,2014-05-21,2014-05-19,2025-07-27,,2025-06-15 Company…

domo.onDataUpdate() triggers after the dataset updates. It's not intended to prevent the refresh. So you can react to data changes, but not intercept them. You may be able to do a work-around by writing to a temporary staging dataset. Then schedule an ETL to move the data.

Interesting….yes, it appears that Domo should make some additions to the support page. I would assume the queries have a single dataset limitation. Domo dataflows use MySQL syntax, so try that rather than MS SQL syntax. Use backtick as common practice for calling out datasets or fields. I recall that working for me. I've…

Congratulations @MarkSnodgrass! 🐐 I actually don't know how to type a goat, I had to steal one of @Data_Devon 's. ;)

@JasonAltenburg - even if @art_in_sky does not want to see the code, I do. It looks like a great example of using forms and workflows. Do you have a online demo of this? Oh btw, sorry to hear about your illness with the ooz. Best wishes on a swift recovery.

Did the other one have a placeholder in the manifest? Something like: "schema": { "type": "object", "properties": {} }

I've never connected the JSON connectors with a token, so this is a guess. But you may need to enter it as a header parameter. And it might be simpler to use the standard no code JSON connector.

The brick probably doesn't use the schema. When converted to an App, without a schema defined, it doesn't know the structure to save the changes. So it wants you declare the schema for the collection. There should be a manifest.json file you can add the schema property to. Something like: { "collections": { "myCollection":…

It sounds like you want to calculate on-time deliver percent on sales orders (document /order number), not lines. Your beast mode tags each line as on-time, late, or whatever - rather than each order. You probably may need something with a FIXED() CASE WHEN MAX(CASE WHEN `SO OTD Tag` = 'Late' THEN 1 ELSE 0 END) OVER…

If you want to use variables, you could create variables for comparing date range A with date range B. You will need a start and end for A range, and a start and end for B range. Then use a beast most to identify what belongs to range A and what belongs to range B. Filter out the other. CASE WHEN `Date` BETWEEN `Start Date…

You can track the calendar differences by using your primary date field and creating fields for year({datefield}, month({datefield}, monthname({datefield}) and the use aggregates in Magic ETL to calculate current year, previous year, previous 2 years, etc. How deep you decide you need is based on whether you need it down…

One way would be to use a beast mod calculation to create a column as a "reclass". CASE WHEN `Location` LIKE '%LOVES%' THEN 'LOVES' WHEN `Location` LIKE '%TA%' THEN 'TA' WHEN `Location` LIKE '%SPEEDWAY%' THEN 'SPEEDWAY' ELSE 'OTHER' END Opps…I accidently entered before I was done. That would create a new row for each:…

Have you tried using the Rest API with append? POST https://api.domo.com/v1/datasets/{datasetId}/data?updateMethod=APPEND You mentioned looking for reference page. https://developer.domo.com/docs/tools/domo-js

You are using: domo.post(/data/v1/${datasetId}, [submission]) but I don't see where you are running this as a brick or app. Have you deployed this as a app within Domo? We can't see the whole manifest in your screenshot. Do you have it set to write? Otherwise, it might be treated as read-only. "dataSets": [ { "name":…

This isn't my area of expertise but maybe we can get some discussion going to help you solve it. Yes, I would think concatenating fields would help with the uniqueness and avoid your upsert issue. It would simplify the logic of what constitutes a unique record. Maybe create a new field with something like:…

If the objective is a column with the current date or date/time, why not just use a function tile?

When you say it was successful - do you mean it says it was successful, or that you actually got your data back from the executed code? The error suggests the user is not authorized to access that dataset. The domo.ds_get() fetches meta data or schema but probably fails on the retrieval of actual data. Token or account may…

I don't like having those icons up there, at all. I'd rather see Domo spend time coding a default for variables (100+ upvotes) then adding icons we don't need. When we started using Domo I was told we could request removal of "Buzz" from the interface. I did request it be remove but it is still. Maybe you get to request…

I don't have the available time to work through an example. This is just how I would approach the problem. I would try setting up the webform and set permissions where owner is the logged-in user. Make sure it filters PDP to that specific person only. So feedback editing is allowed only for them. If Domo won't allow it to…

If you click on that gear, does it show the App name with a form to change it?

Ha ha ha. Email them - support@domo.com.

If it's a repeatable issue, I think you should log it with Domo Support. Since it works in Domo AI Playground but not workflows, there seems to be a limitation in workflow's image to text. They probably use a different API. Or there may be something in the image metadata that's an issue.

How about a webform with a dataset that holds your task data: time, type, follow-up, owner, and feedback. Display the data in a table and use filters and PDP (personalized permissions) to restrict users to only their tasks? And have them edit the webform to update their feedback? Or you could create a custom brick using…