Categories
User Help

SumProduct Multiple columns using name for column index Vlookup across multiple sheets

I am trying to sum multiple columns from a table on a separate sheet using vlookup and matching the column index number with a name instead of the column number. I can return a single result but can only seem to sum the product of the columns using the array {3,4,5} etc. In one tab […]

Categories
Mastering Development

Google SpreadSheets Anniversary Function With False returned from Empty Cells

I’m trying to make a function that will say True if a cell date has been a year or greater since the current date. The function I used to get this to work is =IF(DAYS360(H8,TODAY()) >= 258, TRUE). The only problem is if a cell is empty it will also show up as True. To […]

Categories
CMS Mastering Development Wordpress

Why does using conditional logic in gravity forms break the form when placed using php

I have a form built using gravity forms… I am placing this form onto my page using PHP like this… // set our form ID ‘Order Checkout’ $form_id = 1; // enqueue the necessary styles and scripts into head gravity_form_enqueue_scripts($form_id,true); … // place my form onto page gravity_form($form_id,false,true,false,null,true); This works nicely and submits nicely… But […]

Categories
Mastering Development

Telegram bot _ wants me to replace word driven menu by a button drive menu

have developed a Telegram bot based on Google web app using JavaScript language reading/writing data from/to Google sheets user types: menu bot sends back a word list for the user to select and type; user types a word, bot receives it, interprets and executes respective command works like a charm! an acquaint wants to add […]

Categories
Mastering Development

Passport.js ‘Unauthorized’ when attempting login

I attempted to integrate Passport.js as authorization for my website, but every time I login with valid user credentials, it return Unauthorized. I have included all the files that contain any passport code, but my project has more files, I hope these won’t interfere with Passport.js at all. app.js const express = require(‘express’); const ejs_express_layouts […]

Categories
CMS Mastering Development Wordpress

How to show the a custom taxonomy term on single post metadata

I have a custom taxonomy called “Sources” (using Custom Post Type UI), where the sources are the names of publications where articles were originally published. Each post is an article, with a source selected. What I need to do is to show the source in the metadata under the post title. I’m using the Avada […]

Categories
Mastering Development

How do I solve this error caused from a Pivot?

When trying to pivot my table – a dynamic one which I can’t define as entries my change can be added or deleted – I receive a fatal error. I used a checked answer from this question and changed it where it was necessary. You will see that I use AVG instead of SUM. SET […]

Categories
Mastering Development

How to convert a ‘states’ object class list to a pandas dataframe?

I am working with the opensky network api: https://opensky-network.org/apidoc/python.html I am calling the api via the python library they’ve created and am looking to turn the object returned into a dataframe. Below is a snippet of what it looks like, how would i go about turning this into a dataframe? from opensky_api import OpenSkyApi import […]

Categories
CMS Mastering Development Wordpress

.widget CSS not working on my website

I am very new to website development. Currently, I’m having trouble making CSS changes to a certain class=”widget”. I want this CSS to work. The CSS is on my main.css file: .widget { list-style-type:none; padding:0; margin:0; } This is part of my functions.php file: // Load Stylesheets function load_css() { wp_register_style(‘bootstrap’, get_template_directory_uri() . ‘/css/bootstrap.min.css’, array(), […]

Categories
CMS Mastering Development Wordpress

Shipping methods in dropdown instead of radio buttons

I have a long list of shipping methods which makes the page look very ugly due to the shipping methods showing up in the radio button. Is there a way to change it from radio buttons to dropdown options? I have tried changing <ul id=”shipping_method” class=”woocommerce-shipping-methods”> <?php foreach ( $available_methods as $method ) : ?> […]