Any web wizards out there?

razil

Hi gang

I want to put a small database, 500 records, might grow to a few thousand, online in a web page.

Nothing fancy, and performance not an issue, anyone know a simple way of doing this - links etc?

Needs to be searchable, and viewable of course

I understand it may be doable via a google sheet. I'm kinda looking for something free and out of the box, and limited amount of coding - I understand that may be a big ask of course.

any assistance most gratefully received.

R

i_b_b_o_r_g

Hi gang? Wtf

Fiiish

Pornhub already has a feature for saving your favourite videos.

razil

a collection of web wizards is grammatically known as a 'gang', silly

bbob

razil said:

a collection of web wizards is grammatically known as a 'gang', silly

I thought the collective of web wizard was Virgins.

Rob62

If you're OK with simple, a basic wordpress setup with the wpdatatables plugin linked to a google sheet would do what you're asking: https://wpdatatables.com/

razil

Rob62 said:

If you're OK with simple, a basic wordpress setup with the wpdatatables plugin linked to a google sheet would do what you're asking: https://wpdatatables.com/

Cheers Rob, not sure I'm willing to fork out $44 though.. altho there does seem to be a lite version

SheedyCAFC

razil said:

Rob62 said:

If you're OK with simple, a basic wordpress setup with the wpdatatables plugin linked to a google sheet would do what you're asking: https://wpdatatables.com/

Cheers Rob, not sure I'm willing to fork out $44 though.. altho there does seem to be a lite version

What about forking out £31.65?

Stu_of_Kunming

razil said:

Rob62 said:

If you're OK with simple, a basic wordpress setup with the wpdatatables plugin linked to a google sheet would do what you're asking: https://wpdatatables.com/

Cheers Rob, not sure I'm willing to fork out $44 though.. altho there does seem to be a lite version

Surely with all that free advertising you get, $44 is a drop in the ocean

razil

Never had any return on CL 'advertising'.. It seems you need to have WordPress business to install plugins.. $25 a month, chuff that. Appreciate the advice tho.

LoOkOuT

That's hosted Wordpress, there's an open source, free version you can install on your own server.

razil

Server being the main issue there for me.

Dazzler21

Is anyone any good with spreadsheets able to help me? 

I have a spreadsheet I am working on,

I have two tables, one for every game we have played this season and one for collective player stats (I do not intend to infringe on the statbank with this btw) 

Table one looks like this: 


Table two like this: 


Now my problem is that Goals Scored column in sheet 2. I am using the COUNTIF Formula to highlight the whole goalscorers column and provide a count of cells with "*Aneke*" in. But Aneke being a good scored two goals against Rochdale... How do I count that extra goal if it's already in a cell that contains his name once? 

Actual formula used

=COUNTIF(I3:I49, "*Aneke*")

Is there a way to count instances of Aneke as opposed to cells containing Aneke or Washington who also scored two vs Fleetwood?

ForeverAddickted

Just did a quick search @Dazzler21

I struggle to translate formulas without testing them first but is something like this what you want?

https://docs.microsoft.com/en-us/office/troubleshoot/excel/formulas-to-count-occurrences-in-excel

Dazzler21

Thanks FA but I'd have to have a cell for every game for every player for that code to work. Tried it last night.

As I said to Ali, I think I may have to change the format a bit.

thai malaysia addick

I'll write you a macro, @Dazzler21, that does what you want if you send me the spreadsheet. Send me an inbox. I'm assuming you have a full Windows version of Excel.

Dazzler21

I'm on Google sheets sadly! 

thai malaysia addick

Dazzler21 said:

I'm on Google sheets sadly! 

Damn.

cafcpolo

=SUM(LEN(range)-LEN(SUBSTITUTE(range,"text","")))/LEN("text")

?