List working before saving but after saving it does not.

[Riconstruct]

Hello 

I have a list that I am pulling off a ref table so that it shows images with it.  ive done it on another page no problem but with page it seems everything works but as soon as I save it says invalid formula. I can even see it change to the proper ref list before I save. anyone know why its doing this? the error warnings is what Im getting after saving the bottom picture is the list working before saving my work.

[Rafael_ANEIC-PY]

Hello there @Riconstruct 

When you reference LIST([Ref1],[Ref2],[Ref3]) from within a row, you're creating a list of references, this is good, AppSheet can work with this.

When you say LIST(Bedroom[Trim R],Bedroom[Baseboard R]......) each of these is not a reference, it's a whole list of references.

For example, Bedroom[Trim R] returns ALL the of the references stored in the Bedroom table from the [Trim R] column, that's why the app error says:

So in short, "List of List of Ref" <> "List of ref" so your "List" column of base type ref returns an error.

[Riconstruct]

I think I understand I thought the ref for just to pull the data for the list in the table. is there a reason my other one would work with all the exact same? 

[Rafael_ANEIC-PY]

[Trim R] and Bedroom[Trim R] are NOT the exact same.

If you use [Trim R] from within a row of the Bedroom table, you get a REF, like this: 890DSD76

When you use Bedroom[Trim R] you get the entire [Trim R] column, which is a LIST of REF: 890DSD76, 7E3443A2, ACAF65EA, 3928ADFC, 247DBF6D, D0AAFE75, DB330E68

That's why the other one works, and why the other doesn't.

[Riconstruct]

Ahh I see that makes sense. if there a way to achieve the results from [Trim r] to another table. Ive tried SELECT(Bedroom[Trim list]) in a vc but am getting the same error.

[Riconstruct]

but im guessing now that i think about it Bedroom[trim list] would be doing the same thing i guess

[Rafael_ANEIC-PY]

---

@Riconstruct wrote:

Ahh I see that makes sense. if there a way to achieve the results from [Trim r] to another table

---

Yes, but they have to be connected somehow, there should be some condition, reference, or any of the kind that would enable to dereference or find that data from another column, but why would you do that in this context?

[Riconstruct]

im basically looking to have the list that I have on table Bedroom display on the Properties table so I dont have to make the same columns on the property table and enter the data twice. but what I think im better off doing is just remaking the columns onto the property table and then doing the ref list from there. sorry for all the questions Im very new to this learning as I go 🙂

[Rafael_ANEIC-PY · Accepted solution]

I suggest you check out this link:

https://support.google.com/appsheet/answer/10106510?hl=en

There isn't any need to ever input the same data twice in AppSheet most of the time.