I have a list of employees linked to my lucidchart via a google sheets file. I’ve created objects linked to each employee. When the employee is removed from the source document I want that object deleted. How do I make this happen?
Solved
How to automate the removal of objects that are deleted from the source csv.
+1Best answer by Leianne C
Hi
I hope this helps! Feel free to let me know if this is not what you are looking for, or if you have any questions.
+24- Lucid Legend Level 10
Hi
There isn’t a native feature to automatically remove objects when corresponding data is deleted from linked Google Sheets or CSV files.
By leveraging the API, you can create a custom script that synchronizes your diagram with your data source, identifying and deleting unnecessary objects.
You can also explore the help article for more thoughts:
Create Diagrams Automatically in Lucidchart | Lucidchart Blog
We also look forward to hearing from other community members and associates, who may have alternative suggestions that could better address your requirements.
Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards
+15Hi
Would you mind sharing more details about your use case (eg. are you creating an org chart)? This will help us better understand and share any potential options to achieve this. Thanks!
+1Sure, I have a huge workforce with craze attrition. It is hard enough to keep the database (excel, csv) current but to have to come back to my org chart or RACI chart or whatever and have to manually remove objects- that is such a pain. It’s hard enough to import them into the object types I want. There has to be some “if not in the list, delete linked object” option.
To automate the removal of objects in Lucidchart when an employee is deleted from the source CSV, you can use a script or automation tool. Set up a script in Google Sheets that detects changes in the CSV file and triggers an update in Lucidchart. This script should identify deleted employees and remove the corresponding objects in Lucidchart. Using Google Apps Script or a similar tool can help streamline this process.
+1To automate the removal of objects in Lucidchart when an employee is deleted from the source CSV, you can use a script or automation tool. Set up a script in Google Sheets that detects changes in the CSV file and triggers an update in Lucidchart. This script should identify deleted employees and remove the corresponding objects in Lucidchart. Using Google Apps Script or a similar tool can help streamline this process.
This sounds great. But I am not at a skill level to implement the theory that you are suggesting. I’m going to need some examples. It sounds like you’re talking about scripting outside of Lucidchart . This isn’t where I think the instruction would belong but, again, I’m gonna need more than what you’ve given me.
+15Hi
I hope this helps! Feel free to let me know if this is not what you are looking for, or if you have any questions.
Create an account in the community
A Lucid or airfocus account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under 18. You will be redirected to the Lucid or airfocus app to log in.
Log in to the community
A Lucid or airfocus account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under 18. You will be redirected to the Lucid or airfocus app to log in.
Log in with Lucid Log in with airfocus
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
