create records in a new table based on a report once a button is clicked
I have a report in table "A" with a date filter. Upon clicking a button, I want to create in table "B" as many records as the report has. Any suggestions?
Forum Discussion
If the Filters on the report are standard, then the low tech way is to create a saved table to table import.
Then create a URL formula button to run the import and refresh the report. The button can be located on the records that you want to copy and it does not matter which button you click (ie all records will have the same button)
The URL formula would be like
var text URL = urlroot() & "db/" & [_DBID_TABLE_B] & "?act=API_RunImport&ID=10";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
That should run the import to create the records and refresh table A report.
Then create a URL formula button to run the import and refresh the report. The button can be located on the records that you want to copy and it does not matter which button you click (ie all records will have the same button)
The URL formula would be like
var text URL = urlroot() & "db/" & [_DBID_TABLE_B] & "?act=API_RunImport&ID=10";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
That should run the import to create the records and refresh table A report.