topic Re: Create a New on basis existing column in App Development

Create a New on basis existing column

suhascool1 — Wed, 28 Feb 2024 09:40:46 GMT

Hi,

Existing Closed Date column on basis of this column we need to create new column Status.

Date value is available then status column Value shows Yes

if Date value is blank then status column value shows Not.

Closed_Date

01-02-2024

13-01-2024

14-01-2024

Final Result :

Closed_Date	Status
01-02-2024	Yes
	Not
13-01-2024	Yes
14-01-2024	Yes
	Not
14-01-2024	Yes

Re: Create a New on basis existing column

ali_hijazi — Wed, 28 Feb 2024 09:49:18 GMT

if you want to accomplish this in the script, then you need to write something like this:
if( not trim(Closed_Date) = '' and not isnull(Closed_Date), 'Yes','Not') as Status

Re: Create a New on basis existing column

suhascool1 — Thu, 29 Feb 2024 17:12:10 GMT

thank u

Re: Create a New on basis existing column

Pallav — Fri, 01 Mar 2024 06:31:21 GMT

If(Isnull(Closed_Date),'NOT','YES')