Changing subpages in a formula

1

Hello, everyone,

I would like to know if this is possible:
I have a page with a table that has several columns, one of which is named Organization and the other Value. In the column Organization, I have links to subpages, such as @Organization A, which directs to the subpage of that Organization. In this subpage, there is a payment table with columns for status (with a list containing “done” and “not done”) and value. On the main page, I want to create a formula that identifies the organization in the first table and sums the values from the payment table that are marked as “done”. This should update dynamically if I change the organization name.

I hope everyone understands what I am looking for, as I know it’s a bit complex.

2

Hello Vitoria

I think I understand your request, let me see…

You have a different table for each subpage/organization, right? If so, I think is better to join all information in one single table and in each subpage you create a view with a filter for the selected organization.

So, the payment table is a big table that contain one column (relation type) to the Organization table. This big table I suggest to put in a hidden page.

So in the main page, you can put a select list containg the organization table rows, and a formula that filter the big payment table with the selected organization and do the needed operations.

To add a new row in the payment views, you can add a button above the view table with add row action, which populates the organization column with the correct organization.

If you need something more, please let me know.
Cheers,
Arnhold

3

But will I be able to chance the selection from “not done” to “done” in the table that is in the subpage and that change automatically in the payment table that is hidden? The objective is that people can only change buttons and add values in the table that is in the subpage.

4

if a user changes a value in a view of your table, on another page, then that change is done also on the base table, and on any other views of the base table, throughout your document.

5

Hi @Vitoria_Sanchez and welcome to the Coda Community!

Here’s a quick POC that I think gets you what you’re asking for.

Are you referring to changing the subpage name when you say…

If so, yes. When you update the subpage name it will still work in the POC.