User Profile

JeffLove

Qrew Trainee

Joined 6 years ago

12 Posts1 Like

Jeff has been helping companies large and small improve their business processes for 30 years. Initally, with Accenture then Cambridge Technology Partners and now with Emendo Solutions (a QSP in Australia) as a co-founder and Quick Base Expert Builder.

View All Badges

User Widgets

Contributions

Re: Can't print/save report as .pdf
Mike, We also started getting intermittent issues with Print failing in fairly long prints. I have a case with Level 3 support at the moment they are looking into it supposedly. I will pass the fact that I am not alone on to them. If you start a case, and I suggest you do, ask to piggy back ontop of #724177 ------------------------------ Thanks, Jeff ------------------------------
2 years ago Place Quickbase Discussions
74Views
0likes
1Comment
Re: Find if text field contains \n or Line Break
Another trick to identify and change or replace text fields is to use the URLEncode() on the field first, this displays lots of funky things that you can Find/Replace with <space> etc. ------------------------------ Thanks, Jeff ------------------------------
3 years ago Place Quickbase Discussions
40Views
0likes
1Comment
Re: stripping hidden characters from text strings to enable field equality
I did find a solution to this eventually, in case others have a similar problem. It turns out using the urlencode() function at the start converts all the strange characters, and there are a bunch of them into things like %0D%0A %0A %3A So you can basically trim out the garbage by SearchandReplacing all the different weird characters and replacing them with a space "%20" Upper(Trim(SearchAndReplace(SearchAndReplace(SearchAndReplace(SearchAndReplace(URLEncode([My TEXT Field]), "%0D%0A", "%20"), "%0A", "%20"), "%20", " "), "%3A", ":"))) Then the text comparison is equivalent. ------------------------------ Thanks, Jeff ------------------------------
3 years ago Place Quickbase Discussions
81Views
0likes
0Comments
Polar chart integration
Has anyone successfully used code pages or other techniques to use native QB data to display a Polar Chart in a dashboard? A polar chart has basically the same data as a Bar Chart, just displayed radially in a circle. ------------------------------ Thanks, Jeff ------------------------------
3 years ago Place Quickbase Discussions
0Views
0likes
0Comments
Re: stripping hidden characters from text strings to enable field equality
Ooops on my formula var text A = SearchAndReplace([Live Field A],"\n"," "); var text B = SearchAndReplace($A,"<br>"," "); Trim(Upper($B)) ------------------------------ Thanks, Jeff ------------------------------
3 years ago Place Quickbase Discussions
106Views
1like
1Comment
stripping hidden characters from text strings to enable field equality
I am using a staging table to compare a .CSV import to a bunch of live data. I have maybe 50 fields to compare and I am trying to check a few thousand records regularly and just flag the fields that have changed. This is typically pretty straightforward as they are text fields and using a List function and a bunch of if statements, I can easily display the field names when Live Field A <> Import Field A. My issue is lots of text fields are appearing as not equal, though they look the same when displaying them. I have used the tricks I know to tidy up hidden characters... var text A = SearchAndReplace([Live Field A],"\n"," "); var text C = SearchAndReplace($B,"<br>"," "); Trim(Upper($B)) This removes next line and carriage returns and makes all uppercase and trims extra spaces. I apply this to both fields, they have the same length of characters, look identical, even copy/pasting them to Notepad++ and turning on hidden characters they look the same but according to QB they are not equal. I have one more question path of enquiry... I have tried swapping between Text and Rich Text. The <br> I think works in Rich Text but \r in text gets converted when I save to something else, perhaps that is the issue? Any text gurus out there? Ideas or assistance would be appreciated... Kind Regards, Jeff Love
3 years ago Place Quickbase Discussions
Formulas and functions
104Views
0likes
2Comments
Anyone having success with an online html email builder for notifications?
We are trying to use an online html email builder in our case (unlayer.com) which makes our notification emails look professional, format OK for mobile and desktop easily insert images etc. However some notifications fail to send. After opening a case with QB they tell us ... I can see the outbound email, but there's a rejection from the email server, so it's bouncing back. The reason given is "550 Maximum line length exceeded" (see RFC 5322 2.1.1). There's a few Google searches around that. It's a bit technical, but seems to be relates to maximum string lengths not exceeding more than 1000 characters. Essentially like a long string from what I'm gathering (not the content of the entire message). It may be something in that HTML then that is causing this long string in the message formatting, but it only seems as though it may be happening in certain instances since, as noted, the original test record went to the other user. My question is twofold, First, who is having success using an html email builder that makes it easy to make professional emails that is not having the issues we are having? Maybe we just picked the wrong solution... Second, does anyone have ninja html skills and know a tool that will identify the line length/string length and is there a way to truncate or get around that issue in the raw html? ------------------------------ Thanks, Jeff ------------------------------
4 years ago Place Quickbase Discussions
9Views
0likes
1Comment
Re: SMS/Text Message Solution for outbound, inbound and MMS that work for international numbers
Thanks Austin for your insights, I have also done some additional follow up and have learned that... 1. For +1 numbers (US + Canada) Juiced is a good solution outbound, inbound and MMS...it will also do outbound, inbound texts overseas, just not MMS overseas. 2. Twilio with Pipelines is similar in that they do not support MMS overseas and have no timeline to support MMS outside of +1. 3. There are a few small players, we are in Australia, that have outbound, inbound and MMS, one MessageMedia connects with Zapier so that makes it straight forward to get outbound and inbound working, it has an online dashboard where the MMS are visible, though it doesn't look like MMS is supported in the Zap structure...I am waiting to hear back from their technical people. ------------------------------ Thanks, Jeff ------------------------------
4 years ago Place Quickbase Discussions
3Views
0likes
0Comments
SMS/Text Message Solution for outbound, inbound and MMS that work for international numbers
We want to use triggers to send text messages outbound, receive replies with keywords to kick off other steps and also be able to receive images MMS. The operation is overseas so the numbers are international, though they are within the one country. We have investigated Juiced MyText and that fails for cDyne for international numbers MMS does not work. Does anyone know if the Twilio and Pipeline solutions for example extend to receiving replies and MMS replies for international numbers? Send SMS Text Messages with Pipelines and Twilio ------------------------------ Thanks, Jeff ------------------------------
4 years ago Place Quickbase Discussions
Pipelines
Wizards and add-ons
8Views
0likes
2Comments
How to combine images stacked together in a LIST into 1 image
I have an app that pulls a LIST of .jpg images in slices into a field so I can build a preview of an image via L to R slices of parts of the images. I am using it works fine in QB forms, but I am using this preview as an "image" in Juiced / Exact Forms + as a preview and only the first slice comes through. I need to somehow concatenate or stitch together the slices from the LIST into a single image, Any ideas? ------------------------------ Thanks, Jeff ------------------------------
5 years ago Place Quickbase Discussions
Formulas and functions
Integration
10Views
0likes
2Comments