Forum Discussion

DanteTognoli's avatar
DanteTognoli
Qrew Captain
5 years ago

URL button not creating new record

I am using the following URL button to create a new record in another app, but it only goes to the home page of the app where I want to create the record. I've tried using the table alias, but that does not appear to work across apps. What am I doing wrong?

//[hoist completed] is a checkbox
If([Hoist Completed?] = true,
// next line generates a new record in the database in quotes
URLRoot() & "db/" &"bqkivu2gd?a=nwr"& "?a=API_GenAddRecordForm"
//fid 7 = Date
&"&_fid_7=" & URLEncode([Date]))

------------------------------
Dante Tognoli
------------------------------
  • I figured it out. It was a syntax issue with the code above. It should read as:

    URLRoot() & "db/" &"bqkivu2gd"& "?a=API_GenAddRecordForm"


    ------------------------------
    Dante Tognoli
    ------------------------------