Forum Discussion

SignatureSignat's avatar
SignatureSignat
Qrew Trainee
7 years ago

Use URL function to do two different things

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#]))

6 Replies

  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    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?
  • 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)
  • 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#]))&"');
    • SignatureSignat's avatar
      SignatureSignat
      Qrew Trainee
      There's no error message. When I press the button on the form there is no action.