Use URL function to do two different things

Question

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

mcfneil · Answer

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?

signaturesignat · Answer

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)

ammaral-hadeeth · Answer

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

signaturesignat · Answer

I tried and it didn't work

ammaral-hadeeth · Answer

Can you please share a screen shot of the error message ?&nbsp;

Forum Discussion

Use URL function to do two different things

Related Content

Add button to create record in different app

Using GetRecords to query a table in a different application?

Nz Function - Formula Help

Same reference field, different selections within the form

Forms differences