Hi Guys,
I have a collection with a few nested collections inside and want to extract the nested collection and overwrite the existing collection.
I can access the data by using the below formula
First(First(First(LookUP_Types).LookupTables).TableData).Ratio
Although I just want the collection to be my table data.
Is this possible?
Any help is greatly appreciated.
Thanks
Yes I thought this was the case. I dont want to create so many collections.
I'm happy to let it as a nested collection.
My other question is how would I use say the items within the nested collection for a dropdown.
LookUP_Types>LookupTables>TableData> Column "Ratio"
Unsure on how to write this formula.
Thanks again
Test with a brand new Collection because it may not be possible to overwrite the existing Collection, since the schema might be inferred on the Collection when the value is first set - so when you try to overwrite same Collection with some other random value with very different schema, there may be some error.
For example if Collection A has this schema [{Title: "A" Name: "B"}] and then you overwrite same Collection A with [{ Quantity: 3, Purchased: true}] there might be some error in doing this, whereas it might accept the overwrite when using something like [{Title: "C" Name: "D"}].
If there's no error you can do it, but if there's an error, try using a brand new Collection to test if it works with the Table Data.
Try this:
First(First(LookUP_Types).LookupTables).TableData
Do you get an error when you use the above or does it work?