Writing a IF statement under a column's app formula

[sousal]

Hi there, I am looking for creating a a column's app formula with a IF statement. This column if a EmunList and I am wanting to have if compute that IF they choose option A they receive table A whereas, IF they choose option B they receive table B. 

I think the right course of action if an IF statement then within the IF statement a REF_ROW statement. 

[SkrOYC]

We already talked about that you can't Ref to two different tables, your idea is wrong. Try no to bend the platform and instead work with it.

Make a single checklist with different sections. You can control those sections via Show column type

[sousal]

Hello Skr0YC, thank you for your help... my idea is not wrong, I've seen someone else make it work using REF_ROWS and the app took them from one table to the other, once they picked an option. 

But I would like to try it your way. I am not sure how to make the different sections. Could you please share more insight and instructions. 

[SkrOYC]

If you are talking about REF_ROWS() for your use case, I think you are confused.

In your situation I would merge both tables into one and separate the columns related to table A and the ones with table B via Show column type

[Steve · Accepted solution]

You'll need an appropriate REF_ROWS() column for each table. Use the Show? expression for each of those columns to show or hide each according to your Enum column.

[SkrOYC]

Check his previous post