# Formula(text) fields not exporting in saved searches from Netsuite

**URL:** <https://connective.celigo.com/t/formula-text-fields-not-exporting-in-saved-searches-from-netsuite/860>\
**Category:** Integrator.io\
**Tags:** export, netsuite\
**Created:** [January 18, 2022, 7:25pm UTC](https://connective.celigo.com/t/formula-text-fields-not-exporting-in-saved-searches-from-netsuite/860 "2022-01-18T19:25:08Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![rossorr](https://avatars.discourse-cdn.com/v4/letter/r/2bfe46/32.png) [@rossorr](https://connective.celigo.com/u/rossorr)\
**Post date:** [January 18, 2022, 7:25pm UTC](https://connective.celigo.com/t/formula-text-fields-not-exporting-in-saved-searches-from-netsuite/860/1 "2022-01-18T19:25:08Z")

</div>

When exporting a saved search from Netsuite, and columns that are "Formula(Text)" do not export.

They are completely missing from the result, is there a setting I am missing?

---

<div class="post-metadata">

**Author:** ![coryanderson215](https://avatars.discourse-cdn.com/v4/letter/c/c2a13f/32.png) [@coryanderson215](https://connective.celigo.com/u/coryanderson215)\
**Post date:** [January 18, 2022, 7:27pm UTC](https://connective.celigo.com/t/formula-text-fields-not-exporting-in-saved-searches-from-netsuite/860/2 "2022-01-18T19:27:41Z")

</div>

They should export with everything else, Ross. Maybe try putting in a Custom Label on those columns in the saved search results. Then you can easily tell which field to map when you bring the results in to .io.

~Cory

---

<div class="post-metadata">

**Author:** ![rossorr](https://avatars.discourse-cdn.com/v4/letter/r/2bfe46/32.png) [@rossorr](https://connective.celigo.com/u/rossorr)\
**Post date:** [January 18, 2022, 7:31pm UTC](https://connective.celigo.com/t/formula-text-fields-not-exporting-in-saved-searches-from-netsuite/860/3 "2022-01-18T19:31:40Z")

</div>

Yeah, they all have custom labels, they are predominantly blank (placeholder columns) needed to match a schema thats strict about columns and order.

 ![5301043caa20740200000001-4163514899a447d48c777dea3043a8cf.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/c/c0975c89fb7dd7769a9e9e2c9dfdd7f39b0987d7.png)

All of these columns above, should display between the 2 highlighted in the preview below, but they do not, there are other formula(text) fields in this as well, that are not coming over either

 ![5301043caa20740200000001-c1b4a52fb5ac4cd39dfa26833b61f9d6.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/6/6489adbd4319fd5858df06a684eca491abd3ca99.png)

---

<div class="post-metadata">

**Author:** ![rossorr](https://avatars.discourse-cdn.com/v4/letter/r/2bfe46/32.png) [@rossorr](https://connective.celigo.com/u/rossorr)\
**Post date:** [January 18, 2022, 7:53pm UTC](https://connective.celigo.com/t/formula-text-fields-not-exporting-in-saved-searches-from-netsuite/860/4 "2022-01-18T19:53:42Z")

</div>

So follow up, if the field is completely bkank (no formula or function specified), that is when the columns dont come down to integrator. If I add a "" to the formula field, it at least sends the column down with invalid expression error, and I can just replace the value with "" during the transformation with the snippet below, but its a bit of an irritating work around.

If theres a formula that will populate an empty string instead of null that would be better

```
Object.keys(options.record).forEach(k => options.record[k] = options.record[k].trim().replace('ERROR: Invalid Expression',' '));
```

---

<div class="post-metadata">

**Author:** ![coryanderson215](https://avatars.discourse-cdn.com/v4/letter/c/c2a13f/32.png) [@coryanderson215](https://connective.celigo.com/u/coryanderson215)\
**Post date:** [January 18, 2022, 7:56pm UTC](https://connective.celigo.com/t/formula-text-fields-not-exporting-in-saved-searches-from-netsuite/860/5 "2022-01-18T19:56:26Z")

</div>

Ross - try single quotes instead of double. Like this ''. Formulas in NS use singles.

---

<div class="post-metadata">

**Author:** ![rossorr](https://avatars.discourse-cdn.com/v4/letter/r/2bfe46/32.png) [@rossorr](https://connective.celigo.com/u/rossorr)\
**Post date:** [January 19, 2022, 2:20pm UTC](https://connective.celigo.com/t/formula-text-fields-not-exporting-in-saved-searches-from-netsuite/860/6 "2022-01-19T14:20:59Z")

</div>

Thanks Cory, Its always the simple things