Hello, I want to automatically copy entry from this subtable to another subtable. The “Vendor” entry will need to populate automatically on the other subtable to record the invoice number.
I tried using formula to achieve this but the error I get:
Subtable field (F48)“Vendor” 's formula cannot refer to another subtable field (D22)“Vendor”.
Currently, Ragic does not support referencing one subtable field from another subtable field using formulas, nor does it support automatically copying all values from one subtable to another in real time. While a subtable column can contain multiple values (since each subtable may have multiple rows), referencing or synchronizing all values between subtables through formulas is not possible. This is because the order and number of rows in each subtable can change independently, which could lead to mismatched or misplaced data if such referencing were allowed.
To better assist you, I’d suggest we take a step back and look at the overall workflow you’re aiming to achieve. From your description, it seems you want to track the progress of a project, and when the project reaches the stage where you’re recording “Costs” associated with a vendor, you would also like to generate an invoice for that vendor at the same time. Is that an accurate understanding of your process?
If you could provide a bit more detail about your intended workflow, I’d be happy to suggest alternative approaches or workarounds that might help you accomplish your goal.