We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
We have an "oncall" table that has auto-inc id, empid, from_date, to_date
Example: 12, 103, 2021-06-14, 2021-06,21
We use this to connect to our "employee" table (on empid) to show the name of who is oncall each week.
We'd prefer to NOT copy the employee name into this table but it seems we cannot use editing on the oncall table because of the employee join. Is this not possible? We don't want to do anything to the employee table, just edit the id number in to oncall table.
Table is on our intranet so I cannot share, but here is a visual:
Thanks!
Hi Frank
Thank you for reaching out to us.
If I understand correctly, you have a column connected to another table via foreign key, and you would like to change the ID in the original table that pulls the value form the connected table?
To be able to do this you would need to brake the foreign key relation, and choose the option Read from table on page load, and then make your modifications, then configure the foreign key relation once again.
Just make sure the editing for this column is enabled in the editing tab in the column's settings so you can make the modifications you need
If I misunderstood please explain in more detail so I can get a better understanding and provide you with the best solution.
I am not 100 positive (because I'll need to try this) but I believe you understood me perfectly! Thank you for the advice.
You are most welcome
Do let me know if you need any further assistance, I would be happy to help.
Have a wonderful day!