How do I configure the row as complete when a...

(WAN AHMAD SHAILFULDDEEN BIN WAN NAWI) #1

How do I configure the row as complete when all the column’s filled up?

(Aleksi Alkio) #2

How many columns do you have?

(WAN AHMAD SHAILFULDDEEN BIN WAN NAWI) #3
  1. 15 column 2) 25 column not counting Id column
(Aleksi Alkio) #4

What column types they are? Or can they be what ever?

(WAN AHMAD SHAILFULDDEEN BIN WAN NAWI) #5

There are text type, number, image, date and price.

(Steven Coile) #6

What does “configure the row as complete” mean?

(WAN AHMAD SHAILFULDDEEN BIN WAN NAWI) #7

If all the columns are filled with the required data, then its complete. If even 1 columns missed then not complete. I’m thinking of giving a sign such as color to mark it as complete.

(Steven Coile) #8

There’s no trivial way to do it. The best you can do is a big OR() expression:

OR(ISBLANK([Col1], ISBLANK([Col2], …)

The expression is TRUE is any of the columns are blank (empty).