Discussions

Expand all | Collapse all

Button to run import then open report

  • 1.  Button to run import then open report

    Posted 02-14-2019 11:43
    Hi
    I have created and saved an import to import records into a table a from table b.
    The import itself works fine when I run it from the import screen.

    I've created a URL formula button that uses API_RUNIMPORT to run the import:

    "https://<domain>/db/<dbid>...;"

    The button runs the import but then gives the response values in an xml view.
    What I'd like to happen is: 
    If the response contains an error, show the error - ideally in a popup dialog - and then open a specific report automatically
    If the import completes successfully I want to skip the api response message (though that's not crucial, if it can show the "x records created successfully" message in a popup) - and then open the same specific report.

    Any ideas if/how I can achieve this gratefully received.




  • 2.  RE: Button to run import then open report

    Posted 02-14-2019 12:25
    Here is a partial solution.

    Make a URL formula button to run the import and then to display a report of record created by the current user today. Or created by the current user in the last 5 minutes. That way they will see what they imported.

    Set up your two formula variables to do the import and then run the report and then call then sequentially like this.

    $URLONE
    & "&rdr=" & URLEncode($URLTWO)