Button to run import then open report

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
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:


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.

Photo of Jonathan Spencer

Jonathan Spencer

  • 150 Points 100 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
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.

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