colonelblue
asked on
Is there a way to automatically copy table data into a different table when it is submitted?
I'd like to have a table automatically update another table when new data is entered . The tables will have 2 different names but similar fields if not all the same.
Is this possible?
Is there a snippet of code, module, or plugin that can do this?
Thanks in advance.
Is this possible?
Is there a snippet of code, module, or plugin that can do this?
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello experts and thank you for your replies.
The very purpose of why I am trying to replicate data from one table to another is to take advantage of a plugin that uses a zipocde proximity finder.
So how did I get here?
I was required to have an events application working for a site. Everything the Eventlist module can do, including having a calendar module and front-end input/edit form and nice layout.
But what it lacked was a search function based on zip codes (postcodes) which is the top requirement. I found that Sobi2 has a search function based on zip codes AND an extra plugin for it to use as a proximity finder.
Having both installed, the problem now is that they write to two different tables.
I had found a "module" someone made last year apparently from here: http://www.sigsiu.net/forum/index.php/topic,17407.10.html and included the zip if anyone is interested. However it does not work. No events show up in the module and the tables do not seem to see each other.
Now I thought I should just keep Sobi2 and it's handy zip code functions and not use Eventlist but Eventlist has that nifty little calendar and modules that make it so easy for the user.
SO I thought what if a user entered their data into EventList and then have that data replicated into the Sobi2 table? Then I can use both functions.
Again thank you for your expert advice.
mod-sobi2-eventlist.zip
The very purpose of why I am trying to replicate data from one table to another is to take advantage of a plugin that uses a zipocde proximity finder.
So how did I get here?
I was required to have an events application working for a site. Everything the Eventlist module can do, including having a calendar module and front-end input/edit form and nice layout.
But what it lacked was a search function based on zip codes (postcodes) which is the top requirement. I found that Sobi2 has a search function based on zip codes AND an extra plugin for it to use as a proximity finder.
Having both installed, the problem now is that they write to two different tables.
I had found a "module" someone made last year apparently from here: http://www.sigsiu.net/forum/index.php/topic,17407.10.html and included the zip if anyone is interested. However it does not work. No events show up in the module and the tables do not seem to see each other.
Now I thought I should just keep Sobi2 and it's handy zip code functions and not use Eventlist but Eventlist has that nifty little calendar and modules that make it so easy for the user.
SO I thought what if a user entered their data into EventList and then have that data replicated into the Sobi2 table? Then I can use both functions.
Again thank you for your expert advice.
mod-sobi2-eventlist.zip
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I could not figure this out.
In the past I used Fabrick component http://fabrikar.com to make some complexe things this can help you.