auto selecting data based on other data

[aminsaleh]

Hi everyone, 

►I have an inline table called items inside an order table.

I use the item table to pick up items for a specific order.

 

►If I click on add at the first time, for example I selected carpet product. You see all variables are auto selected like size, color, models and special feature.

sku is shown.

►Now If I try to change the size for example.... you see that other variables are not auto changed to match the new size or new element. and so sku is not shown. I have to manually select other variables this time.

Is there a way to make variable change according to other variable?

with thanks 

[jaichith · Accepted solution]

It is initial value and app formula properties. It can be done with some efforts. you have pull those values from the master data by using lookup or select / filter with help of any() functions. I have same case like yours. done successfully. you should be little strong will sequence of if () conditions.

[aminsaleh]

@jaichith  do you know any one video that teaches all of them all together 

[jaichith]

No bro... But I can help you to achieve your needs in private. I have some experience because your requirements are similar to my app. 

[aminsaleh]

That would be very kind of you @jaichith 

[aminsaleh]

@jaichith 

Thank you very much for your kindness and your appreciated support.