Jump to content
  • 0

How to get multiple entries in a DataPage into a single column on a table?



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

  • 0

Thanks for the prompt response Telly.

I had seen Triggered Actions but didn't realise this could help as I cannot access it using my free account.

I am working on  someone's hobby / not-for-profit project, so paying $300 per month to upgrade is totally out of the question.  I guess I will have to abandon Caspio on this occasion and keep looking for another solution.

Many thanks again

Link to comment
Share on other sites

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.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...