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
This looks to be exactly what I need, but for some reason I can't get it to work... I created the Import and tested it. It works fine. I created the Formula URL button and placed it in the in the table I need to import from. Copied and pasted the formula from above and changed the table Id to the actual table name. Made sure that the report ID is 10, just like you predicted it... Not sure what else to look for...
Here is the formula:
var text URL = URLRoot() & "db/" & [_DBID_Field_S] & "?act=API_RunImport&ID=10";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);
Here is the formula:
var text URL = URLRoot() & "db/" & [_DBID_Field_S] & "?act=API_RunImport&ID=10";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);