由Google表单条目(答案)删除的公式 [英] 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/1xoNPfWrWV7J7Q7W

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.

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