Discussions

Expand all | Collapse all

URL button not creating new record

  • 1.  URL button not creating new record

    Posted 08-28-2020 12:05
    Edited by Dante Tognoli 08-28-2020 12:15
    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
    ------------------------------


  • 2.  RE: URL button not creating new record

    Posted 08-28-2020 12:20
    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
    ------------------------------