Question Re: Is there a way to get the values of cells via scripting? in Enterprise Resource Planning Q&A

Is there a way to get the values of cells via scripting?

PatriciaR55 — Tue, 04 Feb 2025 15:05:02 GMT

The user would like to be able to show a message on the following conditions (only if value and quantity is not filled):

price is 0,
price is blank,
price is negative or becomes +/-50% more than historical price.

We tried using getSelections() but only dimensions are available.

Is it possible to get measure values via scripting to enable a check as mentioned above?

Re: Is there a way to get the values of cells via scripting?

david303010 — Wed, 05 Feb 2025 07:46:58 GMT

Hello,

did you tryed to use getResultSet({yourselection})

regards

Re: Is there a way to get the values of cells via scripting?

PatriciaR55 — Thu, 06 Feb 2025 05:56:39 GMT

Hi David, thanks I tried this and was able to see the measure values.

However, I am using a forecast layout with actuals and forecast version and realized I only get the actuals version even if I select on the cells for forecast version. Is this expected?

Re: Is there a way to get the values of cells via scripting?

david303010 — Thu, 13 Feb 2025 05:40:06 GMT

Could you give a printscreen of the table you are using for that ?