Import formula error or bug

#1

I’ve created following schema manually, and after that exported it well to .schema.json file.

Now, when I try to Update from file… and upload back generated json, formula field becomes blank.

Generated .schema.json:

{ "id": 45166, "num_rows": 10, "file_format": "csv", "name": "test_formula_bug", "include_header": true, "columns": [ { "name": "number", "type": "Formula", "value": "random(1, 10)", "formula": "" }, { "name": "first_name", "type": "First Name", "formula": "" } ] }

#2

The formula property is actually the inline formula that you can add to any field (the f(x) button). For fields of type formula, the actual expression is stored in the value property.

#3

I understand it well. :blush: thx. But try to Update from file…, the problem is that it will not import formula’s value field properly. Just try, please.