I am trying to set up a music database whereby numerous users will enter lists of music tracks and performers (possibly 40+ entries per user at a time) but I need the tracks to all be entered into one column ("Tracks") and the performers in a second column ("Artists") in the data table.
My problem is that having created the "Tracks" and "Artists" columns I can only get one of each as DataPage elements. In an ideal world I would like to create 30 or 40 of the same elements so that the contributors can supply their full list in only one submission. I thought I had cracked it by using Virtual Fields (which I could rename) but then realised that Virtual Fields are only used to transfer data onto other DataPages, not into the main table.
I can't believe that this is the first time that someone has needed a "multi-entry" facility, so am I missing something or does someone with more Caspio knowledge than me have any suggestions?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
DadCA
I am trying to set up a music database whereby numerous users will enter lists of music tracks and performers (possibly 40+ entries per user at a time) but I need the tracks to all be entered into one column ("Tracks") and the performers in a second column ("Artists") in the data table.
My problem is that having created the "Tracks" and "Artists" columns I can only get one of each as DataPage elements. In an ideal world I would like to create 30 or 40 of the same elements so that the contributors can supply their full list in only one submission. I thought I had cracked it by using Virtual Fields (which I could rename) but then realised that Virtual Fields are only used to transfer data onto other DataPages, not into the main table.
I can't believe that this is the first time that someone has needed a "multi-entry" facility, so am I missing something or does someone with more Caspio knowledge than me have any suggestions?
Thanks in advance.
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.