Discussions

Expand all | Collapse all

This XML file does not appear to have any style information associated with it. The document tree is shown below.

  • 1.  This XML file does not appear to have any style information associated with it. The document tree is shown below.

    Posted 04-06-2015 05:25

    Below is my URL formula ...


    URLRoot()& "db/" &Dbid()& "?a=API_CopyMasterDetail" &

    "&relfids=38" &

    "&sourceRID=159" &

    "&destrid="& [Record ID#];


    Records copy, but when I click the button for copying the detail records I receive the XML File with the following data:


    <qdbapi> <action>API_CopyMasterDetail</action> <errcode>0</errcode> <errtext>No error</errtext> <parentrid>3</parentrid> <numCreated>3</numCreated> </qdbapi>
    Any help is appreciated!


  • 2.  RE: This XML file does not appear to have any style information associated with it. The document tree is shown below.

    Posted 04-06-2015 10:54
    Anytime you do a URL formula which edits or adds a record, you need to the redirect to display a record or a report as the next action, or else the API not so subtly reports its success or failure back to you.

    If you want to next reDisplay the Original Record, and for some reason you want to use the aPI method, it would be like

    var text URLONE = the code you had above ending in semicolon;

    var text URLTWO =

    URLRoot()& "db/" &Dbid()& "?a=API_EditRecord" &

    "&rid=" & [Record ID#]&

    "&_fid_42=1";



    var text URLTHREE = urlroot() & "db/" & dbid() & "?a=dr&rid=" & totext([Record ID#]);

    $URLONE
    & "&rdr=" & urlencode($URLTWO)
    & URLENCODE ("&rdr=" & urlencode( $URLTHREE))


  • 3.  RE: This XML file does not appear to have any style information associated with it. The document tree is shown below.

    Posted 04-06-2015 11:04
    I edited my answer above to take into account your full question including your other post.


  • 4.  RE: This XML file does not appear to have any style information associated with it. The document tree is shown below.

    Posted 04-06-2015 12:55
    Perfect .... thanks for your help Mark - much appreciated as usual.  Any idea where I can get some more specific directions regarding how to compile URL formulas? The API Documentation is good, but it doesn't do a very good job of explaining the nuances for the newbies like me.


  • 5.  RE: This XML file does not appear to have any style information associated with it. The document tree is shown below.

    Posted 04-06-2015 13:02
    There is an app I put in the Exchange called URL Formuals for Dummies.  The cover page has a bit of tutorial on how to nest the URLs for successive actions.  Have a read of that, and then you can post back with any questions or just contact me via my Profile info.


  • 6.  RE: This XML file does not appear to have any style information associated with it. The document tree is shown below.

    Posted 04-06-2015 13:09
    Mark - now I want to add a statement to check if the checkbox is false, and if it is, execute the URL fomula above, otherwise, respond with a message that the detail records have already been copied, and return to the form and do nothing. Possible?


  • 7.  RE: This XML file does not appear to have any style information associated with it. The document tree is shown below.

    Posted 04-06-2015 13:20
    We are starting to get out of my comfort zone but this might work

    var text URLnull="xx";

    if([checkbox field]=true,

    "javascript:" &
    "$.get('" &
    $url &
    "',function(){" &
    "$.jGrowl('Warning! You have already Imported Standard detail records.', {life: 5000});" &
    "});" &
    "void(0);",

    $URLONE
    & "&rdr=" & urlencode($URLTWO)
    & URLENCODE ("&rdr=" & urlencode( $URLTHREE)) )

    But another way to go is simply this

    if([checkbox field]=false,
    $URLONE
    & "&rdr=" & urlencode($URLTWO)
    & URLENCODE ("&rdr=" & urlencode( $URLTHREE)) )

    if you do that and the checkbox is true (ie already imported) , then the formula is null and the button will be blank with nothing to click on.


  • 8.  RE: This XML file does not appear to have any style information associated with it. The document tree is shown below.

    Posted 05-13-2016 15:55
    Could I instead redirect to the new record somehow?


  • 9.  RE: This XML file does not appear to have any style information associated with it. The document tree is shown below.

    Posted 08-18-2017 14:22
    You can use these XML tools to work with XML

    1. XML Viewer
    2. XML Formatter