Need assistance... I have a table that conta...

(Charlie Gielow) #1

Need assistance…

I have a table that contains information for both a parent company as well as it’s associated child companies.

How to tie the associated child companies to their parent companies?

I would ideally like to have it set up so that when a particular company is tied to it’s parent company it will no longer show up in he view.

I imagine this can be done fairly easily with a ShowIF statement.

Thanks for the assistance!

(Charlie Gielow) #2

I have already tried to create a simple Ref Column and labeled it “Parent Company”.

If a company is a child of another company I simply select said company within the Ref column.

The challenge though is that I’m unable to see the child company within the parent company’s view.

I imagine I need some type of virtual column as a List view or something similar…

(Philip Garrett) #3

@Charlie_Gielow

Go to appsheet.com - Philip Garrett [Appsheet] - portfolio of mobile apps created with AppSheet and look at app “Companies” Philip Garrett [Appsheet] - portfolio of mobile apps created with AppSheet appsheet.com