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.
@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?
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |