All Questions

Filter by
Sorted by
Tagged with
-1
votes
2answers
636 views

How to use relative references in an ARRAYFORMULA with DSUM

I have a formula: Total Hours: =DSUM(data!A1:B, "Number of Hours", {"Provider Name";A2}) The column A is a dynamic list of all the providers. How do I use an array formula to fill in all the rows ...
-1
votes
1answer
45 views

Filter but maintain duplicates

I am trying to filter a one larger range from a smaller range. The master range has duplicate entries, however, so when I try to filter from it, it pulls out all duplicates when I'd rather have it ...
-1
votes
1answer
24 views

Why can't I see section B when it appears to be just like sections A and C?

I'm adding sections (not repeating) to my form. I have 3 sections: A, B, C The section name for A and C show up when I click on a field within that section and create a condition for when it will be ...
-1
votes
1answer
53 views

Would Google Sheets LOOKUP recognize 0-50 as 0 through 50?

I was wondering the possibility of an answer to the question in my title. The formula I have is: =LOOKUP(A1, E1:E3, F1:F3) Here, A1 can be any value from say 0 to 1000. E1:E3 contain ...
-1
votes
1answer
66 views

Copy and paste between forms

Is there a way to copy a form field and associated content from one form to another?
-1
votes
1answer
96 views

Is there a way to rearrange columns of repeating sections in the exported CSV file?

I am using Cognito Forms to gather information about my worker's work progress for client billing purposes. They submit one form a day, but each work assignment gets filled out in a repeating section. ...
-1
votes
1answer
206 views

I have two Google accounts, how to verify they are NOT LINKED

I opened a second Google account so I could make a business page years ago. The owner did not believe in social media. But I had a vision and did it. I no longer work there. They want the ...
-1
votes
1answer
121 views

Is there a way to get a confirmation email with a PDF file of a form to the person who completes the form?

My employees will be submitting forms but they may also need to print out the form that they complete. How can this happen?
-1
votes
1answer
376 views

Transposing with header row

In Google Sheets I'm trying to transpose a list of items in rows to display as columns. I am looking for a way to transpose the Category field to act as a header row that extends over all the items of ...
-1
votes
1answer
67 views

Formula for: Run INDEX - Search it for several specified strings - replace them with specified strings

Here is a sample spreadsheet I threw together that shows more or less what I'm working with. I have two sets of two similar formulas that produce INDEX outputs from the same set of data. The first ...
-1
votes
1answer
40 views

How can I change the color of all text colored in (for example) blue in a Google Presentation slides?

How can I change the color of all text colored in (for example) blue in a Google Presentation slides?
-1
votes
1answer
179 views

Split varying number of columns of one row into multiple rows?

Reading the related question Split content of one row into multiple rows? thought you might be able to steer me in the right direction. I am working with data in Google Sheets that I would like to ...
-1
votes
1answer
41 views

Is there a way to have the actual document(s) inserted in place of the file name(s)?

I would like to have the uploaded files included in the PDF. Currently only the name of the file is included.
-1
votes
1answer
99 views

Importing JotForms

I am growing increasingly unsatisfied with the JotForms. While their support is second to none, I am finding some relatively basic features and tasks are difficult to implement without dusting off my ...
-1
votes
3answers
135 views

How to set visibility of Facebook profile likes

How can I setup the visibility of profile photo likes? For example when anyone does not have me in friends, he can´t give me like and I want to anybody can give me like even if he hasn't me in friends....
-1
votes
1answer
100 views

Is there a way to reset to a blank form after submission automatically?

I have a form embedded on my website and I want the ability to have a new form (same form) be filled and submitted multiple times if needed without having to refresh the webpage.
-1
votes
1answer
644 views

Google Apps Script for converting military Timestamp into 12-Hr in Forms submissions?

Has anyone created a script to use in Google Forms/Sheets to convert or display the military time to 12-hour instead once the form has been submitted by a user?
-1
votes
1answer
237 views

How can I calculate the number of minutes?

I have a form with two date fields and two time fields for a timesheet, and want to calculate the number of minutes between. If a job starts in the evening and ends in the morning, how can I calculate ...
-1
votes
1answer
195 views

Redirected URL Submit to new window?

Is it possible to make a redirect URL submit click open in a new window?
-1
votes
1answer
731 views

Dynamic description in Google Forms?

I'm trying to set up a form that can be reused monthly. Questions will be the same from month to month, but with different focus. For instance, a question is named "Marketing". In October I want the ...
-1
votes
1answer
58 views

Do I need an SSL certificate?

Do I need an SSL certificate for my website if I'm using Cognito Forms? My media person is trying to sell me an SSL certificate as Google is going to mark HTML pages with forms as "insecure", but I'm ...
-1
votes
1answer
3k views

How can I protect an Apps Script with triggers and authorizations in a shared Google Sheet? [duplicate]

I have a Google Sheet that is shared via URL. It's a list of events. I wrote a script that syncs the list to a shared Google Calendar. The script has an installable on-edit trigger to update the ...
-1
votes
1answer
276 views

Client Side Events

I'm new at JS (and Stack Exchange) but would love to learn more about the lifecycle of my forms, specifically the multipage activity. I've checked out this page https://www.cognitoforms.com/support/...
-1
votes
1answer
2k views

Turn Facebook place into page

Few years ago someone created Facebook "place" of our company. It's wrong. Now we want to remove it from "places" and keep it as a normal "page". There are two same manuals how to do that, one of them ...
-1
votes
1answer
41 views

Restrict each email address or mobile number to ONE sign up only

