topic Re: Filling rows based by iterating on different column entity in Discussions

Filling rows based by iterating on different column entity

NewToThis — Tue, 01 Jul 2025 00:52:29 GMT

I want to assign a value to each row within a category defined in another column using JSL. For example, Module is the Category column and I want to assign this to All rows in within that category in the New column.

the new column should be like this

Re: Filling rows based by iterating on different column entity

txnelson — Tue, 01 Jul 2025 02:22:02 GMT

If( :Module != "",
	value = :Module
);
value;

Re: Filling rows based by iterating on different column entity

jthi — Tue, 01 Jul 2025 05:33:57 GMT

Or if you can modify Module column you can fill it

Re: Filling rows based by iterating on different column entity

NewToThis — Tue, 01 Jul 2025 16:19:48 GMT

Unfortunately, in my case there are thousands of Modules in the module column, so doing it manually is not an option. I believe I will have to use for & if loop to fill the New Column with Module value

Re: Filling rows based by iterating on different column entity

txnelson — Tue, 01 Jul 2025 17:41:24 GMT

Is there an issue with the column formula that I provided. It will work with thousands of Modules?

Re: Filling rows based by iterating on different column entity

mmarchandFSLR — Tue, 01 Jul 2025 19:28:56 GMT

Looks like your formula works perfectly, Jim.

Re: Filling rows based by iterating on different column entity

jthi — Tue, 01 Jul 2025 19:29:09 GMT

It is few button presses to fill them in by replacing with previous value. It isn't automated and if you don't need it automated, it should work fine. Other excellent options if the formula Jim has provided you with.