Hi All,

I have a table which has four fields in it - lets call them A, B C and D. I then have a view of the table called Failures which shows the same first four fields then an additional 15 formula fields showing wether an item has passed overall assessment or not. When I connect to the database using an API I can only see the four base fields in the table I can see any of the other views to extract data from those (i.e. I would like to extract all four of the base fields plus the additional 15 against each record into an external database). Am I missing something or is it not possible?

Alternatively, is it possible that each time a mark in one of the 15 additional fields is updated, a record is written to an different unrelated table (used for data extraction) of the first four fields and the additional 15 formula fields?