Use URL function to do two different things

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I'm trying to create a URL formula to open Skype with a command as well as edit a multi line Text field and then save the record...


//Formula 1

"skype:" & Mid([Phone 1],2,3) & Mid([Phone 1],7,3) & Mid([Phone 1],11,4)




//Formula 2

URLRoot() & "db/" & Dbid() & "?act=API_EditRecord"
& "&rid=" & URLEncode([Record ID#])
& "&_fid_104=Called Client on home phone"
& "&apptoken=XXX"    
& "&rdr=" &
URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid="
& URLEncode([Record ID#]))
Photo of Signature

Signature

  • 238 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
You will want to run your formula 2 first, then have a redirect run your second url.

What aspect of your question do you need help with, or does that help you get started?
Photo of Signature

Signature

  • 238 Points 100 badge 2x thumb
Can you help me with this formula? Would it look like this?

URLRoot() & "db/" & Dbid() & "?act=API_EditRecord"
& "&rid=" & URLEncode([Record ID#])
& "&_fid_104=Called Client on home phone"
& "&apptoken=XXX"    
& "&rdr=" &
URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid="
& URLEncode([Record ID#]))
& "skype:" & Mid([Phone 1],2,3) & Mid([Phone 1],7,3) & Mid([Phone 1],11,4)
Photo of Ammar

Ammar

  • 312 Points 250 badge 2x thumb
Please try this:

"javascript: "
&"window.open('skype:' "& Mid([Phone 1],2,3) & Mid([Phone 1],7,3) & Mid([Phone 1],11,4)&");"
&"location.assign('"&URLRoot() & "db/" & Dbid() & "?act=API_EditRecord"
& "&rid=" & URLEncode([Record ID#])
& "&_fid_104=Called Client on home phone"
& "&apptoken=XXX"    
& "&rdr=" &
URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid="
& URLEncode([Record ID#]))&"');"
Photo of Signature

Signature

  • 238 Points 100 badge 2x thumb
I tried and it didn't work
Photo of Ammar

Ammar

  • 312 Points 250 badge 2x thumb
Can you please share a screen shot of the error message ? 
Photo of Signature

Signature

  • 238 Points 100 badge 2x thumb
There's no error message. When I press the button on the form there is no action.