I have a wpdatatable. It got quite a lot of columns.
The edit modal is somewhat "clunky" for all that i need it for and would like to break some of the data down. I think i have 2 options here, one to split my table into several and use a SQL query to - join - them , this would be a challenge as there won't be a "Unique" field for the user to select (foreign key would be ID value, but end user wouldnt know what it was) - ie: a list of names - and as only one field is visible in drop down , it would show Bob, Bob, Bob, Dave, Dave, Steve, -etc.
My other option was to build a form for front end with tabs. or similar. I was hoping that i could do this now i have my wpdatatables all set up. It seems this is not the case? Can gravity or formidible link to an existing wpdatatable? Can anyone recommend a good workaround (edit/add new modal) for several columns?
Could you kindly explain in more details what you would like to achieve, and if possible send us some screenshots or a screen recording with an example of the desired scenario, so we can understand better and provide you with the best solution?
One thing i want to achieve is to either have the "modal" on a page of its own with a form handling the data entry to my wpdatatable. - so that i can neaten it up. However the datatable has already been created and has data in it. My understanding is that any form plugins require a new table to be =created? if possible id like to make a form to work with the table i already have. Ideally be able to use multiple forms or a Tabbed form to put data into 1 table.
Regarding the editing modal I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
Something like this was never attempted, so I can't even advise how to go on about this. You can take a look at our hooks and filters, and see if there's anything there that can help you out, but other than that I can't help you with this request.
I will forward the idea to our development team, though as I personally believe this is a good suggestion.
We have an integration with Gravity Forms and Formidable Forms which you can use to create new tables that will be updated as new entries are added, but it is impossible to connect an existing table to a form and have it populate new entries.
You can use foreign keys to link two tables but we don't have the auto-fill feature so you would not be able to fill in data automatically if a specific selection is made.
I have a wpdatatable. It got quite a lot of columns.
The edit modal is somewhat "clunky" for all that i need it for and would like to break some of the data down. I think i have 2 options here, one to split my table into several and use a SQL query to - join - them , this would be a challenge as there won't be a "Unique" field for the user to select (foreign key would be ID value, but end user wouldnt know what it was) - ie: a list of names - and as only one field is visible in drop down , it would show Bob, Bob, Bob, Dave, Dave, Steve, -etc.
My other option was to build a form for front end with tabs. or similar. I was hoping that i could do this now i have my wpdatatables all set up. It seems this is not the case? Can gravity or formidible link to an existing wpdatatable? Can anyone recommend a good workaround (edit/add new modal) for several columns?
Thanks
Dan
Hi Daniel
Thank you for reaching out to us.
Could you kindly explain in more details what you would like to achieve, and if possible send us some screenshots or a screen recording with an example of the desired scenario, so we can understand better and provide you with the best solution?
Hey Blazenka,
One thing i want to achieve is to either have the "modal" on a page of its own with a form handling the data entry to my wpdatatable. - so that i can neaten it up. However the datatable has already been created and has data in it. My understanding is that any form plugins require a new table to be =created? if possible id like to make a form to work with the table i already have. Ideally be able to use multiple forms or a Tabbed form to put data into 1 table.
example
[Tab 1 - Basic information] [Tab 2 -further information] [Tab3 - last information]
The final part was to see if it was possible to have multiple columns in the lookup function and use this to auto-populate fields that will be stored?
for example i have 2 tables. 1 is for animal rescues, the other with contact information for the person.
[animal table] - columns: animal, person, location information
[person table] - columns: name, address and telephone
On the animal table, have a lookup field that shows a list of people with first line of address called from [person table]
Bob smith, 123 street,
Jane doe, 456 avenue,
Steven jones, 789 Street,
Bob smith, 385 Place,
and when one is selected it would auto-populate the relevant fields in the [animal table] ie
Animal: Rabbit
Location: [person table].Town,
Found by: [person table].person,
Postcode: [person table].postcode
Injuries: none etc etc etc
Thank you
Hi Daniel
Thank you for clarifying.
Regarding the editing modal I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
Something like this was never attempted, so I can't even advise how to go on about this. You can take a look at our hooks and filters, and see if there's anything there that can help you out, but other than that I can't help you with this request.
I will forward the idea to our development team, though as I personally believe this is a good suggestion.
We have an integration with Gravity Forms and Formidable Forms which you can use to create new tables that will be updated as new entries are added, but it is impossible to connect an existing table to a form and have it populate new entries.
You can use foreign keys to link two tables but we don't have the auto-fill feature so you would not be able to fill in data automatically if a specific selection is made.