Tag: false

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

Post author By How To
Post date April 2, 2020
No Comments on 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 […]

Tags 'P&L by job'!$A$1:$E$1, 'P&L by job'!$A$2:$E$4, 'P&L by job'!$A$2:$E$4{2, 0, 0) The issue is when an additional column is added, 0) This formula will result in the sumproduct: =IFERROR(SUMPRODUCT(VLOOKUP(($A2&""), 3, 4, 5} etc. In one tab I have my data (simplified for this example) Data In another sheet I want to show the totals for Fred and Bob and Betty, false, 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 o, I need to change the column index number in my spreadsheet. Is there a better approach? Many thanks, MATCH(A2, or the columns are in a different order each time I import the data across

Mastering Development

Google SpreadSheets Anniversary Function With False returned from Empty Cells

Post author By Full Stack
Post date March 31, 2020
No Comments on 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 […]

Tags but got 1) How can I make the cell show up as True if its been 365 days or more and False if the cell is empty or less than 365 from the cel, but if the date was within the same year it seemed to work. If the function was last year but still less than 365 days it showed up as #N/A (, Expected 0 arguments, false, FALSE))) This didn't really work, FALSE))). Cell with N/A Value with date value from previous year Cell with False value with date value from current year Cell with N/A val, 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 ge, TODAY()) >= 258, TRUE(AND(H7 = "", TRUE) =IF(DAYS360(H7, TRUE). The only problem is if a cell is empty it will also show up as True. To fix this I tried doing this: =IF(DAYS360(H7

CMS Mastering Development Wordpress

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

Post author By Marcia D.
Post date March 31, 2020
No Comments on 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 […]

Tags all the conditional logic fields are visible and the conditional logic doesn't work. Absolutely no console errors. Any ideas why I might be, but for some reason on #gform_wrapper_1 it has style="display:none;" applied to it. If remove the inline style, false, 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' $, null, true, true); ... // place my form onto page gravity_form($form_id, true); This works nicely and submits nicely... But then when I apply conditional logic to a field, which validates and saves ok. The output on the page is this... Form appears missing. But in the inspector you can see all the scripts/styl

Mastering Development

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

Post author By Full Stack
Post date March 30, 2020
No Comments on 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 […]

Tags "false" ); } function menu( chat_id ) { var sResponse = "main menu\n\n"; sResponse += "admin : group admins\n\n";, "Telegram Bot Update", [{ text: 'Some button text 2', [{ text: 'Some button text 3', $html, 10 ) === "BRASILEIRO" && text.length === 10 ) { brasileiroSubMenu( chat_id ); } else if ( sUpperText.substr( 0, 13 ) === "CARIOCA JOGOS" && text.length > 7 ) { cariocaLeagueGameReport( chat_id ); } else if ( sUpperText.substr( 0, 14 ) === "CARIOCA TABELA" && text.length > 7 ) { cariocaLeagueTableReport( chat_id ); } else if ( sUpperText.substr( 0, 14 ) === "PATROCINADORES" ) { sponsorsReport( chat_id ); } else if ( sUpperText.substr( 0, 16 ) === "BRASILEIRO JOGOS" && text.length > 10 ) { brasileiroLeagueGameReport( chat_id ); } else if ( sUpperText.substr( 0, 17 ) === "BRASILEIRO TABELA" && text.length > 10 ) { brasileiroLeagueTableReport( chat_id ); } else if ( sUpperText.substr( 0, 4 ) === "MENU" ) { menu( chat_id ); } else if ( sUpperText.substr( 0, 4 ) === "TEST" ) { sendFormattedMessage( chat_id, 4)); var chat_id = contents.message.chat.id; var text = contents.message.text; var name = contents.message.from.first_name + " ", 5 ) === "ADMIN" ) { adminReport( chat_id ) } else if ( sUpperText.substr( 0, 5 ) === "SQUAD" ) { squadReport( chat_id ); } else if ( sUpperText.substr( 0, 7 ) === "CARIOCA" && text.length === 7 ) { cariocaSubMenu( chat_id ); } else if ( sUpperText.substr( 0, acquaint wants me to replace word driven menu by a button drive menu have conducted some research on Telegram Bot API, bot receives it, but could not find a very easy explanation how to achieve the above; have implemented 2 JavaScript functions, but sadly both are not working source: Add clickable buttons to telegram-bot function sendReplyMarkupMessage( chat_id, callback_data: '1' }], callback_data: '2' }], callback_data: '3' }] ] }) }; sendReplyMarkupMessage( chat_id, false, have developed a Telegram bot based on Google web app using JavaScript language reading/writing data from/to Google sheets user types: menu, interprets and executes respective command works like a charm! an acquaint wants to add this bot to a Telegram group and requested to chang, JSON.stringify(contents, name ) { var sUpperText = text.toUpperCase(); var sResponse = " "; if ( sUpperText.substr( 0, name ); } function telegramBotMachine( chat_id, null, options ); } it appears this code line does not work??? var response = UrlFetchApp.fetch(vUrlTelegram + "/sendMessage?chat_id=" + ch, reply_markup ) { var encodedText = encodeURIComponent(text); var response = UrlFetchApp.fetch(vUrlTelegram + "/sendMessage?chat_id, sResponse, test, Text, the bot identify it and executes a respective command in summary, user types: menu bot sends backs 8 buttons; each button corresponds to an action when the user touches one of the buttons

Mastering Development

Passport.js ‘Unauthorized’ when attempting login

Post author By Full Stack
Post date March 29, 2020
No Comments on 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 […]

Tags 'ejs'); //Bodyparser express_app.use(express.urlencoded( { extended: false } )); express_app.use(passport.initialize()); express_app.use(pa, 'errors'], (req, { message: 'Password doesnt match user.'}); } }) .catch() }) ); passport.serializeUse, { message: 'Username not found.'}); } if(password == user.password) { return done(null, { successRedirect: '/movie_main_page' })(req, { useNewUrlParser: true, }); } else { //Registration successful User.findOne({ username: username}) .then(user => { if(user) {, }); } else { const new_user = new User ({ username, $username, but every time I login with valid user credentials, but my project has more files, console.log(`SERVER START PORT: ${port}`)); users.js const express = require('express'); const router = express.Router(); const passport =, done) { User.findById(id, done) => { done(null, done) => { User.findOne({ username: username }) .then(user => { if(!user) { retur, false, function(err, I attempted to integrate Passport.js as authorization for my website, I hope these won't interfere with Passport.js at all. app.js const express = require('express'); const ejs_express_layouts = require('expre, it return Unauthorized. I have included all the files that contain any passport code, next) => { passport.authenticate("local", next); }); module.exports = router; passport_auth.js //Authentication method = local const local_strategy = require('passport-local').Stra, PASSWORD, password } = req.body; let errors = []; //Check fields for correct input if (!username || !password) { errors.push({ msg, password }); new_user.save() .then(user => { res.redirect('../users/login');, require('./routes/index')); express_app.use('/users', require('./routes/users')); //PORT to run app const port = 5000; express_app.listen(port, res) => { const { username, res) => res.render('login')); //Register page router.get('/register', res) => res.render('register')); //Register handler router.post('/register', res); }); }, user.id); }); passport.deserializeUser(function(id, user) { done(err, user); } else { return done(null, user); }); }); } I can't seem to figure out where it goes wrong with the authentication. Any help is appreciated!, useUnifiedTopology: true}) .then(() => console.log("Connected to database: " + data_base)) .catch(err => console.log("ERROR:" + err)); //EJS

CMS Mastering Development Wordpress

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

Post author By Marcia D.
Post date March 29, 2020
No Comments on 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 […]

Tags '', '' . $author_post_link . '' ); } $metadata .= '|'; } else, '' . $author_post_link . '' ); } else { /* translators: The au, 'Avada'), $date_markup, $formatted_date ); } else { $date .= fusion_render_rich_snippets_for_pages( false, $title_size ); // phpcs:ignore WordPress.Security.EscapeOutput ?>, and hook it before the date or after the author name. But I'm not sure how to do that. All I see in the theme's single post file file is: <, false, false ); } // Render the updated meta data or at least the rich snippet if enabled. if ( $settings['post_meta_date'], I have a custom taxonomy called "Sources" (using Custom Post Type UI), I'm not sure what other info I need. Any help will be much appreciated! Keep in mind I'm very amateur at this., month, render just the invisible author rich snippet. $author .= fusion_render_rich_snippets_for_pages( false, source, true, true ); } Other than this, true ); $formatted_date = get_the_time( fusion_library()->get_option( 'date_format' ) ); $date_markup = '', 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 theme. Currently th, Year Here's an example post I'm working with in my dev environment: http://dev.universaltheosophy.com/articles/the-logos-and-meditation/ I, Year What I want is this: Article Title Author Name

Mastering Development

How do I solve this error caused from a Pivot?

Post author By Full Stack
Post date March 28, 2020
No Comments on 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 […]

Tags `category` int(16) NOT NULL COMMENT 'school_or_job', `city` varchar(64) NOT NULL, `comp_id` int(32) NOT NULL, `country` varchar(16) NOT NULL, `end_date` date DEFAULT NULL, `option_id` int(64) NOT NULL, `poll_id` int(64) NOT NULL, `position` varchar(64) NOT NULL, `question_id` int(64) NOT NULL, `state` varchar(16) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `user_id` int(64) NOT NULL, `usr_id` int(32) NOT NULL, `vote_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, ' FROM gs_poll_answers gspa LEFT JOIN skill_cv_test sct ON sct.usr_id = gspa.user_id WHERE gspa.poll_id = 1 GROUP BY gspa.question_id'); PRE, './themes/pmahom...', ''', '1812apmy', 'country', 'gs_poll_answers', 'option_id', 'SELECT\r\n\tGROUP_...', 'tbl_sql.php', 0, 1, array, boolean given, called in /usr/local/dh/web/phpmyadmin/libraries/classes/Sql.php on line 1908 and defined in /usr/local/dh/web/phpmyadmin/libraries/classes/S, country ) ) INTO @sql FROM (SELECT gspa.question_id AS question_id, description text, except of the idea that it can't handle the Join in the "From". Is my code the problem, false, gspa.option_id AS option_id FROM gs_poll_answers gspa LEFT JOIN skill_cv_test sct ON sct.usr_id = gspa.user_id WHERE gspa.poll_i, is it the server or anything else? EDIT: Create Tables for skill_cv_test CREATE TABLE `skill_cv_test` ( `id` int(11) NOT NULL AUTO_INCREME, null, NULL) #2 /usr/local/dh/web/phpmyadmin/import.php(736): PhpMyAdmin\Sql->executeQueryAndGetQueryResponse(Array, NULL) #3 {main} thrown in /usr/local/dh/web/phpmyadmin/libraries/classes/Sql.php on line 143 For the moment I have no idea what the problem, NULL)) AS ', Object(PhpMyAdmin\Display\Results), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8 and gs_poll_answers CREATE TABLE `gs_poll_answers` ( `id` int(11, sct.country AS country, sql, start_date date NOT NULL, 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

Mastering Development

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

Post author By Full Stack
Post date March 28, 2020
No Comments on 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 […]

CMS Mastering Development Wordpress

.widget CSS not working on my website

Post author By Marcia D.
Post date March 28, 2020
No Comments on .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(), […]

Tags 'all'); wp_enqueue_style('bootstrap'); wp_register_style('main', 'all'); wp_enqueue_style('main'); } add_action('wp_enqueue_scripts', 'content');?> I feel like I just missed something, 'load_css'); // Load Javascript function load_js() { wp_enqueue_script('jquery'); wp_register_script('bootstrap', 'load_js'); This is my page.php file:, array, but as I said, false, get_template_directory_uri() . '/css/bootstrap.min.css', get_template_directory_uri() . '/css/main.css', get_template_directory_uri() . '/js/bootstrap.min.js', 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 { lis, I'm very new to WP website development so I don't know where to look. Any help is very much appreciated. Thank you!, jQuery", true); wp_enqueue_script('bootstrap'); } add_action('wp_enqueue_scripts'

CMS Mastering Development Wordpress

Shipping methods in dropdown instead of radio buttons

Post author By Marcia D.
Post date March 27, 2020
No Comments on 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 ) : ?> […]

Tags $chosen_method, $index ); ?> to, checked( $method->id, esc_attr( $method->id ), esc_attr( $method->id ) ); // WPCS: XSS ok. } // printf( '%3$s', esc_attr( sanitize_title( $method->id ) ), false, false ) ); // WPCS: XSS ok. } else { printf( '<input type="hidden" name="shipping_method[%1$d]" data-index="%1$d", 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 the, index, method, wc_cart_totals_shipping_method_label( $method ) ); // WPCS: XSS ok. do_action( 'woocommerce_after_shipping_rate'