New filters on the Home Feed, take a look!
view details

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

4
How can I automatically reference a table/Excel spreadsheet in an attribute?
Post Flair (click to view more posts with a particular flair)
Post Body

I hope I am explaining this right, but I have a drawing with multiple field devices. For instance, security cameras. We have a spreadsheet where all of these names, IP addresses, etc. are laid out. We want a way to automate when we place an icon on the floor plan that has an attribute field (or multiple), it can ask us where to get the information for that field. In our case, it's in a table that is in the same drawing, which in turn has a datalink to a spreadsheet.

Example: We place a camera icon, and then it will prompt us to enter the table field location (let's say B2) for that camera. Then if that spreadsheet gets updated with a new name, it will automatically correct the attribute on that icon. We place another icon, and it asks us again, we pick B3, and so on. Bonus if we can pick multiple fields from the table for all the information. Example: we place an icon, Name comes from B2, IP address comes from C2, Patch Panel comes from D2, etc.

Comments
[not loaded or deleted]

Can you explain what you mean by Associate the Files

[not loaded or deleted]

OK, I got that part, and the table will update, but how do I have an attribute in a block reference that same data?

Author
Account Strength
100%
Account Age
13 years
Verified Email
Yes
Verified Flair
No
Total Karma
123,975
Link Karma
15,949
Comment Karma
107,822
Profile updated: 1 day ago
Posts updated: 2 months ago

Subreddit

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
8 months ago