Hi all, I have not been able to find my answer to this, and I have been looking in the forums. I have a total of 5 tables: Budget, Pillars, Initiatives, Pillar Budgets (Budget and Pillar joined), Initiative Budgets (Budget and Initiatives joined) Budget contains two Enumlist reference columns. On…

Are you talking about handling your bridge table entries in a many-to-many relationship setup via the use of an additional enumlist(REF) type column?

Ya that would be what my end goal is, unless there is a better way to handle it.

Follow up question for clarification. Are you trying to set up an initial value in Pillar ID and Initiative ID? If so, are you doing this in the table column settings and that is where it is only allowing you to set this? I think this is where your issue is, but I am not quiet certain how you are …

Got it, so I am trying to populate both Pillar ID and Initiative ID columns in the Budget table yes. This way I can loop whenever a new budget is created to create a Pillar Budget and Initiative Budget record. I am trying to populate both using the formula field (I have also tried with initial valu…

Hm, I am wondering if this is a result of too many list items being written to the column value? I don’t know what the restrictions are on EnumList columns in Appsheet database, but take a LongText limitation for example which has a character limit of 5000, I’m wondering if an EnumList column has a …

I would guess this might be contributing to your issue. [Markus_Malessa_0-1710362083793.png]

No I haven’t gotten to that many characters yet. I’m going to test doing it with a Google Sheets database and see if that works just to rule out the possibility of the Appsheet database. I even tried creating a bot to run separately after the row was created, but that didn’t work either.

Just to double check, you were able to save a new row with one field preset? Does the audit log trail provide some additional info outside of the ‘invalid request’? At times there is additional info in the audit log that helps parse the problem a bit more.

So, my assumption was correct. It all worked fine with Google Sheets. I looked at the audit trail for the error, and it gave me a huge error list. I’m guessing I’ll have to find a different way to populate these tables, how do you normally do this?

My process is probably smaller in scale than yours. But, I set a singular relationship in a drop down so it is just a REF column, the table on the singular reference stores an EnumList column of REF and it also stores the same references in a table of just keys (bridge table in SQL). Then the form a…

How to populate two columns on one table from two different tables

AppSheet AppSheet Q&A

Markus_Malessa March 13, 2024, 8:34pm 7

I would guess this might be contributing to your issue.

Topic		Replies	Views
'Add new rows' complex action AppSheet Q&A databases , errors	3	66	July 16, 2025
Multi select values from a reference column AppSheet Q&A expressions	11	34	September 19, 2022
2 enumlist field and add row to another table AppSheet Q&A databases	4	25	October 12, 2024

How to populate two columns on one table from two different tables

AI Suggested topics