Discussions

Expand all | Collapse all

Use URL function to do two different things

  • 1.  Use URL function to do two different things

    Posted 07-21-2017 04:11
    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#]))


  • 2.  RE: Use URL function to do two different things

    Top
    Contributor
    Posted 07-21-2017 04:32
    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?


  • 3.  RE: Use URL function to do two different things

    Posted 07-21-2017 18:30
    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)


  • 4.  RE: Use URL function to do two different things

    Posted 07-21-2017 18:47
    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#]))&"');


  • 5.  RE: Use URL function to do two different things

    Posted 07-21-2017 19:03
    I tried and it didn't work


  • 6.  RE: Use URL function to do two different things

    Posted 07-24-2017 19:11
    Can you please share a screen shot of the error message ? 


  • 7.  RE: Use URL function to do two different things

    Posted 07-24-2017 19:18
    There's no error message. When I press the button on the form there is no action.