Lengkap

Gravity Forms - Code an automation: Send mapped entries daily in Excel to specific e-mail

Current situation:

We use Gravity Forms + "Gravity Forms Entries in Excel" Plugin

The plugin generates an excel file and a link to download the excel file.

We download every day the new leads and have to map it into a new order.

Current Workflow:

1. Download Excel – See [login to view URL]

2. Delete all old leads

3. Map everything into special format – [login to view URL]

4. Copy special columns in new rows + add some Columns (RecordTypeId, AffiliateID_c) – [login to view URL]

5. Send the result Excel file to a special e-mail address

What we want from you:

Create an automated workflow to send the new(!) collected leads from gravity forms entries every morning to the mail address with the attachment of the data results.

What we think will work:

Create an CronJob file which will be called from our server every morning.

The file/Cronjob downloads the Excel file from the link, manipulates it to the final result sheet and sends it to the mail address.

Maybe you create a small wordpress plugin where we can edit our wished fields (see below).

These changes might also be made in the cronjob files header directly, so that no plugin is needed.

But please feel free to come up with your solution.

What must be configurable?

- Documentation if other fields come in addition to it

- Excel Download link must be customizable – Maybe unnecessary if you download the gravity form entries directly

- E-Mail Address to send to and BCC + CC mail addresses

- Field RecordTypeId (J) must be editable

- Field AffiliateID_c (I) must be editable

Kemahiran: Excel, Javascript, PHP, Kejuruteraan Perisian, Wordpress

Lihat lagi: code webpage send email, cms forms code, send 50000 emails daily, gravity forms automation, gravity forms export plugin, gravity forms import entries, gravity forms schedule entries export, gravity forms add ons, gravity forms entry automation, gravity forms entry management, gravity forms daily report, javascript supply order forms code, want send million emails daily, code makes send friend request myspace, breezing forms code, source code j2me send file, code j2me send sms, code perl send, twitter code automation, best code vb6 send files

Tentang Majikan:
( 6 ulasan ) Braunschweig, Germany

ID Projek: #18692043

Dianugerahkan kepada:

eurocodersl

Hi, I think it can be done this way: create Gravity Forms (GF) addon plugin, which will get latest day entries from database directly (wtihout intermediate excel file) using GF API calls. Then, plugin will append and c Lagi

€250 EUR dalam 5 hari
(158 Ulasan)
7.2

16 pekerja bebas membida secara purata €177 untuk pekerjaan ini

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Lagi

€250 EUR dalam 4 hari
(342 Ulasan)
7.9
liveexperts123

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Lagi

€155 EUR dalam 3 hari
(52 Ulasan)
6.9
mrbrave

HI, Using Google sheets and scripts, this can can done on cloud. I will set a trigger on google sheet, which will auto trigger every day at specific time. It will download the file from link to Google [login to view URL] Lagi

€125 EUR dalam 3 hari
(249 Ulasan)
6.7
arcliteq

Hi. Let's discuss bullet points below: 1. Download Excel – See [login to view URL] 2. Delete all old leads 3. Map everything into special format – [login to view URL] 4. Copy special columns in new row Lagi

€150 EUR dalam 3 hari
(22 Ulasan)
6.0
Apisylux

Hi Sir, I see you need some scripts in the Wordpress and Excel to automate your daily Tasks. I have expertise in Excel and Google Sheets. I was trying to understand the data flow and also saw the attachments. But co Lagi

€250 EUR dalam 5 hari
(9 Ulasan)
4.7
supriyasaini890

Hello There, Greetings of the days..!! I hope You Doing well. I Read carefully and Analyzed Your Provide Project Description. My Skills - CSS,HTML, BootStrap , PHP, CakePhp , CodeIgniter, Laravel, Resposive, MySQL Lagi

€122 EUR dalam 3 hari
(20 Ulasan)
4.1
vitroinfotech

Dear Project Manager, Thanks for the feature Job. We have gone through your requirements and we are highly interested in this project!. We can provide a very best solution so you can earn business from the site Lagi

€166 EUR dalam 3 hari
(13 Ulasan)
3.9
ravinderkamboz

Hi, i am Wordpress plugin developer. I have 4.9 years of experience. I have completed approximately 28 plugins with complex functionalities. I have read your requirements and will do this task perfectly and within time Lagi

€166 EUR dalam 5 hari
(6 Ulasan)
3.8
shenji108

Hello Sir. How are you? I have 8+ years experience. I am wordpress expert and have rich experiences in developing wordpress. I send you my urls developed with wordpress before. [login to view URL] h Lagi

€155 EUR dalam 2 hari
(6 Ulasan)
3.4
Anasolution

--- Well Experienced & Qualified for This Job (Similar Work Done) --- Hi there, Hope you are doing well! I have thoroughly reviewed the job requirements and I would like to take an opportunity to work on i Lagi

€155 EUR dalam 3 hari
(4 Ulasan)
1.5
leyli19982010

Hey I can help you with your project. I have 6 years of experience in Web and App Development I’ve true passion & skills on what I do for my clients with a unique & creative approach towards every project I undertak Lagi

€250 EUR dalam 3 hari
(0 Ulasan)
0.0
KhajaKingdom

better opportunity for the better life.i am a dedication and good mannered person. i am happy to say i am available in any time to work as possible as i.

€155 EUR dalam 3 hari
(0 Ulasan)
0.0
gabdorilag

This can be done via robotics process automation. I can design and develop a process automation robot to automate your excel download and update, then send email workflow. You won't need to hire someone to do the task Lagi

€222 EUR dalam 7 hari
(0 Ulasan)
0.0
leuel92696

Good day! I am interested to work with you, I am patient, fast-learner and work oriented person, I will do my best to provide quality of work and be precise, I hope to get back to you soon. I will reply ASAP

€155 EUR dalam 3 hari
(0 Ulasan)
0.0
neurohostbriones

We can develop an automated form, where you can add new fields, send individual results for each new contact, download all the data collected by the form, in a file in excel We can converse to enter more details and Lagi

€100 EUR dalam 5 hari
(0 Ulasan)
0.0