flick

Just an update to this thread: For some reason just clicking on File -> Publish to the Web as suggested by David did not work for me (I still had to login as at Feb 2015 >_<)

However, if “Anyone with the link can view” is enabled, then it is possible to keep the data on Google Sheet/Drive somewhat private, whilst still allowing WP-Cron to do its job via TablePress and import your Google Sheet data.

File -> Share -> Anyone with the link can view

p/s: There is another thread discussing Auto Import that seems to rank higher in search results on the subject, but it is closed to new replies, so hence my response here.

Great! ?? Looking forward to it, thanks!

@bobby: Thanks for the reply. I can understand it being tricky! ??

Just wondering if it might be possible to add a column called “Order” (like the ones used by WordPress posts/pages etc.) to create a custom order instead of alphabetically? Thanks ??

+1 to GitHub suggestion if only for the translation side of things although agree with @promeetee’s list.

+1 for this feature request ??

Just wanted to +1 to this feature request, thanks! ?? As per @bss79 ‘s second last post – some providers do indeed charge a base rate plus incremental per kilo/gram weight thereafter.

Just throwing some ideas into the pot, but Chris Coyier’s review mentioned that David Bushell and Zurb both had the same idea (but different approaches) when trying to keep the first column ‘frozen’ at smaller resolutions https://css-tricks.com/responsive-data-table-roundup/

Probably newer solutions now but in case you decide to investigate thingies ??

Thanks for this thread ?? It helped me with a project for my local sports club – the idea was to maintain an Excel file of fixtures, whereby a match report (if written) was linked to each fixture, but they were generally by different authors.

However, not every match/fixture had a report so although I was able to use JGravesNBS macro, I had to modify it as otherwise it would generate HTML output for every single row. So what it does now (or should) is to skip to the next row if Column F is empty.

I have included the modified macro below the column structure for reference purposes, where ** are the hidden data columns:

Column A: Date
Column B: Home Team
Column C: Score
Column D: Score
Column E: Away Team
** Column F: Match Report (URL)
** Column G: Match Report (Author)
Column I: Match Report

Public Sub HTML()
LastRow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
For I = 2 To LastRow
    If Cells(I, 6).Value <> "" Then
        Cells(I, 8).Value = "<a href=" & Chr(34) & Cells(I, 6).Value & Chr(34) & ">By " & Cells(I, 7).Value & "</a>"
    End If
Next I
End Sub

All I needed to do then was to setup the table in TablePress to hide ** columns F and G from the public and from now on, the person who maintains the site just needs to export as csv and import to replace the table each time.

Hope this helps someone else ?? Thanks again to the peeps before for their contribution.

p/s: I thought about using Automatic URL Conversion, but space is a premium so long post urls alas would not have worked for this setup.
p/s2: I will probably do a full write up on my site at some point with a demo as I also used the Row Filtering extension. Tobias rocks ??

@terriwaslh: Sorry for the late reply. Alas I haven’t worked with this for sometime now but I think I ended up contacting the developer directly (Dave Kiss above) and an update was imminent at the time, which I believe did resolve the issue in the end. However, given this was 7 months ago, your issue might be very different so hope you get it sorted.

@dave: Thanks for your reply here and via email.

@photocrati: Apologies for the late reply and thanks for responding so quickly. I didn’t get a chance to test out the tool in the end, as I ended up having a brief look through (after seeing https://gist.github.com/deltafactory/6789297) and editing the database entry directly (to fix the image urls – decode/re-encode) as well as changing the values under Advance Settings (for the script url)

However, I did this just for Lightbox in my case, but from I understand via Trac, the Reset Tool you mentioned does the same thing so I imagine others will find this useful.

Thanks again for your prompt response here and via email.

@photocrati. Can also confirm the same ‘bug’ on the site I am working on as well. Will send a bug report using the form as advised.

Thanks

Sorry – just an update to say I forgot to style the strength meter in the style.css file, hence I thought nothing was working. Is there way to bring the wp-admin style to the front end easily?

Thanks

Just wondered if the password strength meter is supposed to work on the frontend? It doesn’t for me at the moment but am still testing at present.

Thanks

+1 to responsive capabilities as well ??

Just trying out the plugin for the first time and am really impressed!