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!
Được trao cho:
5 freelancer chào giá trung bình£16 cho công việc này
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