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.
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
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.
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
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.
Check his previous post