Clinics Medicann UK

[Scriptoh]

Yeah, I hear you bro, I had to result to some "black magic" to get it working as I have. I'm investigating right now but I'm not optimistic when it comes to exposed API's or databases, I haven't done this myself in almost a decade so I'm rusty to say the least. Also I don't want to mes without prior permission, you know...
security wise .. yeah

script-src * 'unsafe-inline' 'unsafe-eval'

This effectively disables XSS protection, so not so great in the first 2 minutes. not talking about Medicann here... Scriptassist is to blame as they have a white label sort of deal. I will not push this further tho .. I'm out of the game for a reason and I need my good night sleep


I'm making changes and changes and changes ... somebody stop me please

Ive attached an auto sort to the script for the spreadsheet, auto deletes “do not prescribe” rows aswell + expands columns + sorts the vapes and oils so they all appear together at the bottom of the list

No more manually selecting things tabling etc

 

[Scriptoh]

Getting right back into this, made this one myself this morning using gpt as assistant

 

[Co4ie]

@Scriptoh don't get ahead of yourself and me .. I've already sorted and created the tables. you know where to find me, join the fun..

 

[Scriptoh]

@Scriptoh don't get ahead of yourself and me .. I've already sorted and created the tables. you know where to find me, join the fun..

Ah i shouldve known ill be back about 4-5 ill link up with u then if ur still about

 

[Scriptoh]

Thought i was giving you some rest byte by doing the wee sort additions at the end, youve went way above and beyond my expectations once again

 

[Scriptoh]

MediCann Formulary - Spreadsheet Edition

Right folks we done it were now up and running fully automated

 

[LostInANewWorld]

MediCann Formulary - Spreadsheet Edition

Now up and running fully automatically

It would be great to be able to filter or sort by price or to have the Indica/Sativa/Hybrid in a separate column to filter on, too (this could be achieved with a RIGHT() or by delimiting with the pipe (|) character.

Other than that, it looks great.

 

[Scriptoh]

It would be great to be able to filter or sort by price or to have the Indica/Sativa/Hybrid in a separate column to filter on, too.

Other than that it looks great.

Ill consider adding that thanks for the input

 

[LostInANewWorld]

Ill consider adding that thanks for the input

How are you collating the data from Medicann? Web scraper?

 

[Script Advisor]

How are you collating the data from Medicann? Web scraper?

can't really say exactly how it was done sorry

 

[Script Advisor]

What I can say is that all the material listed is publicly available to any Medicann patient so from that standpoint nothing has changed, simply been reformatted etc to be more appealing/readable

 

[Scriptoh]

Massive thanks to @Stefan he made this all possible if im totally honest

 

[Tominator]

MediCann Formulary - Spreadsheet Edition

Right folks we done it were now up and running fully automated

Well done chaps

 

[TastyTerpTester]

Very nice work guys, thank you! Makes life much easier. I agree it would be nice to be able to sort by price.

 

[Script Advisor]

Very nice work guys, thank you! Makes life much easier. I agree it would be nice to be able to sort by price.

I'll add a price sorted list to every page flower, oil & vapes

 

[Script Advisor]

I'll also highlight;

Indica's
Sativa's
Hybrid's

With some sort of colour coding probably similar to above so you can quickly gauge what each strain is

Just writing it here so I don't forget to do it

 

[Script Advisor]

If anyone has anymore suggestions that I may have forgot/not thought about please fire away

 

[TheGreenAvenger]

Tell you what folks Medicann have got some real technical wizards for patients!

Fantastic work by all involved with regards to the automated spreadsheet, gone straight into my bookmarks!

Keep it up everyone, your efforts aren't going unnoticed!


www.thegreenavenger.uk

Different variant available on my website above, search function available, coloured classification of products, irradiation status, stock indicator and sortable columns so you can display from low to high etc, just click the 3 dots on each column header and you can sort by ascending or descending.

Any mistakes please feel free to let me know, baked out my cap doing it so there may well be some errors.

 

[Scriptoh]

Tell you what folks Medicann have got some real technical wizards for patients!

Fantastic work by all involved with regards to the automated spreadsheet, gone straight into my bookmarks!

Keep it up everyone, your efforts aren't going unnoticed!


www.thegreenavenger.uk

Different variant available on my website above, search function available, coloured classification of products, irradiation status, stock indicator and sortable columns so you can display from low to high etc, just click the 3 dots on each column header and you can sort by ascending or descending.

Any mistakes please feel free to let me know, baked out my cap doing it so there may well be some errors.

Fantastic haha everyone is going to town on these sheets, love it

 

[TheGreenAvenger]

Fantastic haha everyone is going to town on these sheets, love it

All because the ScriptAssist app is awfullllll for conveying information!