Copying multiple records from one table to another as separate records
This app is for a field audit. There are approx. 50 questions on the audit that never change. The questions are scored as "S", "U", "Y", "N", "NA". I currently hold the audit results in one large table with each question:score pair held in it's own column along with the Date, Location and a couple other things being one record. This makes for easy form entry but it is terrible for reporting purposes.
What I would like to do with a Formula - URL button is create individual question:score records along with the date, location, etc., in a new table. So each existing "audit" record would create approx 50 records in the new table. I can do this with API_AddRecord but the nested URLEncode gets ridiculous. Any insight would be greatly appreciated.
What I would like to do with a Formula - URL button is create individual question:score records along with the date, location, etc., in a new table. So each existing "audit" record would create approx 50 records in the new table. I can do this with API_AddRecord but the nested URLEncode gets ridiculous. Any insight would be greatly appreciated.
