topic Re: formula not automatically evaluated until clicking apply button in Discussions

formula not automatically evaluated until clicking apply button

sos012523 — Thu, 08 Jun 2023 16:39:31 GMT

Hello. I made a script adding a column with a conditional formula , the output resulted to a null column only until you click apply in the column formula, I want to automatically output it , I asked colleague to try my data and script , it worked with them. what could be the problem with my jmp16.

new column("Remarks01",character,nominal,formula(If( :Remarsk00 == "Y",
    "1_a",
    "2_b"
)));

Re: formula not automatically evaluated until clicking apply button

Thierry_S — Wed, 01 Feb 2023 12:54:07 GMT

Hi,

The automatic formula evaluation might be suppressed in your data table preferences (top left red triangle menu)

Let us know if this does the trick.

Best,

Re: formula not automatically evaluated until clicking apply button

sos012523 — Tue, 07 Feb 2023 07:57:38 GMT

Hi @Thierry_S
thanks for the feedback! seems like it was the problem.

but can you tell when does suppressing usually happens and how to get rid of it?