Calling a specific object from a specific view?

AppSheet AppSheet Q&A
1

Hi folks.

I’m trying to conditionally format [EMPLOYEE] only if their job has not been signed off on.

I’ve tried setting the format rule to say if [FINISH JOB] time is blank then format [EMPLOYEE] but the poblem is this rule is now applied to every [EMPLOYEE] field everywhere on the app.

How would I call the [EMPLOYEE] fields ONLY in the form results view (AKA - “LIST”)

Thanks heaps in advance,

Dan

3X_8_9_89869e858207f194e93435043ebcf2be8ae485c3.jpeg
3X_8_9_89869e858207f194e93435043ebcf2be8ae485c3.jpeg1440×3040 191 KB

2

3X_d_1_d1c441c58b363e65f76d4f32093fe5b9678eab24.jpeg
3X_d_1_d1c441c58b363e65f76d4f32093fe5b9678eab24.jpeg1440×3040 129 KB

3

3X_3_a_3a6ebfd6665eff723405eac6b8235da3a52dfe9e.jpeg
3X_3_a_3a6ebfd6665eff723405eac6b8235da3a52dfe9e.jpeg1440×3040 116 KB

4

Thanks mate. I’m very new to coding so I’ll have to look into that. I appreciate your help anyway

1 Like
5

Your recommendation seems to be useful in checking if views are present but I can’t manage to work out how to check a columns value inside a specific view and consequently formatting another column inside that same view only.

In short, I need to do this:

If column1 is blank in view1 then conditionally format column2 in view1. Also, would this be controlled under a new format rule?

I’m lost and sorry to be a pain in the backside

Thanks in advance

6

It appears you already have a format rule setup that formats column2 according to column1, but you only want this formatting applied in specific views:

DC81:

How would I call the [EMPLOYEE] fields ONLY in the form results view (AKA - “LIST”)

Modify your existing format rule expression to include an expression that uses CONTEXT() to check whether the current view type is a “list”:

AND(
  ISBLANK([Finish Job]),
  ("Deck" = CONTEXT("ViewType"))
)
1 Like
7

You sir, are a legend! Thanks so much

1 Like