Hi All,
I'm constructing a model driven app using Virtual tables (from SQL). I've got the virtual connector working fine, and have 2 tables with relationships.
Now what I'd like to be able to do is calculate the total figure (based on view) of a column in one of the tables and display that total somewhere (or store it in a column if required).
For context, the primary table is a list of clients, and a related table is the advertisement bookings associated with that client. The advertisement bookings contains a cost column against each ad booking, and it's the cost column I'd like to total.
Figure 1: This is a subgrid inside my client table form. I'd like to total the cost column and display the figure somewhere. It could be written to the Total Revenue field.
The problem I'm facing is that because the tables are virtual, it's not possible to create calculated or rollup columns.
I've seen it mentioned that a javascript web resource could potentially calculate columns, but I'm not certain how to go about this, or even if it is a possible solution in my case.
Is someone able to tell me if javascript could do what I need? Don't necessarily need a full solution here, just a nudge in the right direction would be great if anyone knows.
Cheers in advance.
Chris.
