I am creating a database of students.
I have two large Excel spreadsheets. One spreadsheet is full of personal student info (name, Parent contact info, etc) the other spreadsheet is full of academic data (multiple test scores and grades).
What would be the best way to get all this data in to Tap Forms? I have a few ideas maybe there are more or better ideas.
1)Manually merge them into 1 spreadsheet and import that to 1 database
2)Import them separately and Tap Forms will somehow merge them into 1 database by using a key value like Student ID
3)Import and create two separate databases and link them as related within Tap Forms.
What is the best approach here?
Thanks.
Hi Jim,
I haven’t written a function to support #2 yet, but it’s on my to-do list. So if you want to have a relationship between your forms like that, you’ll need to do #3.
.
