Discussions

Expand all | Collapse all

Add new record in different application

  • 1.  Add new record in different application

    Posted 01-26-2018 09:50
    Hi all, 

    This has to be answered somewhere but I can't find it. Can someone advise on the URL code for adding a new record in a different application? I'm familliar with doing it within an application but can't get this to work. 

    Thanks in advance.
    Matt


  • 2.  RE: Add new record in different application

    Posted 01-26-2018 15:06
    Well, the format is identical but you cannot refer to the table name in [square brackets].  You just need to type the actual table name like

    urlroot() & "db/" & "xxxxxxx" & "?act=API_ AddRecord ......


  • 3.  RE: Add new record in different application

    Posted 01-26-2018 15:12
    Hi Matt,

    We do have an online help resource on API calls like Add Record that can be found here

    The API guide shows how those calls can be built and then you can put them into a formula like the one Mark posted. 


  • 4.  RE: Add new record in different application

    Posted 01-26-2018 18:08
    Thanks very much guys, I got it with Mark's formula. Mark - not the first time you've helped me out, really appreciate it.


  • 5.  RE: Add new record in different application

    Posted 01-26-2018 18:12
    np,
    just by the way, the reason that you can't use the [table name] is that there would be many Apps all with the same table names, like [_DBID_CUSTOMERS].

    _But the important reason to always use table names whenever you can (within an app) is that so when you copy an app, the buttons will be still referring to the correct app and not hard coded to your old app.