Got it @unserrer - thanks for the video that was very helpful! So I believe in this case the issue is the 'Blank' template, which is not properly connecting to your table/records.
Remember that a trigger for an automation has to be triggered from a specific record, but in List View with all records present, Airtable won't know which record triggered it. See the problem?
A couple thoughts:
Could you try creating a Record Review style layout and then add your button and list as elements? (screenshots).
If that works, great. If not, can you tell me a little more about what your automation is intended to do, and what data it needs to trigger? There might be better ways of setting up the trigger for the automation.
hey @unserrer alright I've got something for you. May not be a perfect solution, but will get the job done. As I understand it you've got the export to CSV automation working fine, it's just about having the correct trigger to launch it. Recorded a Loom Video to take you through step by step. Here's my example:
*** Remember to change all my Table / Field / Variables to match yours ***
Base Setup:
Automation Trigger Setup:
Automation Script (to get data of ALL records with export box checked)
var dataTable = base.getTable("Form Data")
var dataQuery = await dataTable.selectRecordsAsync({fields: ["Field A", "Field B", "To Export"]})
var dataRecords = dataQuery.records;
console.log(dataRecords)
var exportDataType = dataRecords[0].getCellValue("To Export")
// console.log(exportDataType)
var exportedData = [];
for (var i = 0; i < dataRecords.length; i++) {
if (dataRecords[i].getCellValue("To Export") == true ) {
exportedData.push({
"Field A": dataRecords[i].getCellValue("Field A"),
"Field B": dataRecords[i].getCellValue("Field B")
})
}
}
console.log(exportedData)
Automation Output:
