nested tables in form

User Talk Apps
1

Hi everyone. If my request is covered with something different, please kindly share the link.

So I have parent and child tables and now trying to make a simple nested form with some fields of parent table and editable grid to easily enter child table’s entries. Basic target layout see on Pic 1.

The closest ways as I’ve found, are:

  • “Single record“ page in apps interface (Pic 2). But it’s not that great when it comes to add a new entry: easy input of child entries is crucial for me
  • Groupped view of child table (Pic 3). But it’s not that convenient to enter parent’s parameters.

So if anyone has faced this issue, could you please share your experience of solving / bypassing it?

Pic 1.

06bc620603c310a4b3a32575e07fb802
06bc620603c310a4b3a32575e07fb802738×481 7.3 KB

Pic 2.

a05583a9f40b907cc7787b467a4d6d4e
a05583a9f40b907cc7787b467a4d6d4e1054×636 18.8 KB

Pic 3

33836be1c0cf19f3e3c729b1e10e23fa
33836be1c0cf19f3e3c729b1e10e23fa1346×451 30.9 KB

2

Hi @Maxim, and welcome to the SeaTable forum!

Sorry for the late reply. I try to find out a solution but I think you faced the major limitations for now regarding your use case. However, version 6.1 that should arrive before the end of the year might bring a solution as the link edition will be eased in “Single page record”-type app pages: wait and see :blush:

Alternatively, here is another solution that might fit your needs:

  1. Create a new Python script and copy/paste the following code:
from seatable_api import Base, context
import requests

base = Base(context.api_token, context.server_url)
base.auth()
view = base.add_view('Positions', context.current_row['Name'])
print(view)
base.update_row('Quotes',context.current_row['_id'],{'viewID': view['_id']})


url = f"https://cloud.seatable.io/api-gateway/api/v2/dtables/{base.dtable_uuid}/views/{context.current_row['Name']}/?table_name=Positions"

payload = { "filters": [
        {
            "filter_predicate": "is",
            "filter_term": context.current_row['Name'],
            "column_key": base.get_column_by_name('Positions','Quote')['key']
        }
    ] }
headers = {
    "accept": "application/json",
    "content-type": "application/json",
    "authorization": f"Bearer {base.jwt_token}"
}

response = requests.put(url, json=payload, headers=headers)
print(response)
new_row = base.append_row('Positions',{'Amount':1})
base.add_link(base.get_column_link_id('Positions','Quote'),'Positions','Quotes',new_row['_id'],context.current_row['_id'])
  1. In your Quotes table, create a new text-type column called viewID and a new button-type column that will run the script you just created as first action and will then open an URL. To find the value of this URL, just open your Positions table, copy the URL, and replace the last four characters (after &vid=) by {viewID}

Here is what the script actually does: it creates a new view with the name of your current Quote in the Positions table, applies a filter to this view so it will show only the Positions linked to this quote and create a first (empty) position. The button run this script and then opens the corresponding view. Using such a filtered view will make every new Position in the table alreading having the right Quote linked, so it might be easier to fill.

Bests,
Benjamin