Hi
the app was working well but suddenly I got this error ,screenshot of which is attached kindly help
App : Sabarimala Clinic ID : 496778
Column Name โPhoneโ in Schema โOrders_Schemaโ of Column Type โPhoneโ has an invalid app formula '=[Customer Name].[Medical representative Mobile Number?] '. Error in expression โ[Customer Name].[Medical representative Mobile Number?]โ : Unable to find column 'Medical representative Mobile Number?'MORE INFOGO TO THE PROBLEM
thanking you in advance
And you have checked that this โMedicalโฆโ is typed exactly the same way and you have that column name in your โCustomerโ table?
Yes itโs the same. I have also regenerated the columns
I checked your app and table โCustomersโ does not contain a column with the name โMedical representative Mobile Number?โ.
It does contain a column with the name โMedical representative Alternative Mobile Number?โ
Thanks.Its solved. Customers table was derived from a parent table using query function. Addition of a new column in the parent table caused the query to malfunction and caused all the problems !
Excellent!
In the same app , In โOrder Detailsโ Form there is a LOOKUP formula in โInitial valueโ
of โQuantityโ field.
=LOOKUP( [Product Id],
โProducts Fullโ ,
โProduct Idโ
,
โDefault Order Qtyโ
)
This is Fetching the data from the adjacent column โDefault Order Unitโ
instead of โDefault Order Qtyโ
Kindly help. Thanking in advance.
Attaching screens hots
You are probably looking for a syntax likeโฆ LOOKUP([_THISROW].[Product Id],Products Full,Product Id,Default Order Qty)
I tried [_THISROW] also, but itโs not working. Here itโs not the problem of rows, Itโs getting the value from the wrong COLUMN
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |