In table 1 I have a column that is a linked relation to another table (table 2). Table 2 has a row for each month of the year. In table 1 I can select multiple values from table 2.
I want to add a value from table 2 to every row in table 1 that has a certain value already chosen. For example, if “October” is selected I want to add “November”. How can I achieve this?
Hello
To achieve what you need, you have to set up a button that can be triggered in two ways: either by manually pressing it every time you want to perform the update, or by using automation to press it automatically (based on time or specific events).
If you apply a formula to a column, manual values cannot be entered, so you must keep the columns editable and use an action (such as a button or automation) to update their values. If automation is not suitable for your needs (due to limited automation options), you can set up two columns—one editable and one calculated. In the editable column, the user selects their input, and the calculated column uses this value to compute the “final” result. However, this solution may be visually unappealing, as it requires two columns, and the user cannot modify the calculated values directly.
Best regards,
Arnhold
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.