Trying to build a URL using info from an app item

Follow

Scott Anderson CCIM

• January 31, 2017 21:22

I am trying to use a calculation field to auto-generate a unique URL address in an app. Then I could click it to quick-search an online database.

The search URL is:
"http://ecorp.azcc.gov/Search/SearchBar?term=[FIELD]

Then I want to use info from an existing field in the app to fill in the [FIELD] text above. The text I want to use though inevitably has spaces between the words and the resulting URL calculation has spaces in it. When this URL is clicked, it opens a new browser and only searches the first word and drops the rest of the words as soon as the URL is broken by a space. See images below.

The website I am searching seems to want a "+" between the words. How do I add in "+" between the words?

- Thank you in advance to those folks who take their time to share their knowledge!! I couldn't make Podio work without your help!

Image 1

Image 2

 

 

 

0

• 

  Rainer Grabowski

  • February 03, 2017 08:24

  Hi Scott,

  you can encode the url:

  encodeURI("http://ecorp.azcc.gov/Search/SearchBar?term=" + @FIELD)

  (attention please: it's encodeURI, not encodeURL).
  or:

  ("http://ecorp.azcc.gov/Search/SearchBar?term=" + @FIELD).replace(/ /g,"+")

  Rainer

  0

  Comment actions Permalink
• 

  Scott Anderson CCIM

  • February 03, 2017 21:17

  Thanks Rainer!  The second one seemed to work.  The first one the Podio Calc field didn't seem to like.  

  One follow up question.  Is there a way to have the link appear as "Research Now" versus an ugly URL?  Thank you again Rainer.  You are indispensable!  

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • February 04, 2017 10:51

  Hi Scott,

   "The first one the Podio Calc field didn't seem to like."  - That's strange. Which error notification is shown?

  This way you get a "nice" link:

  var url = ("http://ecorp.azcc.gov/Search/SearchBar?term=" + @FIELD).replace(/ /g,"+");
  "[Research Now](" + url + ")"

  Rainer

  0

  Comment actions Permalink
• 

  Scott Anderson CCIM

  • February 04, 2017 23:04

  The first URL calc you gave me is now working..  Come to think of it now, when I tried it a few days back Podio was having serious calculation delays that day.  Like I said - seems to be working fine now when I just tested it again.  

  Thanks too for the 'Nice URL' calc.  You are a real help Rainer!  Thanks so much.

  0

  Comment actions Permalink

Please sign in to leave a comment.