Is there any substitute for INDIRECT in AirTable?
Solved
INDIRECT Substitute
Best answer by OfficeOurs
The key is using an intemediate dynamic field. Say I want to refer to {A} if my dropdown says A and to {B} if my dropdown says B.
Switch({dropdown}, "A", {A}, "B", {B})
Then drop in the Dynamic (Switch) field wherever you need a dynamic value.
The key is using an intemediate dynamic field. Say I want to refer to {A} if my dropdown says A and to {B} if my dropdown says B.
Switch({dropdown}, "A", {A}, "B", {B})
Then drop in the Dynamic (Switch) field wherever you need a dynamic value.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.