Accessing and Updating Fields Across Multiple Tables from a Widget

Ask for Help
1

Hello :: ,
I would like to access a Table from a widget using a reference ( catalog.tableId).
Is it possible to achieve this without the necessity of adding new columns for each required column through a lookup? My goal is to retrieve a specific row using the “rowId” filter and subsequently update certain fields directly from the widget.

{
  "id": 139859,
  "url": "https://img.ofes-1-1.jpg",
  "catalog": {
    "tableId": "Catalogs",
    "rowId": 4821
  },
  "is_cover": false,
  "in_bound": true,
  "date_created": "2023-08-06 18:06:25.777506+02:00",
  "order": 0
}

Thanks

2

I did not understood exatly what you want. Why don´t you show the two widgets at the same view?

3

Hey Rogerio_Penna,
What do you mean by 2 widgets in the same view ?
Actually I have 2 tables “Catalogs” and “Pages”
1 catalogs have multiples pages
When I click on 1 catalog , I display all the related pages in widget but I want to display also
some fields from the table ‘Catalogs’ and being able to update them from the widget.

image
image1920×606 106 KB

@grist.UserTable
class Catalogs:
  title = grist.Text()
  start_date = grist.DateTime('Europe/Brussels')
  end_date = grist.DateTime('Europe/Brussels')
  priority = grist.Numeric()
  url_id = grist.Text()
  url_full = grist.Text()
  description = grist.Text()
  file_name = grist.Text()
  shop = grist.Reference('Shops')

@grist.UserTable
class Pages:
  url = grist.Text()
  catalog = grist.Reference('Catalogs')
  is_cover = grist.Bool()
4

A “View” is anything you select on the menu on the left. Grist creates views TOGETHER with tables (the standard view of a table is a table widget on Grist… on other systems, you may first create a database, and then associate views to those tables. Grist makes it much easier, but it ends up sometimes in we “confusing” tables and views.

image
image602×742 51.2 KB

So, any item on the menu on the left is basically a view. A view is a collection of one or more widgets, that show data from different tables in different ways.

Considering that screenshot you posted was a single screenshot and not two screenshots you joined, you are already showing a View with a Table Widget for the Catalogs Table on the left.

And on the right of the view, you have a Custom Widget showing the Pages table. You are already referencing the Catalogs table by the Pages table and you are already selecting the Pages table BY the catalogs table.

So, any item on the menu on the left is basically a view. A view is a collection of one or more widgets, that show data from different tables in different ways.

When I click on 1 catalog , I display all the related pages in widget but I want to display also
some fields from the table ‘Catalogs’ and being able to update them from the widget.

Ok, now that I understand the structure, let me try to understand better your request.

You are already selecting the catalog on the LEFT widget, and when you select a catalog on the left, the PAGES related to it are changed on the right widget.

There is a relation of 1-n… 1 catalog has multiple pages.

So all pages on the right, since they ARE selected by the catalog, have the same catalog info.

As far as I see you are ALREADY displaying the fields from the Catalogs (right there, in the left) and you can also change the info from that catalog on the catalog widget. So what exactly do you want to do differently?

5

thanks Rogerio_Penna but what I really want is in the widget itself :

  • display and edit fields from the table Catalogs that I don’t have access except if I returns a Python dictionary with all fields in the given record but I won’t be able to update the fields from the widget with the javascript code
    In the widget I can only access to the Page table fields and with the id of the Catalog, I don’t know if I can get the fields of the relation and update them always from the widget
    image
    image1920×595 98.1 KB