Can the email address or the mobile number that sign up user used to register be restricted to SINGLE use? (ie the same mobile number or email address cannot be registered TWICE in same form.)
-1
votes
1answer
506 views

Query a column where numbers are mixed with blanks

I have a query where in a column there are numbers and blanks. It seems that the query function is treating everything in the column as string and not numbers. So when I sort, it doesn't sort ...
-1
votes
1answer
44 views

Reset calculations

I've set up a form to choose either hotel or camping using radio buttons. I then have a dropdown that appears asking how many rooms are required or camping pitches, depending on what radio button is ...
-1
votes
2answers
172 views

Text Characters Calculation

How to calculate numbers of characters in a text box, and to make sure it is not lesser than or greater than a specific amount of numbers?
-1
votes
1answer
45 views

Possible to edit 'Amount Due'?

Is it possible to change 'Amount Due' on the payment to 'Total Cost'? I'm trying to use it so people can work out the total cost of different services, so Total Due doesn't really fit.
-1
votes
1answer
47 views

How to add a signature above post content in Blogspot?

I have searched this in google, but only finds how to add signature below the post content. I want it to appear on the post page and not on the home page. So how to do that?
-1
votes
1answer
140 views

If contains, countifs?

Is there a formula which would allow me to automatically put the answer in the place where it says *answer here * ? For example it analyzes column 2 to see where the Y which would be row 2 and thus ...
-1
votes
1answer
40 views

Authorize payment, collect after

We are looking to use Cognito Forms for online sales, however, instead of collecting the money through Stripe immediately we would like to authorize the payment using Stripe when they submit the form ...
-1
votes
1answer
2k views

What does “&q=%s” mean at the end of a Google search URL?

What does the &q=%s mean (and do) at the end of a Google custom search URL like http://www.google.com/search?q=@@@&tbs=qdr:y&q=%s? Background: I'm using Anysearch Safari Extension (https:/...
-1
votes
1answer
3k views

Conditional formatting with multiple criteria over a range of cells

There is another thread about this but all of the answers there aren't helping. In the range: D12:AY500 - I have a matrix of numbers such that: y=Date, x=Time: .. I would like it so the cells ...
-1
votes
1answer
47 views

Log in form for site

I am looking for a form to use for users to login to a site. Is there a form that can be used as a log-in to a site?
-1
votes
2answers
1k views

How can I search case sensitive online [duplicate]

I'm trying to search online for the string toUri(). Valid result will be Java's Path.toUri() But when I search google it return mostly toURI results. When I search I discover that search engines ...
-1
votes
1answer
240 views

Cannot log in to Facebook Account - No way to contact support

So I can't log in to Facebook and have no way of contacting Facebook support for help - I'm developing a Facebook app using calls to their API for a job/interview test. So, I created the app on my ...
-1
votes
1answer
274 views

Instagram is hacked

Someone has hacked my Instagram account neither my username exist now neither my phone number or my email is getting connected. I tried Facebook it says account does not exist what should I do?
-1
votes
1answer
395 views

Google Spreadsheets formula should I use for highlight more than an 1hour passed between cells?

I need help with a Google spreadsheet formula. This is what I'm trying to do: Highlight the cells in “Conditional Formatting” where the time spent between 2 cells is more than 60min. In this case ...
-1
votes
1answer
155 views

Insert new cell into column B and “shift down” values every-time cell A1 changes in Google Sheets

I'm using Google sheets. I need to automatically add a cell above the existing B1 and shift the values down every-time the value in cell A1 changes. Column "A" is being populated by a google form. ...
-1
votes
1answer
44 views

How do I find a product name from a product key?

How do I get individual labels (names) for different products keys? I want to detect the product key and based on that assign the right product name to it. If it was just one product key in question,...
-1
votes
1answer
35 views

How to fill out the form with desired time rather than time selected from the chart?

I am trying to have the time so that the people who fill out the form can just type the time they want, not select from the chart. How do I do this?
-1
votes
1answer
36 views

Move entry from one form to another

I have a couple of forms where I'd like to consolidate the entries into one. How can I move an entry on one form to another?
-1
votes
1answer
1k views

I turned my spam filter off in Gmail. How do I turn it back on?

When I search Google it only shows how to turn it off.
-1
votes
1answer
375 views

Date difference calculation

I'm looking to find out what formula to use to calculate the difference between two dates and display it in number of days, months, and years elapsed. For example: Today's Date: 6/2/2017 Date of ...
-1
votes
1answer
99 views

Why does Gmail send email from my server to spam?

Gmail sends email originating from my server to spam. I have only sent email to myself. rDNS is setup, SSL encryption is setup. Gmail says: It contains content that's typically used in spam ...
-1
votes
1answer
88 views

Remove blank choice in a drop down field

I'd like to get rid of the very first blank choice that populates all the drop down fields on my form. How do I do that?
-1
votes
1answer
18k views

How can I access my old Yahoo! account? [duplicate]

I want to access my old Yahoo! account but unfortunately the number associated with it no longer in service and there's no way of getting it back. Also I don't have any other email accounts associated ...
-1
votes
2answers
100 views

Question about conditional pricing

In my form, I would like to do the following: https://www.cognitoforms.com/NMA3/Intitulado In the field "ALIMENTOS Y BEBIDAS" (ALIMYBEB) I have several products, each with a value (1 or 2) and a ...
-1
votes
1answer
232 views

What does NaN mean when I'm testing an xpath function in CommCare App Preview

I'm adding several numbers in a hidden value, however I'm seeing the number return as NaN in the xpath tester in App Preview. What does NaN mean in this case?

15 30 50 per page
1
607 608
609
610 611
623