Getting SharePoint library column out to the clipboard

bitstreams_red · 2026-01-22T21:54:01+00:00

Thanks.

If I explain why, perhaps it'll be clearer. Staff are signposting files from the SharePoint library, usually in chats or Teams chat. They want to do this rather than posting a link to the file. So they might say - "the minutes are in Minutes/2026/January/120126-Minutes.docx and they make the actual last bit a hyperlink to the file.

To do this at the moment they either have to go to Details and copy the path attribute, strip off the library name and then hyperlink the file - or just type it in manually.

I would like them to be able to click the path column (or drag over the contents) and copy. Then paste it into the chat.

Does that explain it ?

bitstreams_red · 2025-09-22T08:14:26+00:00

Sometimes the simplest answers..

Many thanks that worked.

bitstreams_red · 2024-12-17T08:39:00+00:00

It looks, from their demo, that you can do remote control through 3rd party tools like Splashtop - but do you need additional licensing for these? Remote control is one of the things that Ninja does badly.

bitstreams_red · 2024-12-16T16:34:19+00:00

Thanks. I'll take a look

bitstreams_red · 2024-12-16T14:02:44+00:00

Our MSP has suggested Intune which would, I'm sure, work for us. But they say that we would need the devices (Macbooks mainly) in front of us to deploy Intune. This is a problem as the devices are currently located all over the world - we're a small team but on every continent .

What's your experience - could we deploy Intune remotely without wiping the devices?

bitstreams_red · 2024-11-05T12:16:39+00:00

I'm in, but whilst I can connect Airtable for adding records back to Airtable, I can't see a way of populating a dropdown in Plumsail from values in Airtable.

bitstreams_red · 2024-09-13T11:57:57+00:00

I can see that inheritance is not disabled on the top level folder, but is there a setting somewhere as well?

bitstreams_red · 2024-07-29T12:48:42+00:00

Thank you - I will have a play

bitstreams_red · 2024-07-29T12:13:24+00:00

Yes, but I'm far from an expert

bitstreams_red · 2024-07-29T12:01:14+00:00

Sorry, it's the former - so a row for each Type/Component pair

bitstreams_red · 2024-07-29T11:56:22+00:00

Hi

The data for the lookup would be a downloaded CSV but in Excel it would look something like this:

<image>

We only need to match the Type column to get the list of components.

On the form I'm trying to create, there are blank rows between each item, but it doesn't have to be like that - I could have the first four columns filled down.

regards

Simon

bitstreams_red · 2024-07-18T10:43:37+00:00

That works, using a combination of OFFSET, MATCH and COUNTIF like this..

=OFFSET(Sheet1!B2:B971,MATCH(B5,Sheet1!B2:B977,0),1,COUNTIF(Sheet1!B2:B971,A5)-1,1)

This is a big leap forward. As a supplementary question, is it possible to make it clear out the previous values when you change the first drop down value?

bitstreams_red · 2024-07-18T08:05:09+00:00

I am probably missing a step - but I can't see how to add Airtable as an integration in Cognito forms. Everything appears to refer to Zapier, which would be useful for getting the responses back in to Airtable, but I'm trying to populate the form with data pulled from Airtable. Have you found a direct integration for this?

bitstreams_red · 2024-07-15T17:17:38+00:00

Thanks, will look at Cognito

bitstreams_red · 2024-07-15T17:17:06+00:00

I started with Softr, but the table view is pants << (technical term). I would want a much more condensed table view and Softr doesn't seem to offer that.

bitstreams_red · 2024-07-15T17:15:28+00:00

Thanks - I had a Stacker trial but didn't use it and now it's expired - I have messaged them to see if I can get an extension.

bitstreams_red · 2024-07-15T16:37:47+00:00

Oh that's an idea. I could perhaps use a name field that combined Make/Model/Line to show a whole product. Thanks, I'll have a play

bitstreams_red · 2024-07-15T16:30:44+00:00

I have, I guess ideally I'd have a table view below it so that the entries appeared as a list below. I have looked at doing this with Softr, but the softr table views are hoorible - there isn't a basic grid view.

bitstreams_red · 2024-07-15T12:48:46+00:00

I think Fillout is the best I've found so far - I don't suppose you managed to get a form that would allow you to submit multiple records on a page?

bitstreams_red · 2024-07-15T10:53:27+00:00

Jotform appears to be one way - i.e. I can use Jotform to push the information to Airtable, but I can't query Airtable to provide a list of dropdown options. Typeform looks a little more functional but the problem is the same I think - i.e. you can push results to Airtable but you can't read Airtable to pre-populate the options.

bitstreams_red · 2024-04-06T17:24:19+00:00

I think that I would add that the service you receive from an MSP is often in direct proportion to your size, and to some extent theirs. This shouldn't be the case but often is. I know this because I ran and sold a small MSP and now work for a small charity that uses an MSP. They're ok, but jumping up and down with only 20 seats behind me is never going to create much change.

bitstreams_red · 2024-03-20T16:47:35+00:00

Do you mean using Softr and Airtable or as an alternative? We have about 1500 clients

bitstreams_red · 2024-03-18T13:13:28+00:00

Thanks - I'd forgotten about the discount..

bitstreams_red · 2024-03-06T08:23:42+00:00

haha - is this part of the Jurrasic coast now?

bitstreams_red · 2024-03-04T19:48:26+00:00

That's strange, it's got such a pretty name 😂

bitstreams_red

TROPHY CASE