Hi, Tom 

Sorry for the delay.

Thanks for showing interest in our plugin.

We have several built-in integrations with form plugins.

These form integrations are :

- integration for Forminator Forms, ( a free add-on), 

- Formidable Forms integration;   

and  Gravity Forms integration

- I am not sure how implementing the song list with the Artist list into a Form would go,

and if that is possible.

If you find a way to get the list of songs ( with the Artists) in a Form,  and make the list of songs load in a select box Form field;

then a user could use the selectbox to pick a song from that field;

you could add another text field as "input your name" ;

then we would have a Form with some submissions storing a persons name, and a song with the Artist.

-

Then you could link this Form's data to output a wpDataTable, with the submissions on a page.

And you can sort it by date and time of the submission entries.

-

Now, i am just not sure if it's possible to do that first part of  setting up the data in the Form itself.

For that, you might ask the Support of the Form plugins, and see if one of these Forms that we have integration with has this capability, to create a selectbox  that can load a list of data like that.

If you can set that up with a Form, then it might work.

-

2.

If you can't make that happen, with the Forms,

i am thinking about alternative solutions, but can't think of one right now.

I will ask senior colleagues to confirm if there is any better solution, and we will report back to advise you on this.

Thank you.

-

And i just wanted to point out that you can try wpDataTables before purchasing

 on our sandbox Demo sites ( you can find links for the main plugin Demo,  

as well as add-on Demos, in my signature),

and there is a 15-day money-back guarantee period, 

so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

Let me know if you have any additional questions. 

Hi, Tom 

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

Just following up to provide additional advice from our 2nd level Team on this Query.

-

Basically, what I explained about using the Forms,  that might be the only workaround with that method.

The only alternate way, without using any Forms,

could be if you make a relational MySQL database with multiple tables.

For example, you could import all the song data in a Manual table with our plugin.

More details about Creating editable tables by importing data from Excel, CSV or Google Spreadsheets here.

-

So, if you would create one "Songs" table to hold all the songs( with columns such as "song_id" , 'song_name'  )

another table as "Artists" ( columns could be something like 'artist_id'  and 'artist name'),

and a third table to join the data with our foreign key relation feature.

Table name could be anything, like  "Singing Que".

You could make it a new Manual Table, our plugin will automatically make a wdt_ID column ( as the unique auto-increment row identifier),

add a column "name" ( for the user to input their name),

 foreign key column 'song' - which will be foreign key relation from table "Songs",

foreign key column 'Artist",  which will be foreign key relation from table "artists".

- You can make both columns editable, the only choice will be a one value selectbox.

-

The only limitation here would be, if we want to "Limit editing for users to view and edit only their own rows",

the foreign key values would not show, since they would be created by Admin.

-

But if you wish to try that solution, without "Limit editing" option in the Editing Tab, perhaps it might work.

-

I hope that might help. Let me know if you have any questions. Thank you