Business users can upload their daily transaction report CSV files. CSV files include member codes (labeled “Other Tender Note”) that are synonymous with a member user individualized codes in our database. I need to figure out how to link transaction history with users in our database.
I set up the “file uploader” input and the “CSV uploader” plugin element to extract the data (most importantly the member codes) from the Transaction Report File. I am not sure how to link data from the transaction report to our internal database. If anyone can offer a solution, that would be great! I am willing to pay someone to do this or to teach me how to do it.
I have included photos for reference below.