I have an action that is set up to enter data from a separate table when the form is saved. I have a table for patient notes and a table that contains the patients. Both tables have a Chief complaint column. When opening a patient note, the Chief complaint is referenced from the patient table that is specific to each patient. If there is nothing entered in the Chief complaint column from the patient, it is blank. The action is currently set up with “Select(Patient Appointment Note[Chief complaint],[_THISROW].[_ComputedKey]=[Patient ID and Name])” so that if something is entered into the Chief complaint column on the patient note it will then enter that in the patient file. The issue I am having is that, the next time the patient note is entered the previous statement that was entered will be in there. This is the desired outcome. Here is the problem, If the statement is changed, the action will keep the original statement and add a comma and then enter the new statement. (See photo)
What I would like my app to do is only enter what is in the column from the note. If the statement changes, I would like the action to change it in the patient file. If the statement does not change, then do not enter anything in the patient file (keep it the same). Thank you for your help
