被谷歌表单条目删除的公式(答案) [英] The formula deleted by Google Form entries (answers)

问题描述

一旦我收到客户提交的新答案，公式就会被删除！

The Formula gets deleted once I get new answers submitted by customers!

这是测试商店:https://test-stoore21.myshopify.com/products/1st-product-title ，将此产品添加到购物车并在送货信息表格中输入任何随机数据，然后点击确认，然后查看此表格:

Here is the test store: https://test-stoore21.myshopify.com/products/1st-product-title , add this product to cart and enter any random data to Shipping information form and click confirm, then check this Sheet:

https://docs.google.com/spreadsheets/d/1xoNPfIfrVv7jF8W3Pa67Iu9oJRz2NOncW7oLQ94mWQ4"

https://docs.google.com/spreadsheets/d/1xoNPfIfrVv7jF8W3Pa67Iu9oJRz2NOncW7oLQ94mWQ4

如您所见，F 的 CELL 中的公式在数据进入后被删除.

As you can see the Formula in the CELL of F Column gets deleted once data comes in.

有什么脚本或技巧可以避免在数据传入时删除公式?

Any script or trick to avoid deleting the Formula when the data comes in?

预先感谢您的帮助！

推荐答案

将公式更改为:

=IFNA(INDEX(TRIM(ARRAYFORMULA(SUBSTITUTE(SPLIT(REGEXEXTRACT($E2:$E, $F$1&"(.+)"), "]"), "[", )))), 0)

将其放在单元格 F2 中并删除其下的所有内容.

Place it in cell F2 and delete everything under it.

是ARRAY_CONSTRAIN给你带来麻烦.

这篇关于被谷歌表单条目删除的公式(答案)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！