True False from Child Records to Carry over to parent

Hi Appsheet Community!

I have a parent row with anywhere from 1 - 10 child rows.

In the Child Rows, there is a column called [ACCEPT JOB] in which contractors can (as the name suggests) accept job (through Y/N)

I have a Y/N column in the Parent row called [ALL ACCEPTED], but I would like this to automatically switch to Y from N once all the jobs have been accepted.

I can convert this to a virtual column if needed.

Thank you all in advance!

Virtual Column Formula for ParentColumn[ALL ACCEPTED]

IF(
COUNT(Select(ChildTable[Accept Job],[Accept Job]=FALSE))=0,
TRUE,
FALSE
)

You might want to test the behaviour of this if there are no ChildTable[Accept Job] and decide what you want to happen in that case

2 Likes

Thanks @1minManager, I think I overcomplicated the process when I was trying to achieve this.

I have just added this expression, however, it seems to be picking up the “accept job” of all child rows, not just the related ones.

Where would be the best place to insert the _THISROW to check only the related ones?

Try

IF(
COUNT(Select([Related ChildTable][Accept Job],[Accept Job]=FALSE))=0,
TRUE,
FALSE
)
[/quote]

1 Like

Hey @1minManager,

I feel like we are getting closer.
That expression caused every job to show True for all of the parent rows (if they don’t have a TRUE/FALSE value entered (is blank)

1 Like

Maybe

IF(
AND( COUNT(Select([Related ChildTable][Accept Job],[Accept Job]=FALSE))=0,
COUNT([Related ChildTable][Accept Job])>0),

TRUE,
FALSE
)

** 2 Minor edits to the expression**

2 Likes

@Suvrutt_Gurjar Bingo!

Thank you so much! I still have some work to perfect my expressions between parent and child so this will help me in the future also.

2 Likes

@Suvrutt_Gurjar kill steal :rofl:

3 Likes