Best Of
Re: Merging Outlook Meeting & Sales Lead Data
I assume your cc emails are in one string and separated by a comma or semicolon. You are going to need to get them separated so that you have one e-mail address per row. You can do this with a method that I walk through in this video.
In the walkthrough, I am separating out strings of words into single words by looking for the space between words to build a word cloud. You would follow the same process, but look for what separates your e-mail addresses.
Hope this helps.
Re: Dynamic Chart Height
If there are a couple of tables in the dashboard and they have quite a lot of rows and you need to filter the data it becomes really complicated to navigate around the dashboard due to a lot of whitespaces.
How can I remove items from a mega table using a beast mode?
I have a table with 5 columns: The first column (A) lists parts, the second (B) lists countries, the 3rd (C) is a concatenation of the first 2 columns, and the 4th (D) is a concatenation of the same list of parts but other related countries. There are many more countries in column D than in column C, so most of the values in column C are duplicated multiple times. The values in column D do not duplicate. Column E indicates if there is a match between columns C & D.
How can I write a beast mode that will remove all the rows in the mega table for the matching country from column B? (In the picture, yellow highlights the matching row and the red indicates the rows that need to be deleted)
charles
Re: How can I remove items from a mega table using a beast mode?
how do you know which row you want to exclude?
Re: Publishing to subscriber instances problem
Mystery solved. After some trial an error I have worked out that you can only publish changes once in every 5 minute period.
This is absolutely fine for us but when you are testing a feature and the interface doesn't indicate this and the docs state the below it can all get rather confusing and frustrating haha.
Edit: This is working for adding and removing content but updating a chart title doesn't seem to work now at all.
Jones01
Re: Publishing to subscriber instances problem
Thanks for everyone's input. I'll keep you posted when and how I get this resolved.
Jones01