Button to run import then open report
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.
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.
