Google Forms/ Sheets – Web Applications Stack Exchange

Taking into consideration the little info you give, I imagine that if your response sheet (Form Responses) looks something like this:

|      Timestamp      | Last name | First name |           Email           | Steps |
| 2020-10-19 23:25:51 | Boc       | Florencia  |         |   356 |
| 2020-10-19 22:33:29 | Boc       | Florencia  |         |   175 |
| 2020-10-19 19:58:08 | Splevins  | Donny      |       |   153 |
| 2020-10-19 18:40:52 | Castagne  | Cedric     |          |   382 |
| 2020-10-19 17:56:40 | Gipp      | Eloisa     |          |   147 |
| 2020-10-19 17:26:39 | Splevins  | Donny      |       |   365 |
| 2020-10-19 17:09:17 | Riccardi  | Monica     | |   289 |
| 2020-10-19 17:07:08 | Boc       | Florencia  |         |   284 |
| 2020-10-19 16:54:45 | Gipp      | Eloisa     |          |   174 |
| 2020-10-19 14:20:50 | Riccardi  | Monica     | |   233 |
| 2020-10-19 14:02:00 | Splevins  | Donny      |       |   173 |
| 2020-10-19 09:51:38 | Riccardi  | Monica     | |   177 |
| 2020-10-19 04:49:03 | Splevins  | Donny      |       |   320 |

If so, you then need to create a new sheet and place the following QUERY formula i cell A1

=QUERY('Form Responses'!A1:E, 
    "select B, C, sum(E) where A is not null group by B, C ",1)

(Please adjust ranges to your needs)

enter image description here

If still in need please let us know.

WordPress5.5 Gravity Forms not sending email by wp_mail works

I have a WordPress 5.5 based website and gravity forms installed. My issue is when people use my gravity forms I am not getting any email notification. I tried putting different emails in and even downloaded a plugin called “check email” and used that to send myself a test and it says email sent but I never receive it and even checked my spam folder.

If I create a basic php file and put a php mail() tag in with my info I receive the email although it goes to my spam folder. Also if I add a hard coded wp_mail() tag with my email info hard coded in the footer.php file of my wordpress site I also receive that email although it goes to my spam.

Wondering if anyone know how to view an error log for Gravity forms?

forms – Can a 2-column grid of info be acceptable if it mitigates an awkwardly large amount of white space?

enter image description here

I’m in the middle of a psuedo-overhaul of my company’s platform, with an emphasis on “object-level” pages (ie the page for an individual task, or individual appointment).

A problem I’m running into is that the info for many of these pages is laid out in a two-column format (see pic), which I know any competent ux designer will tell you is bad for scanning. But while combining both columns into one single left-aligned column might improve scannability, it would also leave just a gaping void of whitespace on the right portion of the page. I can’t really articulate any ux code this violates beyond just looking ridiculous and stark, but it still seems like an issue worth surfacing.

Any thoughts on this? I want to follow best practices but I also would like to preserve a sense of visual balance and appeal.


web development – what is the next step after learning and building forms and databases

I am trying to shift my career into software. I have been doing self education mostly using YouTube videos. I have understood how form submission works and how a server accepts the data from form submission and saves it in a database. i taught myself crud operations and creating a rest API server that writes and reads to/from a database. what would be beneficial to my learning next ? what should i focus my efforts on ?

forms – UX pattern for implementing calendars

In my recent development I am required to implement a calendar view which is having month view for each month for given date range. See below.

enter image description here

I have already done the programming part. It is required allows users to select all Sundays, all Mondays, all Tues days etc.. The existing swing UI like this. (Hope this will help to get an idea) see below.

enter image description here

As you can see both Sundays and Tues check boxes are selected and marked in calendar as well. Calendar days are are not clickable and only the check boxes can be selected.

Pure idea is to allow users to selected week/end days and see them on calendar view. Calendar days are not clickable. First thought came to mind is implementing the same behavior as given above for web UI as well.

Hope you all thoughts on this.


sharepoint online – How to get Query String Value in Powerapps forms

I need to get the query string values from the URL in powerapps.

i.e I have an SP list with Customized powerapps forms, if i pass the value in the URL like “

I should able to get that CompanyName value and CompanyID value in powerapps forms. I tried Param(CompanyName) method but didn’t get the value from query string.

Is there any solution to get the parameter value from query string in Powerapps.

Thanks in Advance!.

iis 7.5 – Protect static file on Asp Net Classic Mode with Forms Authentication

i’m struggling to resolve this issue since yesterday.

I have a site (framework 4.0), hosted in a Windows Server with IIS 7.5 in Classic Mode.
Unfortunately i can’t changed this to Integrated Mode.

I need to protect files contained in a folder.

Only authenticated user (with forms authentication) have to access to them.
anonymous user not.

I tried to protect folder in this way in webconfig:

<location path="Riservata/Files">
          <deny users="?" />

But i can access to these files (pdf), direct.
Instead i want to a redirect to the loginpage.

Someone can help me?

nt.number theory – Set of Quadratic Forms that represents All Primes


Any prime number can be classified as either $p equiv 1 pmod 3$ or $p equiv 2 pmod 3$.

If $p = 3$ or $p = 1 pmod 3$, then the prime $p$ can be represented by the quadratic form $ x^2 + 3y^2, x,y in mathbb Z.$

But what if $p equiv 2 pmod 3$?

Is there a quadratic form $ax^2+bxy+cy^2$ such that $p= ax^2+bxy+cy^2, $ when $p equiv 2 pmod 3$ where $x,y, a, b,c in mathbb Z$?


The general question is, is there a set of quadratic forms which represent all prime numbers?

