Ok got it! With the images it is much more clear and it is fairly basic as you mention. Was just hard to visualize from a text description.
First things first, like @Steve mentions, you need to correct the Ref column that is pulling in the Employee names. You do this by making sure the VALUE stored for each row is the KEY column in the table you are referencing. You can still show the Names by setting the Name column as the LABEL for that table. AppSheet will automatically translate the KEY value into the LABEL value for display.
Secondly, you’ll need to decide how you will be reflecting the Pass/Fail results in the Users view. As you have already noticed, Yes/No columns do not show the column headings. I would recommend setting each column for the different Certifications as Text and then assign values like “Pass” or “Fail” or blank if not yet completed.
Once you have the two things above settled, then you can link to your Form Certification results. I’ll assume you are saving these results to a different table named “Certifications”, you have an “Employee” column and you have a result column named “Pass?” defined as a Yes/No column with “Yes” for Pass and “No” for Fail. If so, then you can set the App Formula for each column like this:
LOOKUP([_THISROW].[Employee], "Certifications", "Employee", "Pass?"),
I hope I am on the right track here and this helps. @Steve please chime in if I have mis-represented anything!