“remove link-to-table” in App Builder

:robot: Kuma (Baserow’s AI assistant): often the fastest way to get help. Try asking Kuma before posting here. Available to all SaaS users, and to self-hosted users with a connected AI model.

on

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

SaaS

What do you need help with?

I have a single table named “Companies”.

It contains a “Link to Table” field with a reference to a supplier, which is linked to their customers.

I created a small application that displays a list of a company’s customers in a table.

I want to add a “Delete” button to remove the link.

I tried to create an event that updates the cell containing the list of IDs, without including the row ID. Unfortunately, I end up with commas… (see screenshot of the table)

What is the recommended way to implement “remove link-to-table” in App Builder ?

Please attach screenshots or videos if they help illustrate your question.


I understand that what was expected was the line name (and not the ID). But the problem remains the same :grimacing:

I found a formula thanks to ChatGPT, do you have a better solution?

replace(
replace(
replace(
get(‘current_record.field_476651.*.value’),
concat(get(‘data_source.1413594.field_264793’), “,”),
“”
),
concat(“,”, get(‘data_source.1413594.field_264793’)),
“”
),
“,”,
“,”
)

@frederikdc Maybe you have a better solution for this? :thinking:

There are 2 ways to implement adding or removing items from a Link to table field in the app builder.

  1. Use the Record selector element and make sure it allows you to select multiple items.
  2. Reorganize your tables you that you have an intermediate table where each record links 1 supplier to 1 customer. This makes is much easier to add / remove records by using a Repeat element.

If input will be done mainly by the application builder, I would recommend the second approach.

Thank you for your reply. I used the second approach and it works very well.

Have a good day!