Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 20, 2021 11:46 AM
Hi,
I have a team with multiple departments. I want all my departments to be able to edit and update Contacts from their respective bases. Is there a way to do this?
Thank you.
Solved! Go to Solution.
Sep 22, 2021 04:36 AM
Are you using a synced table for contacts? Users cannot directly edit synced values in the synced table.
If users have edit access to the original table in the original base, you can include an “open source record” button that will open the original record in its original base for editing.
If users do not have edit access to the original table in the original base, you can use a prefilled form and automation script workaround to get updates to the original data.
Sep 22, 2021 03:41 AM
Hi,
There a many ways to achieve your goal, depending on your purpose.
Use sync to move data between bases and assign rights up to your needs.
If you want to restrict departments from access to some ‘Main base’, i would suggest to create another base for Contacts, open access for them and sync data from ‘Contacts’ to ‘Main’.
If you need to restrict them from each other, you need to set up multiple syncs.
Sep 22, 2021 04:36 AM
Are you using a synced table for contacts? Users cannot directly edit synced values in the synced table.
If users have edit access to the original table in the original base, you can include an “open source record” button that will open the original record in its original base for editing.
If users do not have edit access to the original table in the original base, you can use a prefilled form and automation script workaround to get updates to the original data.
Sep 30, 2021 07:58 AM
This sounds like a good idea Kouvonne. Do you happen to have the script for this?
Best,
Karim
Sep 30, 2021 07:59 AM
Thanks Alexey. I’ll be doing this for now. I just wish we can find a way to contribute to the main base using the sub base.
Sep 30, 2021 12:08 PM
I have written scripts that do this for clients. Each script needs to be customized to the exact base. There are also some limitations: prefilled urls have character limits, rich text fields have limitations, and attachment fields need special handling, etc. If you have budget to hire a script writer and would like to discuss options, feel free to book an appointment with me.