Is there a way (maybe using one or more of your hooks / filters) to synchronise user-editable tables between multiple users?
I have a page where users can create a table of values. When a user updates their table, I basically want the values to be kept in sync with a linked user's instance of that table.
I have a mapping of the user IDs so I know which users should be kept in sync, and obviously the uid is one column in the table. I just don't know how to trigger the update of the linked users' tables when one user makes an update to theirs.
You can create a manual table, which would contain a "User ID" integer column. If I understood correctly, you want the table to be editable for all users, now I don't know if you want them to View And Edit Only Own Data, or simply edit the table while seeing all data in it. If it's the latter, you can add the %current_user_id% placeholder as a predefined editing value, and hide that field from the entry modal, so they can't change it.
Then, you would create an SQL query-based table that would be filtered with the %CURRENT_USER_ID% placeholder, so this would be the second table - in sync (basically the same table, but filtered differently). If we didn't understand correctly, please explain in more detail, and maybe provide some examples if possible.
Is there a way (maybe using one or more of your hooks / filters) to synchronise user-editable tables between multiple users?
I have a page where users can create a table of values. When a user updates their table, I basically want the values to be kept in sync with a linked user's instance of that table.
I have a mapping of the user IDs so I know which users should be kept in sync, and obviously the uid is one column in the table. I just don't know how to trigger the update of the linked users' tables when one user makes an update to theirs.
Hope that makes sense.
Hi Adam
Thank you for reaching out to us.
You can create a manual table, which would contain a "User ID" integer column. If I understood correctly, you want the table to be editable for all users, now I don't know if you want them to View And Edit Only Own Data, or simply edit the table while seeing all data in it. If it's the latter, you can add the %current_user_id% placeholder as a predefined editing value, and hide that field from the entry modal, so they can't change it.
Then, you would create an SQL query-based table that would be filtered with the %CURRENT_USER_ID% placeholder, so this would be the second table - in sync (basically the same table, but filtered differently). If we didn't understand correctly, please explain in more detail, and maybe provide some examples if possible.