Why My Lookup Function is not working? Having...

Why My Lookup Function is not working? Having Two Tables -

โ€œAssigned Operatorsโ€ having Emp Id, Short Name, Status โ€œTest Dataโ€ having Emp Id, Short Name, Status.

Assigned Operators is my transaction table. If i add one row in โ€œAssigned Operatorsโ€, the status should be reflected in โ€œTest Dataโ€. I used this formula =ANY(SELECT(Assigned Operators [Status], [Short Name] =[_THISROW].[Short Name] ))

And tried with LOOKUP formula. =LOOKUP([_THISROW].[Short Name], โ€œAssigned Operatorsโ€, โ€œShort Nameโ€, โ€œStatusโ€)

But, if i have virtual column for โ€œStatusโ€ in Test Data, its working.

Please help me out with this.

0 12 855
12 REPLIES 12

@Aleksi_Alkio Yes Mr. Aleksiโ€ฆ The following hints will be helpful when you check the problem. Two Tables - Operator Directory and Assigned Operators In application, please click โ€œStatusโ€ button,

choose any code in โ€œAvailableโ€ category, then select โ€œWorkingโ€ then you need to provide โ€œClientโ€, โ€œCertification typeโ€, . and โ€œTill dateโ€, then click โ€œNewโ€ in assigned operator. system will show the competent operators, choose any one name then save it. Now if you see in โ€œAssigned Operatorsโ€ table, the new row is added. If you see in โ€œOperator Directoryโ€ table, the particular operator โ€œStatusโ€ column doesnโ€™t change.

Kindly check the problem. Thanks lot for your kind support.

It doesnโ€™t recalculate the status if you donโ€™t open the record from the Test Data table. And if you want to recalculate all records, you should open all those records.

@Aleksi_Alkio I did open and save the records. Even i tried with new row.

Sorryโ€ฆ I noticed the status change in โ€œAssigned Operatorsโ€ onlyโ€ฆ not in โ€œOperator Directoryโ€

You wonโ€™t see it because I didnโ€™t open/save that record from โ€œOperator Directoryโ€. Let me try to explain how the app formula worksโ€ฆ If you want to read any value from another table (like this status), it wonโ€™t update the normal columnโ€™s value even if it has an app formula. If you want to update the value, you need to read it with the virtual column or with the spreadsheet formula.

Would you like me to open your app and check the reason?

@Aleksi_Alkio With pleasureโ€ฆ SNMEOperations-575724. But i changed the concept. Still you can checkโ€ฆ instead of test dataโ€ฆ please use โ€œOperator Directoryโ€

Mr. Aleksi, If you want, i will go back and set the things. so that you can check the reason

Yes please

I choosed > 1362 > then Sargunam > 93043. It wonโ€™t change the โ€œStatusโ€ value because I didnโ€™t open the record from โ€œOperator Directoryโ€.

If I open it, Iโ€™m able to see the โ€œStatusโ€ and if I would save that record, I would see it in the detail view.

@Aleksi_Alkio Ohโ€ฆ reallyโ€ฆ i am sorry to say that i tried now. i dont see the changes in status. can you please add one record from your side. So that i can see the changes in Operator Directory in excel sheet.

@Aleksi_Alkio Yes. Mr. Aleksiโ€ฆ I noticed the status. I am wondering why i could not see the data in excel sheet?.. it meansโ€ฆeven this normal column with appformula, i cant set the value manually you mean?

Top Labels in this Space