We will classify the prime numbers, say, by $m$. Any prime is defined by $p equiv i pmod m$ where $1 leq ileq m-1$.

In above example, $i in {1, 2}, m=3$. Let, the set of quadratic forms is $A$, then the number of elements in $A$ is $(m-1)$.


For a given $m$ can we find a set $A$ such that any prime $p$ can be represented by one of the quadratic form of $A$ ?

If it is possible then how? If there is a condition on $m$, what is it?

Does the question has any relation to the following theorem ?

enter image description here

One can answer only the specific case, if he wishes.

plugins – How to dynamically generate multiple forms from a Template, based on user input?

I write to the community with the hope that someones can show me the correct way to solve my issue.

I’m trying to create a simple plugin that should generate multiple contact forms from a Form Template and save the data in to the WordPress Database.
The user should have the ability to choose (from the admin area) which fields to display in the form and then, through a Shortcode, the form will be displayed in the Frontend.

The Code I have is working for a unique form, but the goal would be to generate and save multiple forms to the database (not sure I should create a new table, or use an existing WP table). Then, to each form, a Shortcode would be dynamically assigned – eg: (contact_form id = “1”), etc. The generated data would then be displayed as a list table in the admin area, and the user should have the ability to add, update, and delete the generated forms.
I’ve heard about shortcode_atts() function; WP_List_Table Class, Form Tables, and Custom Post Types, but I’m not really sure how can I solve this issue.

Maybe someone can guide me in finding the proper way to deal with this issue, following the WordPress standards?

Thanks in advance!

Add menu page


 * Plugin Name: Generate multiple contact forms from Form template

function create_admin_pages (){
      add_menu_page( "Top Menu Page" ,"Top Menu Page", "manage_options", "top_menu_page", "top_menu_page_content_callback" );

            add_submenu_page( "top_menu_page", "General Options", "General Options", "manage_options", "top_menu_page", "top_menu_page_content_callback");
add_action( "admin_init", "create_settings" );
add_action( "admin_menu", "create_admin_pages" );

Top menu page callback function


function top_menu_page_content_callback()
    <div class="wrap">
    <form method="POST" action="options.php">
    <?php settings_fields( 'settings_group_1' );    
    do_settings_sections( 'top_menu_page' );

The settings API

function create_settings(){

register_setting( "settings_group_1", "contact_form_FirstName" );
register_setting( "settings_group_1", "contact_form_LastName" );
register_setting( "settings_group_1", "contact_form_Email" );
register_setting( "settings_group_1", "contact_form_Phone" );

add_settings_section( "section_2", "Contact-Form", "section_2_callback", "top_menu_page");

add_settings_field( "contact_form_FirstName", "First Name", "contact_form_FirstName_setting_callback","top_menu_page", "section_2" );
add_settings_field( "contact_form_LastName", "Last Name", "contact_form_LastName_settings_callback","top_menu_page", "section_2" );
add_settings_field( "contact_form_Email", "Email", "contact_form_Email_setting_callback","top_menu_page", "section_2" );
add_settings_field( "contact_form_Phone", "Phone", "contact_form_Phone_settings_callback","top_menu_page", "section_2" );


Settings Callback functions


function contact_form_FirstName_setting_callback(){

       $contact_form_FirstName = esc_attr( get_option( 'contact_form_FirstName' ) );
       echo '<input name="contact_form_FirstName" id="contact_form_FirstName" type="checkbox" value="1" class="code" ' . checked( 1, get_option( 'contact_form_FirstName' ), false ) . ' />  ';

function contact_form_LastName_settings_callback(){

       $contact_form_LastName = esc_attr( get_option( 'contact_form_LastName' ) );
       echo '<input name="contact_form_LastName" id="contact_form_LastName" type="checkbox" value="1" class="code" ' . checked( 1, get_option( 'contact_form_LastName' ), false ) . ' /> ';

function contact_form_Email_setting_callback(){

       $contact_form_Email = esc_attr( get_option( 'contact_form_Email' ) );
       echo '<input name="contact_form_Email" id="contact_form_Email" type="checkbox" value="1" class="code" ' . checked( 1, get_option( 'contact_form_Email' ), false ) . ' /> ';

function contact_form_Phone_settings_callback(){

       $contact_form_Phone = esc_attr( get_option( 'contact_form_Phone' ) );
       echo '<input name="contact_form_Phone" id="contact_form_Phone" type="checkbox" value="1" class="code" ' . checked( 1, get_option( 'contact_form_Phone' ), false ) . ' /> ';

function section_2_callback(){
      echo "Check the fields you would like to add to your form. <br> ";

The Form Template

//Template form Section

function custom_shortcode()

<form action="" method="POST">
    $contact_form_FirstName = get_option('contact_form_FirstName');
    if ($contact_form_FirstName == '1')
        echo '<label for="first_name">First Name</label><input  id="first_name" maxlength="40" name="first_name" size="20" type="text" required/><br>';

    $contact_form_LastName = get_option('contact_form_LastName');
    if ($contact_form_LastName == '1')
        echo '<label for="last_name">Last Name</label><input  id="last_name" maxlength="40" name="first_name" size="20" type="text" required/><br>';

    $contact_form_Email = get_option('contact_form_Email');
    if ($contact_form_Email == '1')
        echo '<label for="email">Email</label><input  id="email" maxlength="80" name="email" size="20" type="email" required/><br>';
    $contact_form_Phone = get_option('contact_form_Phone');
    if ($contact_form_Phone == '1')
        echo '<label for="phone">Phone</label><input  id="phone" maxlength="40" name="phone" size="20" type="text" required/><br>';
<input type="submit" name="submit">

add_shortcode('contact_form', 'custom_shortcode');