I have a Table A which gets a new entry for each user every day. I have Table B which gets 30 entries every day.
I have a button “Add Table B Entry” that creates an entry and opens the modal for the user to add a note. This modal takes so long to open. I went into Settings > Doc Map > Dotted Menu Button > Debug Calculations and pressed my button to see what was up. It said that Table A has a Column that summarizes entries from Table B and that it was recalculated every time I added or changed something in Table B.
So: Table A has a column called Table B List, which summarizes everything from Table B that matches the date and user of Table A. This makes adding each new column to Table B slow, since it triggers a recalculation of ALL rows in column Table B List.
Is there a way to make it not trigger? If not, I’m assuming the best solution is to create a button called “Recalc Table B List” that recalcs ALL rows once a day (Automate it to 5am or something). Or create a button in its own column in Table A called “Recalc Table B List for Row” and have an automation that checks when a new row is added to Table B, and to trigger the Recalc button for the date and user that matches in Table A.
I feel like its going to get slower and slower without a solution, as we are only 2 months into using it and its already slow enough for users to complain. There must be something in terms of a “Design Pattern” for these types of situations.