The new vibe view widget is really useful and easy to work with. But so far we could only use it for some tables, not all of them.
I´ve been trying to get it to work with our invoice data list but the widget shows this message: [Data not available] Too many fetches of referenced data. Consider using formulas instead to bring referenced data into the main table.
It´s true that we use references in this list but not every reference is necessary for the widget to display. It seems the widget tries to include every row of the raw data instead of just the displayed columns
How do I limit it to certain columns and what actually are the limitations of the widget? How much is too much?
There are two stages: the widget itself, and the template written in it. The widget is supposed to use all data lazily: i.e. it should be trying to get references if the template doesn’t ask for it. But if the template asks for referenced data, it will try to fetch it.
If the template asks for a referenced record or for all records referenced by a “Reference List”, each is one fetch. If you ask for a referenced record for each record of a reference list, then that’s easily many fetches. In that case, use formulas instead.
If you have a concrete example, I could try to answer more concretely.
Also, there is currently a limitation: for a Reference List to work, it needs to be available in a column of type “Any”. (That will get fixed soon.)
Thank you for the explanation. I made some tests and it now works properly (within a test environment). It seems the reason was a reference that itself contained a reference list. So it might be connected to the limitation you described at the end, if I understand it correctly. At least I hope so because this reference list is not something for which I could use a formula instead.
I basically have three tables:
A list of events with one column being a reference list containing responsible employees for said event
A list of business partners
A list of invoice data. I want to use this one with the widget.
The invoice data references the business partner and the relevant event. But the widgets only works if I remove the employee reference list of the event table, which is not relevant for the invoice data at all but just so happens to be part of a referenced record.