Đã hoàn thành

Troubleshoot Google Sheet Data Entry Recognition following Integration with Elementor Forms

We have integrated an elementor form with extensive conditional logic to output the data to a google sheets file, which works. The conditional nature of the form means there are many empty fields following data input (Screenshot 1 below - 'Masters_enquiries' tab). We have set up the formulas to auto-populate Time+Date following data entry, and to auto-populate sheet2 ('Copy of Filtered_data), which works when manually entering into fields in Masters_enquiries (see rows 2 and 3).

However, when submitting the online form, the Masters_enquiries populates (see rows 3 and 4), but the Time+Date formula is missing (perhaps automatically overwritten), and the Copy of Filtered_data sheet doesn't autofill. Please also note that the formulas in Sheet2 automatically change to the row of cells below it (see the highlighted formula in the second screenshot). We have set 'recalculation' to 'On change', and 'On change and every minute', without success. We have also installed Integromat, hooked the URL and ran the 'Watch Changes' job, again without success.

Something about the data import is messing up the set-up, but we don't know how to fix it. Please help!

Kĩ năng: Google Sheets, Backend Development, Nhập liệu, Phát triển cơ sở dữ liệu, Lập trình cơ sở dữ liệu

Xem nhiều hơn: elementor lead generation, elementor thank you page, elementor form actions after submit, elementor google sheets, elementor pro, elementor multi step form, how to create google sheet, zapier, google spreadsheet data entry, delivery sheet data entry program, google captcha data entry, google provide data entry, google inc data entry, job google inc data entry, google docs data entry form, google adsense data entry, google adsense data entry project, excell sheet data entry save, google advertise data entry, google docs data entry

Về Bên Thuê:
( 1 Nhận xét ) Walsall, United Kingdom

ID dự án: #26130921

Được trao cho:

utkarsh7238

Hey, I can Fix your Problem In how much time you want it to be completed???? Let's talk upon your project Waiting for your response!!!

£10 GBP trong 1 ngày
(9 Đánh Giá)
3.9

5 freelancer chào giá trung bình£16 cho công việc này

leoperusin

Hi! I am an Information System Enginner with 14 years of experience. I'm a Excel/VBA expert and I have done many projects related to Excel Macros and automations. Also I have done some projects with Google Sheets and A Thêm

£20 GBP trong 2 ngày
(3 Nhận xét)
2.6
gourav7747

I have good skills about the work

£19 GBP trong 2 ngày
(0 Nhận xét)
0.0
sayanbag37

Excellence in data entry and Google sheets knowledge.

£14 GBP trong 1 ngày
(0 Nhận xét)
0.0
bharatbhateja16

Education - Graduate [login to view URL] Business - Have 5 year experience of BPO and basic knowledge of Data analysis. I can do this job with minimum fee

£15 GBP trong 7 ngày
(0 Nhận xét)
0.0