formulas – Google Sheets – How can i collect and add values related to a value next to it in a table and add them to another table

I’m using app sheets to see what I do in a day. I select the task i am starting on the app and app sheets dumps the data into a table in google sheets.

I have made an example of what this looks like. Sheet1 is what it looks like At the moment and sheet2 is what I would like it to look like.

I can get the dates in just fine using the UNIQUE function but I’m struggling with the values.

If you have any questions or answers please tell me as I have been pulling my hair out trying to do this.

Tree-structured filter and related table columns

I’m struggling with the logic of a filtering option. In that filter I have multiple roots and nodes (see example below):

root structured filter

The user can interact with the filter and select either an entire root and all its nodes (e.g. Fruit), or just some nodes inside one root (e.g. Apple and Zucchini).

In the table where the selected options will be filtered for, I would like to display roots and nodes in two distinct columns, like so:

enter image description here

The first column (e.g. Groceries category) is the one the user will go check most of the time to have a high overview of the elements in the table, but I don’t know if it makes sense to have two columns for one filter.


How are these two leaky bucket algorithms related?

enter image description here

enter image description here

I am studying about leaky bucket algorithm but I am unable to relate these 2 algorithms

I will do guest post on high DA & PA dofollow seo backlinks on related sites for $10

I will do guest post on high DA & PA dofollow seo backlinks on related sites

Would you like to publish a GUEST POST with a permanent do-follow backlink on a high DA site? Guest posts with permanent backlinks from the website are enough for ranking online!

Is there a reason you should hire me? It’s best to keep it simple. Using best result websites, I will create high-quality backlinks boosting the ranking of your website.

A well-built and organically-trafficked website will also give it good results.


  • Do follow permanent Backlink
  • Guest post on high da site
  • 100% Quality work
  • Real traffic
  • Index guaranteed
  • Boost Ranking
  • High DA/PA
  • Good referring domains

If you have any question, you can contact me


I Will Do 3 Targeted Domain Name Research To Your Targeted Keyword Related for $5

I Will Do 3 Targeted Domain Name Research To Your Targeted Keyword Related

I Will Do Targeted Domain Name Research To Your Targeted Keyword Related


I’m Shathy, a professional Domain and keyword Researcher. I will deliver you Targeted Domain Name and keyword that will help you to rank fastly.

You have to discuss your topics, I will do the rest being created from the mind.

A domain name represents your Business or Brand on the web. So, choosing the best domain is very important.

High authority expired domain may have a lot of broken links and negative history which can be negatively affected SEO. That’s why it is better to buy a new domain.

My service

  • Unique and Creative Name Ideas
  • Search Engine Friendly
  • Easy to Pronounce
  • Rebemberable Domain
  • Professional
  • Brandable
  • Extension Searches are Available for Each ( .com, .org, .net, .info, .shop, .mobi, .co, .web, .site, .live, .app, .edu etc.)
  • No Numbers and Hyphens
  • Easy to Use Excel Sheet
  • Your Data Will Be Safe
  • Reasonable Price
  • Unlimited Revisions
  • Fast Delivery
  • 24/7 Hours Online Support
  • 100% Satisfactions Guaranteed

Any question Just knock me. I will reply.


wp query – Display related CPT with custom taxonomy

I have two custom post types: “storefront_location” and “services”

These are linked by a custom taxonomy “location”

I am building a post template for “storefront_location” and would like to display a listing of the “services” posts associated with any given storefront.

What I’m trying to achieve:

A “storefront-location” post, London, is categorized with “london” (“location” taxonomy).
I would like that London “storefront-location” post to display all “services” which are also categorized with “london” (“location” taxonomy). Users could then click on each service to read about it, since these are post types.

I’m trying to get the taxonomy information of the current post (London) and use tax-query to find all the services that share the same taxonomy with that specific London post.

Note: this is for a WP_query filter in Elementor, so the extra code for the Elementor query is from their tutorial here.

I’m fairly new to this, so there might be a newbie problem here. I’ve been trying to figure this out from other code examples here on stack exchange. I’d appreciate any help!

