Skip to main content
Question

Use URL function to do two different things

  • July 21, 2017
  • 0 replies
  • 34 views
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#]))
    This topic has been closed for replies.

    • MCFNeil
    • Registered
    • July 21, 2017
    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#]))&"');
    I tried and it didn't work
    Terms & ConditionsAccessibility statement