There are a whole variety of approaches but one approach would be to make it connected Sync table of your confidential table and open that up to EOTI access. You would only include the non-the minimum number of non-confidential fields in the EOTI Sync table.
Because the record IDs of the confidential table will be identical to the Record ID's in the connected sync table you can use a saved table to table copy to copy these across (triggered by a Pipeline to run it) for you could use a pipeline to copy them across as entries are made.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
