I have a form that has a column for current data and a column for updated data. I can end up with three different scenarios where the user will have data in the first column and not the second column:
1. Current Record – user puts the current record data in the first column and leaves the second column blank – our response: look up the data, find it is already there and do nothing
2. New Record – user puts the new record data in the first column and leaves the second column blank – our response: look up the data, find it is not already there and insert the new data
3. Delete Record – user puts the current record data in the first column, but the data has the font attribute strikethrough, and leaves the second column blank – our response: look up the data and remove the record
The only way I can see to differentiate between scenario 1 and 3 is if I can know that the data in column 1 is strikethrough. Can FlexiCapture do this?