add_action( 'elementor/query/my_filter', function( $query ) {
//get the storefront-location post's location
   $custom_terms = wp_get_post_terms($post->ID, 'location');

if( $custom_terms ){

    //hold tax query parameters
    $tax_query = array();

    // loop through locations and build a tax query
    foreach( $custom_terms as $custom_term ) {

        $tax_query() = array(
            'taxonomy' => 'location',
            'field' => 'slug',
            'terms' => $custom_term->slug,


    // put all the WP_Query args together
    $args = array( 'post_type' => 'services',
                    'posts_per_page' => -1,
                    'tax_query' => $tax_query );

    // finally run the query
    $loop = new WP_Query($args);

    if( $loop->have_posts() ) {

        while( $loop->have_posts() ) : $loop->the_post(); ?>

        <div class="listing-title"><?php the_title(); ?></div>     
        <?php endwhile;



magento2.3 – magento 2.3 get cart item related to applied cart rule


  • There are 4 products in the cart
  • One of these products causes a cart rule to apply

By getting the cart items via code, I need to be able to identify the one item that is causing the rule to apply.

My problem is that I cannot find a way to separate this item from the others in the cart, they all return the same results.

My code so far:

foreach($quote->getItems() as $quoteItem) {

$itemAppliedRulesId = $quoteItem->getAppliedRuleIds(); // I expect this to  give a result only for the one item that matches the cart rule, instead all the items returns the rule id

$product = $quoteItem->getProduct();
$result = $rule->getActions()->validate($product); // see comment above, same result


My question:

Is there a way I can get the items of the cart that cause one or more rules to apply?

How can I index arbitrarily related entity data in a Search API index the same as if it were an entity reference?

This is possible with custom search_api processors.

First, I created an abstract class to use as a base for the shared functionality. I.e. a method to index arbitrary entity data with a piece of content.

namespace Drupalmy_modulePluginsearch_apiprocessor;

use DrupalCoreEntityContentEntityInterface;
use Drupalsearch_apiDatasourceDatasourceInterface;
use Drupalsearch_apiItemItemInterface;
use Drupalsearch_apiProcessorEntityProcessorProperty;
use Drupalsearch_apiProcessorProcessorPluginBase;
use Drupalsearch_apiUtilityUtility;

 * Base plugin class for indexing arbitrarily related entity data.
 * This can be helpful to index properties of entities referencing an entity or
 * entities related in some other arbitrary way.
 * @package Drupalmy_modulePluginsearch_apiprocessor
abstract class RelatedEntityBase extends ProcessorPluginBase {

   * {@inheritdoc}
  public function getPropertyDefinitions(DatasourceInterface $datasource = NULL) {
    $plugin_definition = $this->getPluginDefinition();
    $properties = ();

    if (!$datasource || $datasource->getEntityTypeId() !== $this->getIndexedEntityTypeId()) {
      return $properties;

    $definition = (
      'label' => $plugin_definition('label'),
      'description' => $plugin_definition('description'),
      'type' => 'entity:' . $this->getRelatedEntityTypeId(),
      'processor_id' => $this->getPluginId(),
      'is_list' => TRUE,
    $property = new EntityProcessorProperty($definition);
    $properties($this->getPluginId()) = $property;

    return $properties;

   * {@inheritdoc}
  public function addFieldValues(ItemInterface $item) {
    /** @var DrupalCoreEntityContentEntityInterface $entity */
    $entity = $item->getOriginalObject()->getValue();

    $to_extract = ();
    foreach ($item->getFields() as $field) {
      $datasource = $field->getDatasource();
      $property_path = $field->getPropertyPath();
      ($direct, $nested) = Utility::splitPropertyPath($property_path, FALSE);
      if ($datasource && $datasource->getEntityTypeId() === $entity->getEntityTypeId() && $direct === $this->getPluginId()) {
        $to_extract($nested)() = $field;

    foreach ($this->getRelatedEntities($entity) as $relation) {
        ->extractFields($relation->getTypedData(), $to_extract, $item->getLanguage());

   * Get an array of related entities.
   * This should return an array of fully loaded entities that relate to the
   * $entity being indexed.
   * @param DrupalCoreEntityContentEntityInterface $entity
   *   The entity being indexed.
   * @return array
   *   An array of entities related to $entity.
  abstract protected function getRelatedEntities(ContentEntityInterface $entity): array;

   * Get the entity type id of the entity being indexed.
   * This is the entity type of the $entity passed to
   * $this->getRelatedEntities().
   * @return string
   *   An entity type id string, e.g. 'node', 'media', or 'taxonomy_term'.
  abstract protected function getIndexedEntityTypeId(): string;

   * Get the entity type id of the related entities.
   * This is the entity type of the items returned from
   * $this->getRelatedEntities().
   * @return string
   *   An entity type id string, e.g. 'node', 'media', or 'taxonomy_term'.
  abstract protected function getRelatedEntityTypeId(): string;


Next, I created plugin classes that extended my abstract class for each case (Collection’s Authors, Article’s Collections, Author’s Collections). For example, to index data from an Article’s Collections as part of the Article’s indexed data:

namespace Drupalmy_modulePluginsearch_apiprocessor;

use DrupalCoreEntityContentEntityInterface;
use Drupalmy_modulePluginsearch_apiprocessorRelatedEntityBase;

 * Index properties from Collections referencing an Article.
 * @SearchApiProcessor(
 *   id = "my_module_article_collections",
 *   label = @Translation("Article's Collections"),
 *   description = @Translation("Index properties from Collections referencing this Article."),
 *   stages = {
 *     "add_properties" = 0,
 *   },
 * )
class ArticleCollections extends RelatedEntityBase {

   * {@inheritdoc}
  protected function getRelatedEntities(ContentEntityInterface $entity): array {
    return my_function_to_get_article_collections($entity)

   * {@inheritdoc}
  protected function getIndexedEntityTypeId(): string {
    return 'node';

   * {@inheritdoc}
  protected function getRelatedEntityTypeId(): string {
    return 'node';


This allowed me to index data from a Collection as part of an Article’s data, for example the Article’s Collection Ids (i.e. the Ids of Collections referencing the Article). I can index any field from the Collection – by selecting the field I want in the UI – the same as if the Article had an entity reference field referencing the Collection. (Note: before you can index any fields with the custom processor, you must first enable it on the Processor tab for your index.)

This all worked great, however, my indexed data did not stay synced with reality. For example, if I added a new Article to a Collection, the indexed data for that new Article would not get updated with information for the new Collection. I.e. the Article was not getting re-indexed if a Collection referencing it was updated. I resolved this with a hook_ENTITY_TYPE_update() implementation that marks dependent Articles to be re-indexed when a Collection is saved.

use DrupalnodeNodeInterface;

 * Implements hook_ENTITY_TYPE_update().
function my_module_node_update(NodeInterface $node) {
  if ($node->bundle() == 'collection') {
    $articles = ();

    // Gather all Articles that this Collection references.
    $articles = my_function_to_get_collection_articles($node);
    // Also gather any Articles that were referenced before this save, but are
    // no longer referenced.
    $original_node = isset($node->original) ? $node->original : NULL;
    if ($original_node instanceof NodeInterface) {
      $articles += my_function_to_get_collection_articles($original_node);

    // Mark the articles to be re-indexed.
    foreach ($articles as $article) {
      /** @var Drupalsearch_apiPluginsearch_apidatasourceContentEntityTrackingManager $tracking_manager */
      $search_api_tracking_manager = Drupal::service('search_api.entity_datasource.tracking_manager');

      $indexes = $search_api_tracking_manager->getIndexesForEntity($article);
      if (!empty($indexes)) {
        $item_ids = ();
        foreach ($article->getTranslationLanguages() as $langcode => $language) {
          $item_ids() = $article->id() . ':' . $langcode;
        foreach ($indexes as $index) {
          $index->trackItemsUpdated('entity:node', $item_ids);

After all of this, I can safely index data from arbitrarily related entities.

arithmetic geometry – A specific Diophantine equation related to the congruent number question

Let $n$ be an odd square free natural number. J.B. Tunnel in his 1983 paper, showed that a number $n$ is congruent, if and only if the number of triples of integers satisfying $2x^2+y^2+8z^2=n$ is equal to twice the number of triples of integers satisfying $2x^2+y^2+32z^2=n$. This is by assuming the BSD conjecture, but still we do not know an efficient (polynomial time) algorithm to determine whether a number is congruent or not, from the theorem stated above.

I am trying to move with this problem a little. A simple observation tells us that, if $(alpha,beta,gamma)$ satisfies $2x^2+y^2+32z^2=n$, then $(alpha,beta,2gamma)$ and $(alpha,beta,-2gamma)$ satisfies $2x^2+y^2+8z^2=n$. So, like this we deduce that if $2x^2+y^2+8z^2=n$ has twice integral solution than $2x^2+y^2+32z^2=n$, then $2x^2+y^2+8z^2=n$ cannot have its integral solution with $z$ odd.

So, now the problem reduces to for what values of $n$, we will have an integral solution of $2x^2+y^2+8(2z+1)^2=n$. If it has a solution then $n$ is not congruent, otherwise it is. Now, I do not know how to proceed any further. As, the equation is not homogenous, one cannot directly invoke Hasse Minkowski’s local global principle, so trying to solve over $p$-adics is not an option. However, if one fails to find solution over $mathbb{Q}_p$ for any $p$ for a particular $n$, then $n$ is congruent. By this, I was able to prove that the numbers $nequiv 5$ mod $8$ and $nequiv 7$ mod $8$ are always congruent, as this type of numbers were failing to give any solution mod $8$ and hence, there was no $mathbb{Q}_2$ solutions. But this will never say whether a number is not congruent.

I do not have any idea to proceed with the problem. Again, the diophantine problem is for what $n$, does $2x^2+y^2+8(2z+1)^2=n$ has integral solutions. Any suggestions or directions to move will be really helpful.

domains – What are the best suitable TLDs for IT related website?

domains – What are the best suitable TLDs for IT related website? – Webmasters Stack Exchange

DreamProxies - Cheapest USA Elite Private Proxies 100 Private Proxies 200 Private Proxies 400 Private Proxies 1000 Private Proxies 2000 Private Proxies 5000 Private Proxies - Buy Cheap Private Proxies Buy 50 Private Proxies Buy 100 Private Proxies Buy 200 Private Proxies Buy 500 Private Proxies Buy 1000 Private Proxies Buy 2000 Private Proxies New Proxy Lists Every Day Buy Cheap Private Proxies; Best Quality USA Private Proxies