csv mail to admin

Hi Support
I would like to email a 3rd party company a csv email attachment of fields completed.
Any help will be greatly appreciated
Thanks,

Hello janman,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How do I send an email to an admin?
Attach PDF, XLS, CSV to email ? for both v4 & v5
P.S: I'm just an automated service😉

Hi Support
Got it working
i used the csv export to export all data from db table and then attached the file using custom code

<?php
$files = array(
  'userdata.csv'
);
$path ='mypath';
foreach ( $files as $k => $f ) {
  $form->files['files_to_send'][$k]['path'] = $path.$f;
}
?>

I then receive all the data captured in the csv as a mail attachment

What i would like to know, if it is possible to capture only the last row or the last record captured in the db table and then attach that csv in mail
Thank you.

Hi janman,

Yes, you can do that - but what practical use is it?*

You can use the Data Path option in the CSV Export action to select data from the current form - you can pick this up after the DB Save action has run.

Bob

* The neater way to do this may be to use the GSheet export action which will add the latest record to the end of the GSheet.