About gscriptTR

gscriptTR

Hi folks,in some reasons, i need to filter rows based on "empty" or "not empty" on views

gscriptTR · 08-27-2024

This option is available for any other views, except "chart" view. I want to do the same

gscriptTR · 05-23-2024

Hi folks,I have two tables. PROJECT and UPDATE. I created virtual column for PROJECTs last related child "status".Virtual columns code:LOOKUP(MAX([related UPDATEs][_RowNumber]), "UPDATE", "_RowNumber", "Last Status")There is no result for this code, ...

gscriptTR · 05-11-2024

Hi folks,I have 2 tables, Users and Tasks. As you see in task screen, there is no user related task which assigned "Cengiz Çandar". But in filter screen This user shows for selection. IDK what I missed?Error Screen

gscriptTR · 03-02-2024

Hi folks,I have 2 tables. month and Customer. I need this list: customer's didn't pay months.I have true value in test part, but in screen is not the same output.

gscriptTR

I think best approach is:define initial value for your column. (Ex. "null"). So you can filter "null" values:)

gscriptTR

Thank you @Steve. But i can't create new view just for this situation.As I see, Filter section works with "contains" operator. I think, I can't change this.

gscriptTR · 06-20-2024

Hi,You should create virtual column which concat your enum columns values; and you can use IN() function to check "Non" value.Like This: IN("Non", {"Column1", "Column2", "Column3"})

gscriptTR · 05-25-2024

No, MAXROW and MAX parameters is different. 

gscriptTR · 05-25-2024

End of the 3 days and hours and with AI this code works as i expected:IF(ISBLANK([related UPDATEs][_RowNumber]),"", LOOKUP(MAX([related UPDATEs][_RowNumber]), "UPDATE", "_RowNumber", "Last Status"))if LOOKUP first parameter is Empty or null for some ...

My Stats

gscriptTR's Bio

Badges gscriptTR Earned

Recent Activity

How to filter rows with empty values on a view in UX?

Sort "Chart" view values

LOOKUP from Related Child Records

in Screen filter section, showing different values from screen data

List differences error

Re: How to filter rows with empty values on a view in UX?

Re: How to filter rows with empty values on a view in UX?

Re: Send email only if one of the columns contain a certain "Non"

Re: LOOKUP from Related Child Records

Re: LOOKUP from Related Child Records

gscriptTR's Ideas (2)