Attention: Please take a moment to consider our terms and conditions before posting.

Any web wizards out there?

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

Comments

  • a collection of web wizards is grammatically known as a 'gang', silly
  • edited February 2018
    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/
  • edited March 2018
    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
  • 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?
  • edited March 2018
    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 ;)
  • edited March 2018
    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.
  • That's hosted Wordpress, there's an open source, free version you can install on your own server.
  • Sponsored links:


  • Server being the main issue there for me.
  • 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?


  • 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


  • 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.
  • 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.
  • I'm on Google sheets sadly! 
  • Dazzler21 said:
    I'm on Google sheets sadly! 
    Damn.
  • edited February 18
    =SUM(LEN(range)-LEN(SUBSTITUTE(range,"text","")))/LEN("text")

    ?
Sign In or Register to comment.

Roland Out Forever!