#ERROR! replacing formula fields

[Marat Levit]

Hey,

Every time the script runs all my formula fields end up changing their values to #ERROR!. No matter what I select from the option on how to deal with the formula fields. I have even disabled the code that handles the replacement of the formula fields.

As far as I can see, the fields change values before the emails are even sent because those fields come through as #ERROR! in the emails.

Any ideas?

[Henrique Abreu]

Yes, your formula is probably wrong. If you copy and paste it manually does it work?

Are you using the formulas location advanced parameter, right?

https://sites.google.com/site/formemailer/advanced

Regards,

Henrique Abreu

--
You received this message because you are subscribed to the Google Groups "FormEmailer" group.
To unsubscribe from this group and stop receiving emails from it, send an email to formemailer...@googlegroups.com.
To post to this group, send email to forme...@googlegroups.com.
Visit this group at http://groups.google.com/group/formemailer.
For more options, visit https://groups.google.com/d/optout.

[Marat Levit]

They aren't formulas though. They are just drop down selection fields (e.g. Approved, Rejected, N/A)

[Henrique Abreu]

Hum... this a bug with the new sheets.

Data validation support for new sheets in Apps Script is still buggy. Please check this issues:

https://code.google.com/p/google-apps-script-issues/issues/detail?id=2818

https://code.google.com/p/google-apps-script-issues/issues/detail?id=3811

I'm not sure if a change in FormEmailer's code can fix, but I do not have time to analyse this now. We'll have to wait on Google to fix this.

For now you won't be able to use data validation with FormEmailer on the new Sheets. Either move to old sheets or remove the data validation.

Henrique Abreu

--

[Marat Levit]

Thanks for the links.

I seem to be getting that issue even if the fields are no longer data validated fields? Any ideas?

Thanks,

Marat Levit | Consultant | Servian Pty Ltd | m: 0422 894 894 | t: 03 9629 9090

--
You received this message because you are subscribed to a topic in the Google Groups "FormEmailer" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/formemailer/HaySHv2MaWw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to formemailer...@googlegroups.com.