Author: eguweb
-
[CF7 Google Sheets Connector Plugin] How to automatically link date and time to columns
The “CF7 Google Sheets Connector” plug-in is useful for linking ContactForm7 x Google Sheets, but if there is no “sent date” in the form item, the sent date and time will not be displayed in the column. So, when I was looking into it, there was a way to add the date and time of…
-
WordPress – How to create an EC site on WordPress by linking BASE products | Part2
Let’s create an EC site by linking BASE products with WordPress. Continuing from the previous session. Click here to create a BASE account Continuing from the previous post (product page created) I was able to create a product page on BASE by the last time! *The product page is created with a page URL such as…
-
[WordPress] How to create an EC site on WordPress by linking BASE products | Part 1
Let’s create an EC site by linking BASE products with WordPress. Click here to create a BASE account What is BASE? Easy to create and open an online shop for free. Anyone, whether an individual or a corporation, can start a business immediately. You can start from the page below. Click here to create a BASE…
-
[WordPress] How to create an EC site on WordPress by linking STORES products | Part2
Let’s create an EC site by linking STORES products with WordPress. Continuing from the previous session. What is STORES? This is an online EC site creation service that allows you to easily create an online shop. You can start from the page below. Click here to create a STORES account Link product pages to external sites Last…
-
[WordPress] How to create an EC site on WordPress by linking STORES products | Part 1
Let’s create an EC site by linking STORES products with WordPress. What is STORES? Open your own online shop for free! In addition to product sales, it is also possible to sell digital content. Fixed cost 0 yen, with reservation sales function, recommended for irregular sales shops! It is a service that allows you to easily create an…
-
![[Spreadsheet] How to dynamically get the last row of a column with data entered](//en.eguweb.jp/wp-content/plugins/a3-lazy-load/assets/images/lazy_placeholder.gif)
[Spreadsheet] How to dynamically get the last row of a column with data entered
This is a method that can be used when you want to know the last row where data is entered. A simple way is the COUNTA function A simple way is to use the COUNTA function. COUNTA – Google Docs Editors HelpReturns the number of values in the dataset. Usage example COUNTA(A2:A100,B2:B100,4,26) COUNTA(1,2,3,4,5,C6:C20) Syntax COUNTA(value1, )…
-
What is “OODA Loop”? Strategic thinking that accelerates business
This time, I will introduce the word “OODA loop”. What is “OODA Loop”? The OODA loop is one of the frameworks and is a “method for making decisions at high speed”. It is an acronym for “Observe”, “Orient”, “Decide” and “Act” . This theory was proposed by Colonel John Boyd of the United States Air Force, and…
-
What is the Center Pin Theory? Terminology to avoid in business
In order to get a strike in bowling, you have to hit the ball without removing the “center pin”. Hit the center pin → get a strike. If the “center pin” is not knocked down, all the pins in a row will not be knocked down. In other words, the theory is that defeating the…
-
[DATEVALUE function] Convenient function to extract serial number from date/time data
You can use the DATEVALUE function to extract the serial number from date/time data. What is the DATEVALUE function? A function that can extract the serial number from date/time data. Example of use: Using the DATEVALUE function For example, you can use it in the following situations. I want to know the serial number from…
-
[OneDrive] How to share saved PDFs so that they can be viewed
For example, one of the services that can be used when you want to share PDF files such as materials so that others can see them is “OneDrive”. What is OneDrive? OneDrive is an online storage provided by Microsoft. It is provided as one of Windows Live and can be used basically free of charge. It is…
-
CSS Specify CSS conditions for English sites and English language.
For example, you can use this CSS when you want to hide XX only on the English version of the site. :lang() The :lang pseudo-class can be used when you want to apply a language-specific style, for example, when lang=”en-US”. The notice-area-wrap is now hidden! It’s visible on the Japanese version of the site! Summary…
-
[GAS] Acquire Google Photos data with Photos Library API and display it on the web page – Part1
I was able to get it using GAS when I wanted to get a list of the data of the images saved in the Google Photos album. That’s the way. It can be obtained by implementing a combination of GoogleAppsScript and Google Cloud Platform. What is Google Cloud Platform? Google Cloud Platform is a cloud computing service provided…
-
[WordPress] How to hide the reCAPTCHA icon
The reCAPTCHA icon is… I think there are many people who have set Google’s “reCAPTCHA” that I introduced before. When reCAPTCHA is set, a badge icon is displayed at the bottom right of the site, but this display overlaps with the “back to top button”. Here is how to hide it with CSS. Normally, it would…
-
What is cost of sales? Calculation method and journal entry method
This time, I will introduce one of the finances, ” Cost of sales (Uriage Genka) “. What is cost of sales? Cost of sales (Uriagegenka) is the cost of purchasing goods and services. In the account item (bookkeeping 3rd grade), the following is the cost of sales. How to find the cost of sales The cost of…
-
[Lightning theme] CSS (WordPress) that displays the logo image in the header even when scrolling
As you scroll down the page in the Lightning theme, the menu (navigation) part appears from above and the menu is fixed. However, the logo image I set for the site is not displayed…. Here is how to adjust. Adjust with CSS Looking at the CSS, the header logo class is hidden when scrolled. [rml_read_more] In…
-
WordPress Speed up page loading speed! a3 Lazy Load plugin
For example, if you put a lot of images and videos on the top page, etc., the page will not load until it is displayed, so it will take time to display the page. The “a3 Lazy Load” plug-in is a convenient plug-in that can solve this problem by Lazy Loading these images and videos.…
-
[iPhone] A convenient application that outputs the screen to a windows PC and displays it in mirroring | LetsView
“LetsView” is a useful application for mirroring and displaying the screen of the iPhone to windowsPC. What is LetsView? LetsView is an application that allows you to mirror your smartphone screen. Conversely, you can display your PC screen on your smartphone. Through multi-platform mirroring technology, LetsView strives to make meetings and education more intuitive, and home…
-
[WordPress] About how to access the management screen and basic operations and mechanisms – Part 1
After installing WordPress, log in to the admin panel. How to log in to the management screen You can log in to the WordPress management screen with the URL address (permalink) /wp-admin/ . If you access this URL, you will be redirected to the login page. You can log in here by entering the username and password…
-
[Google Chrome] How to check CSS :hover and :visited pseudo-element properties with developer tools
When I try to look at the :hover and :visited CSS properties and values in Google Chrome’s developer tools, they are nowhere to be seen. Here’s how to display it. Click :hov There is a notation “:hov” next to Filter in the developer tools. Click here :hov（Force element state） Click “:hov” and there is a place called…
-
[GAS] How to set a time and schedule a post in Chatwork-Part1
This is a method of setting the time in Chatwork and making a reservation post. Chatwork itself doesn’t seem to have scheduled posts (probably?), but you can use GoogleAppsScript to create scheduled posts for Chatwork. Get Chatwork API Token First of all, you will need an API token called “Chatwork API Token”. Get a new API…
-
[WordPress] How to change the administrator email address of WordPress
It is a method and procedure to change the administrator email address of WordPress itself. General Settings → Administrator Email Address WordPress itself has an email address for administrators, separate from the email addresses registered by users. This is how to change the “administrator email address”. Set your new email address First, set a new…
-
[GAS] How to copy a file from a template and create a new one (basic)
For example, if you want to create a new spreadsheet by copying a template file saved in Google Drive. Get folder (.getFolderById) First, get the folder in Google Drive. You can get the folder by using the .getFolderById method. Store this value in a variable. Get File (.getFolderById) You can get the file by using the…
-
GAS Using Slack’s Outgoing Webhook API to Write Posts in Google Spreadsheets｜Part 1
Slack has a convenient API called “Outgoing Webhook” that you can use when you want to “write messages posted to a Slack channel into a Google Spreadsheet. Outgoing Webhooks Outgoing webhooks was a quirky way to send your own server a webhook when messages met a narrow set of criteria. We recommend building Slack apps…
-
[CSS] What is Media Queries? Basics of Responsive Support for Smartphones
This time, I will introduce the basics of responsive support for smartphones in CSS, “Media Queries”. What are Media Queries? Media Queries is “a function to switch CSS according to the displayed screen size “. This is a necessary specification when creating a “responsive web design” that changes the screen design on smartphones and PCs. For example ,…
-
[DaVinci Resolve] How to change the timeline time from 01:00:00:00 to 00:00:00:00
When I created a timeline for DaVinci Resolve, the timeline is set to “01:00:00:00”. Here is how to change it. Set start timecode Right-click on the timeline you want to change the display → Open “Set start timecode”. Change the display of “Set new start timecode” from 01:00:00:00 to 00:00:00:00 and press OK. The timeline time…
-
What is the AND function? Function to check if all conditions are TRUE / Google Sheets
What is the AND function? The AND function is a function that checks whether all conditions are TRUE . How to use the AND function AND(logical_expression1, [logical_expression2, …]) Description Returns TRUE if all arguments are logically TRUE. Returns FALSE if any argument is logically FALSE. Logical Expression1A formula or cell reference that contains a formula that represents a logical value…
-
[What is a domain? ] Basic knowledge of domains
I’m sure many of you have heard the word “domain” before, but what exactly is a domain? I will introduce you to. What is a domain? A domain is simply an address on the Internet. Websites are stored in a location indicated by a number called an “IP address”, and originally we use this IP address to…
-
[WordPress] Convenient plug-in that links covers and entire blocks | EditorsKit
For example, if you have a post block and want to make this block clickable as a single link, you can use the “EditorsKit Plugin”. What are EditorsKit plugins? EditorsKit is a plugin that allows you to extend Gutenberg’s block editor. Provides a set of page building block options and a toolkit for the WordPress…
-
[WordPress]How to add borders to paragraph blocks and columns with CSS
We often talk about “putting borders on WordPress blocks (paragraphs),” and this time we will introduce how to decorate borders with CSS. Let’s add a border. Advanced settings (additional CSS classes) One way is to use a plugin, but in this case, from a maintenance (and later efficiency) point of view, we will use a…
-
[PremierePro] What is In Point (Mark In) and Out Point (Mark Out)? Basics of trimming editing
About “In Point (Mark In) Out Point (Mark Out)” in Premier Pro. If you remember it, the efficiency of editing will increase, so let’s keep it down In Point (Mark In) Out Point (Mark Out) Double-click to open a source loaded into the project panel to display the “source monitor” where you can check the content…
![[Spreadsheet] How to dynamically get the last row of a column with data entered](https://en.eguweb.jp/wp-content/uploads/スクリーンショット-2022-10-03-12.32.43-1024x579-1.webp)
![[WordPress] How to hide the reCAPTCHA icon](https://en.eguweb.jp/wp-content/uploads/スクリーンショット-2022-09-28-8.36.25-1024x751-1.webp)
![[PremierePro] What is In Point (Mark In) and Out Point (Mark Out)? Basics of trimming editing](https://en.eguweb.jp/wp-content/uploads/202208130009-00-1024x620-1.webp)