Hello!
I have an app and its tables are in BigQuery. I have several columns, C1, C2, C3 and C4. C2 is Ref to another table T1, C1 is based on a formula using the same T1, C4 is Ref to another table T2, C3 is based on a formula using the same T2.
If I change the value in C4, the value from C1 is deleted, but there is no link between C1 and C4 and I don’t understand what happens.
Thank you for your help!
Regards!
Ruxandra
Hello!
Could you try the following? Check the table settings to make sure they correctly point to the corresponding table, and then regenerate the fields.
Hello!
It correctly points to the corresponding table and there is no issue on the schema. Data are correct, this table is used ok. The problem is when updating the field.
Thank you!
Regards!
Hi,
in this case, I would also check the Monitor Log Analyzer to see the operation logs for this table.
I’ve never used BigQuery.
Please post screenshots of the configurations of the affected columns. Include at least the App formula, Initial value, and Reset on edit? settings. If expressions are involved in those settings, please also post screenshots of them.
We have done some changes today; how could I quickly identify the issue in logs? I see there is a lot of information in today’s logs for Mytable (having column C1, C2, C3, C4). Could you give me some ideas how and what to search in logs?
Thank you very much!
Regards!
Ruxandra
Hello, Steve!
I have only one formula in “Formula”, something as : Any(Select(MyTable[JobName],[_THISROW].[CODE]=[CODE])); I mean I have a column JobCode and a column Job Name, and in JobName I have the formula to add automatically the name because JobeCode is Ref to the table of Jobs. According to the same logic, I have in MyTable the Employee’s Code and the Employee’s Name. Well, if I change the Employee’s Code, in order to have someone else, the name of the job disappears.
I have an important remark: MyTable consist in dynamics data extrait from another table in Bigquery (which uses on-prem database) and also in data manually created by user (this was the request of users..). The name of job which disappears is part of these manually data.
Thank you very much!
Regards!
Ruxandra
And as I said to Steve:
I have an important remark: MyTable consist in dynamics data extrait from another table in Bigquery (which uses on-prem database) and also in data manually created by user (this was the request of users..). The name of job which disappears is part of these manually data.
