Highlighting blanks on another table

[Paul_Clawson]

Hi,

I have a columb that requires filling when I have a received item. I would like to have a seperate columb on another table that shows when it is blank so I don’t have to scroll down to see what I’m yet to receive.

Any suggestions would be a appreciated.

Paul

[Aleksi]

You need to use virtual column for that purpose. What kind of relationship you have between these two tables/records?

[Paul_Clawson]

Hi Aleski

All I do is fill it with a dot to signify the item has arrived. I format my excel to change colour when not blank.

[Marc_Dillon]

You might consider creating a slice and view particular to this purpose which filters away the unnecessary data.

[Paul_Clawson]

Sincere Apologies, Aleksi.

Im, new to Appsheet, I’ve read and tried to absorb information on the community but some still hasn’t sunk in.

As above, i would just like to format one form answer on the app in "part received column " to a colour if i have received the part. when i then look a a long list of items i have on order the ones with colour in the received section show me easily if the part is here.

if however i could create a new list with just parts that were not here that also would be great, i don’t mind having another page to view this. would this solution be leaning more towards Marc Dillions response?

[Marc_Dillon]

What view are you looking at this data in? Table,deck,detail,form?

Have you learned about UX-> Format Rules, yet?

If you need a field to show up in a different order in a form view, you need to create a slice, there is no other way to rearrange column order for form views except for changing the spreadsheet.

I often create slices, for a many-column table, that only show a handful of columns, for the purpose of inputting only a handful of data points on an existing record. And I typically create an action button to forward the user to that specific form, use Linktorow().

[Paul_Clawson]

I have the setting to deck view,

Ill look into slices and actions, thanks for the feedback.

[Paul_Clawson]

I have what i think is a good soultion,

I have created a new view, Sfor this view use this slice sliced data and then on the row filter condition is put in ISBLANK(part received). this view then only shows the parts that i haven’t stated are received.

[Marc_Dillon]

Hope it works for you.