Auto generated report

[pranavb]

Hi,

I have a form out of which a list is being populated by a number of users. I would like to receive an auto generated weekly report of the list say at the end of week with some records filtered using an SQL condition. Is there a way to do this in Fabrik?

Thanks.

 

[troester]

You can use fabrik scheduled tasks (php or email).

 

[pranavb]

I tried this, but instead of sending a table, the scheduled task sent me this

updates 10 records email listid = 18 SELECT SQL_CALC_FOUND_ROWS DISTINCT `provin_call_table`.`call_no` AS `provin_call_table___call_no`, `provin_call_table`.`call_no` AS `provin_call_table___call_no_raw`, `provin_call_table`.`call_number` AS `provin_call_table___call_number`, `provin_call_table`.`call_number` AS `provin_call_table___call_number_raw`, `provin_call_table`.`machine_serial` AS `provin_call_table___machine_serial_raw`, `provin_machinetable`.`machine_serial` AS `provin_call_table___machine_serial`, `provin_call_table`.`cust_name` AS `provin_call_table___cust_name_raw`, `provin_machinetable_1`.`cust_name` AS `provin_call_table___cust_name`, `provin_call_table`.`machine_model` AS `provin_call_table___machine_model_raw`, `provin_machinetable_0`.`machine_model` AS `provin_call_table___machine_model`, `provin_call_table`.`date_open` AS `provin_call_table___date_open`, `provin_call_table`.`date_open` AS `provin_call_table___date_open_raw`, `provin_call_table`.`date_close` AS `provin_call_table___date_close`, `provin_call_table`.`date_close` AS `provin_call_table___date_close_raw`, `provin_call_table`.`status` AS `provin_call_table___status`, `provin_call_table`.`status` AS `provin_call_table___status_raw`, `provin_call_table`.`remarks` AS `provin_call_table___remarks`, `provin_call_table`.`remarks` AS `provin_call_table___remarks_raw`, `provin_call_table`.`call_owner` AS `provin_call_table___call_owner_raw`, `provin_users_2`.`name` AS `provin_call_table___call_owner`, `provin_call_table`.`engineer1` AS `provin_call_table___engineer1_raw`, `provin_users`.`name` AS `provin_call_table___engineer1`, `provin_call_table`.`engineer2` AS `provin_call_table___engineer2_raw`, `provin_users_0`.`name` AS `provin_call_table___engineer2`, `provin_call_table`.`engineer3` AS `provin_call_table___engineer3_raw`, `provin_users_1`.`name` AS `provin_call_table___engineer3`, `provin_call_table`.`city` AS `provin_call_table___city_raw`, `provin_machinetable_2`.`city` AS `provin_call_table___city`, `provin_call_table`.`region` AS `provin_call_table___region_raw`, `provin_machinetable_3`.`region` AS `provin_call_table___region`, `provin_call_table`.`call_no` AS slug , `provin_call_table`.`call_no` AS `__pk_val` FROM `provin_call_table` LEFT JOIN `provin_machinetable` AS `provin_machinetable` ON `provin_machinetable`.`machine_serial` = `provin_call_table`.`machine_serial` LEFT JOIN `provin_machinetable` AS `provin_machinetable_0` ON `provin_machinetable_0`.`machine_model` = `provin_call_table`.`machine_model` LEFT JOIN `provin_machinetable` AS `provin_machinetable_1` ON `provin_machinetable_1`.`cust_name` = `provin_call_table`.`cust_name` LEFT JOIN `provin_users` AS `provin_users` ON `provin_users`.`name` = `provin_call_table`.`engineer1` LEFT JOIN `provin_users` AS `provin_users_0` ON `provin_users_0`.`name` = `provin_call_table`.`engineer2` LEFT JOIN `provin_users` AS `provin_users_1` ON `provin_users_1`.`name` = `provin_call_table`.`engineer3` LEFT JOIN `provin_machinetable` AS `provin_machinetable_2` ON `provin_machinetable_2`.`city` = `provin_call_table`.`city` LEFT JOIN `provin_machinetable` AS `provin_machinetable_3` ON `provin_machinetable_3`.`region` = `provin_call_table`.`region` LEFT JOIN `provin_users` AS `provin_users_2` ON `provin_users_2`.`name` = `provin_call_table`.`call_owner`

 

[troester]

This seems to be the log (did you use the log/email to?).

If you don't want to get an email per row you have to compose the message yourself.
http://fabrikar.com/forums/index.php?wiki/common-php-tasks/

 

[pranavb]

Yes, I think I was using the log. Now its off, thanks.

Is there a way to send the table as a pdf? Or as an excel sheet?
If not, is there any php code which I could use to send a well formatted table in the email body?