The "No Dev Question is Stupid" Thread - Basic HTML / CSS / Etc.

Ryuzaki

女性以上のお金
Staff member
BuSo Pro
Digital Strategist
Joined
Sep 3, 2014
Messages
3,911
Likes
7,439
Degree
8
@JasonSc, I think defer only defers the execution of the script but not the downloading of it.

I'd try async instead and see if that helps. At least this way the rest of your resources can keep downloading.

Otherwise there's more advanced deferring methods you can use that require more code though.

If this is a script you're inserting into the HTML yourself, you can try to manually defer it by moving it to the footer and "truly" defer it.
 
Joined
Mar 25, 2019
Messages
34
Likes
41
Degree
0
We migrated to Jotforms (not my choice) and these forms are stupid large and are slowing things down. 300KB and 6 server calls for a simple contact form.

As much as I want to use something else I can't, again not my choice. I would like the form to delay loading until after the dom is complete.

This is the code jotform provides:
Code:
<script type="text/javascript" src="https://form.jotform.com/jsform/1111111111"></script>
I tried this and it doesn't work:
Code:
<script defer src="text/javascript" src="https://form.jotform.com/jsform/1111111111"></script>
This is for Wordpress sites and the form is on every page of the site.
Put the line at the bottom of the page. It'll load after the body is loaded.
 
Joined
Apr 7, 2016
Messages
291
Likes
190
Degree
1
Any idea on dumping a MySQL table into Google Sheets automatically?
You could use the JDBC google apps scripts to do it. Try something like this: https://stackoverflow.com/questions/42208721/how-to-connect-google-sheets-to-database

I use Supermetrics which I believe uses the same connection. But it's very straightforward, plug in in the database connection, put in your SQL and go. It will notify you if anything fails. The frequency in which you need to refresh the data on a schedule may determine whether this is the right route for you, pricing goes up for daily and hourly.
 

bernard

BuSo Pro
Joined
Dec 31, 2016
Messages
756
Likes
574
Degree
2
@ryandiscord Are you happy with Supermetrics and what do you use it for?

I forgot about them, but considering now. I think they could help me with my "battle station" setup to understand what's going on across multiple sites.
 
Joined
Apr 7, 2016
Messages
291
Likes
190
Degree
1
I'm very happy with it, I've been using it for years doing reporting. I use it to collect unsampled data from Analytics (weekly increments). I primarily use the Google Analytics, Google Ads, Bing Ads, and Database connectors.

I use the MySQL connector to combine internal data with traffic data to create sort of a closed loop reporting system.

For multiple sites you can select several accounts in Analytics and pull them all in on one query, which can save you some time stitching things together in Google Sheets.