I have an Activities table linked to a Work Order billing table. The Work Order Billing table has a lookup to an Inventory table. I am trying to create a button with a formula URL that will create an entry in the Work Order Billing table from the Activities table with two data points. The first is a numeric value from a field in the Activities table (the table with the button). The second point is a text entry in the Work Order Billing table to a field that has a lookup to an Inventory table. I just want to type the value that will match.
Below is what I have so far. All it does is direct me to another page that states that nothing is there and cannot understand the URL.
URLRoot() & " db/" &[_DBID_WORK_ORDER_BILLING]
& "?act=API_AddRecord&_fid_65=" & URLEncode([Record ID#])
& "&_fid_42=" & URLEncode("Data Upload")
& "&_fid_10=" & URLEncode([GB])
& "& apptoken=abcdefghijklmnop"
& URLEncode(URLRoot() & "db/" & Dbid()
& "?a=dr&rid=" & [Record ID#])
Thank you in advance for your assistance.