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,...
Forum Discussion
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)
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)