Hello,
As you can see below, I am invaded by attention triangle marks. I guess itโs a beginners thing as I see many questions on the topic and reading them all โฆ Iโm still blank. Didnโt find anything on youtube or Documentation โฆ (a youtube with solving a bunch of these would be amazing since they are a common beginners lack of understanding).
Obviously, there is something fundamental I am not understanding here, in how References and de-references should be set up.
Iโve got two kinds of them:
1. Images + Icons References:
Iโve got a Times Table and a Production Types Table.
In the Production Types Table, there is a column with Kinds of production types like Welding or Sanding and another column with Icons for each:
And in the Times Table there is a column Kinds of Production that references the Proudction Types Table, the point being that when you add Times to a task, you select what type of Production you made and when selecting, there is an Icon to make things more visual. But here I get grey triangles.
There are no Valid_If formulas โฆ or any formulas involved here, that I could think might be relevant.
(and I donโt get it because I made the same thing for Users and their images selected for being Responsible for a Project and it worksโฆ)
Also in the Times table, there is a Task column, Referencing the table Tasks, because I add Times of production to Tasks.
Tasks table has more columns but you can see here the key and the label:
And again the Times Table with the Task Reference:
There is one formula here, in a Actin taking me to Add new Times from a Task Deck View:
So I read that the triangles represent broken references, as in the information that you are referencing does not exist โฆ but this still doesnโt mean much to me yet.The word โkeyโ confuses me in most explanations โฆ I feel like I have solve these two and deeply understand how and then Iโll get it.
Canโt wait to get this ones right
Thank you,
Sorin
Solved! Go to Solution.
Alright, last night was a big breakthrough. I managed to create myself a couple more instances filled with triangles and then I finally figured it out. Iโll explain for whomever may have the same question.
So in my described cases, here what I was doing wrong:
The problem for the Icon Images had to do with the way I am writing the path to the image in the Spreadsheet Table. It must have a hidden part of the name or something, because I still donโt know how to write the direction to the image corectly myself in the spreadsheet (I did see tutorials and followed instructions but โฆ somethings not right) โฆ
but there is an easy way out of this: I made a Form to edit the Types of Production Table, and in the edit on the mobile, I would choose to change the picture, navigate to itโs folder and upload it through the app. And so, the correct path to the image was writen in the Spreadsheet by Appsheet so thatโs solved.
Here, to have the Autocomplete done, I used a LINKTOFORM() formula in the Action Button as itโs shown in the images above. The mistake was in that formula:
Wrong:
LINKTOFROM(โTimes_Formโ,โTaskโ,[Task])
Correct:
LINKTOFORM(โTimes_Formโ,โTaskโ,[Task - ID])
[Task] column stores the name of the Task, which is what I wanted to show so instinctively I dereferenced to the [Task] column. And it works but with possible problems which is why I guess you get a triangle and not a complete Error. (in the sense that in a name column, you could have two identical names and thatโs a problem). So correctly, I had to dereference to the Key column (which in my case is [Task - Id], and since the [Task] column is the label of the Table, I still get the name of the [Task] displayed, and not the Unique Id stored by [Task - Id]. (hope this makes sense )
Hi @sorin_mihai This can happen quite easily if you for example change your tableโs key column. Then it will lost the connection between two records. You can think it like thisโฆ you have a parent and child. Parent has a social security number (which is the same than keyโs unique ID value). Now the child knows who is his parent. If you now change your tableโs key column, the value in that column is different and the child doesnโt find itโs parent anymore.
But these triangles appear since the very first time I set up the column as Ref. Itโs not like it used to work for a while and then I changed the key for some other reason and it stopped working. Itโs like that since first I set the tables up โฆ
But letโs say this is the case and the parent got a new security number. Canโt I teach the Child about itโs parents new security number and have a happy family again?
Yes you can open the child record and choose another parent. If you do that, you should not see this warning anymore. Or is it possible that you have a wrong Valid If formula?
oup โฆ you might have hit the spot โฆ I have no valid if formula in any of the cases. Does a reference generally go with a valid if formula?
Ref column doensโt need to have any Valid If formula but you can filter with the formula when you choose the key column for the SELECT expression.
Alright, last night was a big breakthrough. I managed to create myself a couple more instances filled with triangles and then I finally figured it out. Iโll explain for whomever may have the same question.
So in my described cases, here what I was doing wrong:
The problem for the Icon Images had to do with the way I am writing the path to the image in the Spreadsheet Table. It must have a hidden part of the name or something, because I still donโt know how to write the direction to the image corectly myself in the spreadsheet (I did see tutorials and followed instructions but โฆ somethings not right) โฆ
but there is an easy way out of this: I made a Form to edit the Types of Production Table, and in the edit on the mobile, I would choose to change the picture, navigate to itโs folder and upload it through the app. And so, the correct path to the image was writen in the Spreadsheet by Appsheet so thatโs solved.
Here, to have the Autocomplete done, I used a LINKTOFORM() formula in the Action Button as itโs shown in the images above. The mistake was in that formula:
Wrong:
LINKTOFROM(โTimes_Formโ,โTaskโ,[Task])
Correct:
LINKTOFORM(โTimes_Formโ,โTaskโ,[Task - ID])
[Task] column stores the name of the Task, which is what I wanted to show so instinctively I dereferenced to the [Task] column. And it works but with possible problems which is why I guess you get a triangle and not a complete Error. (in the sense that in a name column, you could have two identical names and thatโs a problem). So correctly, I had to dereference to the Key column (which in my case is [Task - Id], and since the [Task] column is the label of the Table, I still get the name of the [Task] displayed, and not the Unique Id stored by [Task - Id]. (hope this makes sense )
Good work!
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |