ArborRose Coach

Since each phone number is in the format XXXXXXXXXX, you can try \b\d{10}\b as a regular expression. This should match 10 digits surrounded by word boundaries.

This appears to work when I test it. It uses event.preventDefault to bypass the default action.

If the text is consistent….such as Jan always being "Jan"…you could split the values into multiple columns. One for the day and one for the short month name. Then convert the short month into its corresponding full month name, or use some logic in a formula to get the months back into a numeric. Then combine the day, full…

Is this what you are looking for? In Python….. import requests client_id = 'your_client_id'client_secret = 'your_client_secret'url = 'https://api.domo.com/oauth/token'data = { 'grant_type': 'client_credentials', 'client_id': client_id, 'client_secret': client_secret } response = requests.post(url, data=data) token =…

If you have checked for updates and you trust the source, you could go the Mac's Gatekeeper settings and try to bypass. Adjust Gatekeeper settings to allow apps from unidentified developers to be opened. Open "System Preferences" from the Apple menu. Click on "Security & Privacy." In the "General" tab, look for something…

It does not error when I click the preview. The file is xlsx.

@mroker - Glad to hear it's working. After you get your API configured, I suggest making sure the data structure matches your data. The JSON connectors will try to guess at what your data is. If your field holds a date, make sure its a date. Not a string, not datetime…a date. Make sure joining identifiers come across as…

Whoa. I feel for you. I really do. I used Salesforce many years ago after a company acquisition. But I did not have to migrate, it was a fresh start for me with the new company. I hope someone can add some good advice. I think you're going to have to do all the data mapping for the new organization first. Such as…

Potential reasons…. Permissions Issue: Ensure that the Google account you're using to connect to Google Analytics through Domo has the necessary permissions to access the views in Google Analytics. You need to have at least "Read & Analyze" access at the view level. Data Availability: Make sure that there is data available…

If you are trying to call an API, perhaps you could look at the Domo AppStore for an appropriate API connector. Search JSON. Some connectors require tokens or some type of authentication account to be configured. Possibly something like the No Code oAuth Connector. I use this type of connector to connect to my data source.…

In Domo, the route map feature typically allows users to visualize routes between two locations using latitude and longitude coordinates. However, creating a triangle with three variables (locations) is not directly supported in the standard route map feature.

In Domo, you can set up alerts to notify you if the alert has not fired in 72 hours or if there are errors preventing it from firing. Here's how you can do it: Setting up Alerts for Non-Firing: Go to the page where you have set up the alert. Click on the alert you want to modify. Look for the option to set up a schedule or…

If I grasp the question correctly… If you are setting up an API, you want to go to the Domo AppStore and find the proper API connector. Type JSON in the search. Something like the JSON no code connector. In the connector you will input your settings like the URL you show. "updateMethod" looks like a parameter. You should…

https://community-forums.domo.com/main/discussion/comment/89320#Comment_89320 I'm using current_timestamp(). Which gives me a date and a time. I plan to only pull once per date. Which makes the time unnecessary. But if I (or another coworker) triggers it to pull more than once in a day, I need to make sure it can tell…

@mroker - have a look in recent discussions for my question on "Effective Dating". This sounds exactly like what I am doing and the solution I created appears to work. My dataset is coming from an API scheduled daily. I append any records that are new or change to create an archive.

https://community-forums.domo.com/main/discussion/comment/89298#Comment_89298 What if on a given day, a patient schedules more than one appointment? Wouldn't using a rank of 1 give me only one of the appointments, or a change in appointment, but the others would be lost?

https://community-forums.domo.com/main/discussion/comment/89304#Comment_89304 I appreciate the help and insights. I may not be doing this right…but the unique field I'm using is my archive timestamp and my partition is set to all the other fields. This puts every record in a chronologic order. Then when I remove duplicates…

https://community-forums.domo.com/main/discussion/comment/89298#Comment_89298 That is what I am doing in example I showed. I created that ETL yesterday and ran it. Now I have this morning's data…it appears to work. Based on what I see, I have records of just the changes or new appointments. I'm still validating the data.…

In the new ETL features, the Group By tile now has a concatenation for strings. Have you tried it?

I don't believe you could do it in the API. As you state, you can implement that after receiving the dataset. I would think it would rely on the source of the API implementing the partition.

A follow-up comment to my mock-up. I need to see what was recorded based on the entries at that time I take a snapshot of the changes. A record may say an appointment took place on date X. It does not matter what the date X says. I need to order my records based on what was in the data…not based on what the data says. So…

@Colemen, I mocked up an example of how I think I will implement this, below. Every morning I gather the current appointments. I need to build a dataset of all appointments, but only where there are changes in any field. This keeps the dataset smaller. In this example, assume I want to see a view of what the appointments…

Convert the time values to numerical format. Then sum up the numerical values. Convert time values to seconds: If your time values are in the format "HH:MM:SS", you can use the following formula to convert them to seconds: (hours * 3600) + (minutes * 60) + seconds. For example, for the time value "00:04:25", the…

With Windows 11, the Snipping Tool has a copy text feature. https://www.pcworld.com/article/2070861/windows-snipping-tool-gets-text-recognition-for-screenshots.html#:~:text=You%20can%20select%20and%20copy,%2BA%20and%20Ctrl%2BC.

You can try using your browser's developer tools to inspect the element containing the number and manually copy it from there. This method requires some familiarity with HTML and JavaScript. Or export and then copy.

Check your workbench configuration, API credentials, configurations and endpoints. Review logs to read the details. Verify your data sources are still accessible. Check network connectivity. Make sure there's no network issue preventing Domo workbench from accessing the data source. Restart workbench and server. Sometimes…

It seems like Domo is aggregating the data based on the "maximum number of items" setting you've specified. When you set the maximum number of items to 2, Domo is likely displaying the top two countries with the highest values and then grouping the remaining countries under an "Other" category. In your dataset: The highest…

You are putting 2 into maximum items. That's not top 2. Look where it shows LIMIT ROWs. Set that to 2. And remove 2 from maximum items.

I still don't get that result with a tooltip. If your data comes from Excel, try formatting the columns before using it.

Can you show us what you are doing with tooltip? I do not get that response from Domo based on what you show…assuming your fields are defined as date, text, and numeric as shown below.