Excel to digital asset manager?
Our take
Hi. I have something like 10,000 entries of designs that my company uses all in 8 spreadsheets with multiple tabs of each. This is how they started organizing and tracking designs long before I started working here. However, these spreadsheets are highly unstable as we have multiple users adding to them daily and the legacy spreadsheets have jpgs and not pngs. They often crash, or worse, one user will log a design, inserted as a PNG, along with a few columns of descriptions, and when another user opens the spreadsheet, that entry or multiple entries don't carry over.
We have explored ways to avoid this – turning off autosave did help. But it does keep happening.
It seems that because we have thousands of images, sometimes copied into a cell and not inserted, we need to find a new method to catalogue our work. I tried to set up airtable but it requires manual import of each image. So, I'm wondering if you smart people could recommend a solution, away from Excel, to make something like this work. A paid service, app or platform is fine
Thanks
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Need better way to organise spreadsheethttps://preview.redd.it/oiuewnp0pstg1.png?width=599&format=png&auto=webp&s=d34be7eaeb702d5ded087538a2292a57b295dd65 I am currently keeping track of visiting football stadiums (often called the 72 or the 92) as you can see on the attached image, the shear amount of anfield visits leads to many duplicate entries and am wondering if anyone has a suggestion on tidying this up, so that anfield appears once, but perhaps links through so that i can see all visits there will also likely be more stadiums in the future that will have multiple duplicates. *several columns to the right cropped off because of personal data. submitted by /u/EpilepticFlshbng [link] [comments]
- join content from cells in a column without losing content from the corresponding columns.basically how do i make the highlighted screenshot look like the unhighlighted one but with a function for a spreadsheet with like 170k rows. sorry that this is in sheets. im trying to figure out if what i need is to buy excel basically what i want is to condense duplicative info while listing/joining the different pieces, all controlled for case number. https://preview.redd.it/4rfjrucnjdzg1.png?width=1408&format=png&auto=webp&s=ff424cf0a8553fe30b769986169901c1ca25a3bd https://preview.redd.it/c8mtq58ojdzg1.png?width=1080&format=png&auto=webp&s=21ccbdfd8ae8d41eb2d69368e62163df3737088b submitted by /u/Abi-Ankeney-PMM [link] [comments]
- Making a fillable form with dropdowns and sections that can be added and moved easily**SEE ATTACHED IMAGE** I am attempting to improve this spreadsheet. I have a decent amount of experience with Excel but I am unfamiliar with the terminology require to describe the exact functions I am attempting to implement. The function of the sheet is to log various statuses and information pertaining to ladders and their inspection status. Each workbook has a header section and a footer section to diffentiate between clients. The sections that detail the individual ladders need to be moveable / re-order more easily, and also be able to insert a blank ladder section for any new ladders that come into service. The reason excel was selected is for access reasons. All of our clients use excel, but if there is an objectively better tool for the job that is part of the Office suite that people can use via the web or with their Office licence then I will consider that. Thank you to everyone who is able to provide some insight into this. https://preview.redd.it/7ln3oocpcjvg1.png?width=1405&format=png&auto=webp&s=584525d55bd27779bd56a9d746b5dcc6dd913c70 submitted by /u/WillowDime [link] [comments]
- Image source (file name) from a database exportlol there maybe someone out there that knows the answer… this is a long shot of a post. I apologize if it come across confusing I am trying to figure things out as I go and doing my best 😅 We have a client management platform that we have started to use for all of our documentation including signatures. The downside is for some forms we need the physical copy. I’m able to export all the data (including signatures) and my hope was to use some merge to repopulate the physical forms. A part from what we can export I don’t have the individual image files or a source beyond the spreadsheet. Between Adobe Pro / In design and word they all indicate you need a file source for an image. So I guess … my main question is does an image in an excel cell have a source file if it was just copied and pasted from an online database ? Is there a way beyond individually saving each photos to create a file source ? Edit to add link to an image My example submitted by /u/ktchop2 [link] [comments]