Need a way to create an EOTI Form, and allow users to populate Data
We have a confidential database where we have two fields in that table, that I need to make available to EOTI. Those are the only two fields I need them to input data into.
My original thought was to do a separate table, connect the main record ID to the new table and then they could search for the record ID, the two fields would populate and they would enter their information. This seems ideal because I can limit what they can see/do.
However, if I have these two fields in the confidential table, and the same two fields for data entry in this new table, how do I push the data they enter in the EOTI table, over to the main confidential table?
If I do a Table to Table, I can get the Record ID from the Confidential table to populate in the EOTI table, but then if I link the two fields that need data input, they come in as read only.
Would love to have anyone's input on how you've done something like this!
------------------------------
Trace Symonds
Instructional Systems Designer
Presbyterian Healthcare Services
Albuquerque NM
Trace Symonds
Instructional Systems Designer
Presbyterian Healthcare Services
Albuquerque, NM
2021-2022 QuickBase Customer Council
------------------------------
My original thought was to do a separate table, connect the main record ID to the new table and then they could search for the record ID, the two fields would populate and they would enter their information. This seems ideal because I can limit what they can see/do.
However, if I have these two fields in the confidential table, and the same two fields for data entry in this new table, how do I push the data they enter in the EOTI table, over to the main confidential table?
If I do a Table to Table, I can get the Record ID from the Confidential table to populate in the EOTI table, but then if I link the two fields that need data input, they come in as read only.
Would love to have anyone's input on how you've done something like this!
------------------------------
Trace Symonds
Instructional Systems Designer
Presbyterian Healthcare Services
Albuquerque NM
Trace Symonds
Instructional Systems Designer
Presbyterian Healthcare Services
Albuquerque, NM
2021-2022 QuickBase Customer Council
------------------------------
