So I am working on a site that has multiple tables on different pages. What I want to do is be able to pull information in from one table to another but only be able to do it one time. So if I select "1" then I won't be able to select 1 again but have options of selecting unused data.
I would also like to change the color of the original table where the data is being pulled from once it has been selected.
2. Creating the second table using SQL query, where you could configure the query to select the data from a separate table.
I don't believe you'd be completely safe on the side of pulling the data only once. if you use Foreign Keys, and configure it so Show Column shows the actual number "1", and set Value From "wdt_ID" - you would only have one number associated to an auto-increment wdt_ID column, but there's no limitation as to how many times a value from the same row can be pulled.
I am sorry to disappoint you, but unfortunately using Foreign Keys is not possible when you create tables from Gravity Forms. They are available with Formidable Forms, but the tables created from Formidable Forms are not editable.
Also, adding manual columns in gravity based tables is not possible, since the table isn't being stored in our database, but is actually linked to Gravity's database - therefore you cannot create a manual column because all manual columns would have to be stored in our database.
So I am working on a site that has multiple tables on different pages. What I want to do is be able to pull information in from one table to another but only be able to do it one time. So if I select "1" then I won't be able to select 1 again but have options of selecting unused data.
I would also like to change the color of the original table where the data is being pulled from once it has been selected.
Is this able to be done?
hi :),
I am litle good at wpdatatables.
For color the you have to make it again.
Hello Brandon.
To be able to pull info from one table into another you have two options:
1. Pulling the information using Foreign Keys
2. Creating the second table using SQL query, where you could configure the query to select the data from a separate table.
I don't believe you'd be completely safe on the side of pulling the data only once. if you use Foreign Keys, and configure it so Show Column shows the actual number "1", and set Value From "wdt_ID" - you would only have one number associated to an auto-increment wdt_ID column, but there's no limitation as to how many times a value from the same row can be pulled.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Is there a way to use a foreign key when using the gravity form submission? Or adding a new manual column to a gravity form data table?
Hello again Brandon.
I am sorry to disappoint you, but unfortunately using Foreign Keys is not possible when you create tables from Gravity Forms. They are available with Formidable Forms, but the tables created from Formidable Forms are not editable.
Also, adding manual columns in gravity based tables is not possible, since the table isn't being stored in our database, but is actually linked to Gravity's database - therefore you cannot create a manual column because all manual columns would have to be stored in our database.
Sorry for the inconvenience.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables