Hello. When creating a google form, and responses go into google sheet. Can that response be automated to upload into another application? Trying to eliminate waste of manually entering in another application. Thanks!

like
Posting as :
works at
You are currently posting as works at

You can do that easily if you generate a link to share the Google sheets (generated by the forms), and use the get data functionality (from web) to convert it into an external connection in excel

That requires you to share the Google sheets with everyone WHO HAS THE LINK, which means for some data, this creates a potential risk. Up to you to evaluate if that's acceptable or not

like

Great! Thank you. I’ll look into.

You can convert a Google Sheet into other formats. So that could offer a possibility. You wouldn't have to re-enter the data, at least. But it all depends on what format or app you're trying to get to. There are also third-party products, like Zapier, that can convert things for you.

like

Thank you! It’s a 3rd party application, which my external process partners don’t have. So now i’m asked 😒🤦🏽‍♀️ to create a google form for them. When I receive the responses I’ll have to copy & paste into the application. So i’m looking to see if the response sheet that collects the information would be able to link to the application and up load the info.

I hope this makes sense

Related Posts

How much will I get in hand after tax deduction??

Need help.

PwC

Post Photo
like

I’ve heard a lot of discussions about is the debt of law school really worth it, but my question is if it’s something you’re really passionate about would you consider steering to a different career path so you wouldn’t go into debt or would you stick it out ?

like

Can folks share their experiences of working during 2nd and 3rd trimesters? How hard was it? What accommodations or adjustments did you make? I’m only in my 1st trimester now but will be starting a new job in October (4 months before my due date) and am nervous about not being able to be at my best

Hi all!

Apologies in advance if this is the incorrect space for this - but my agency - Spark Foundry - is hiring at multiple levels within the analytics team. If you’re interested, private message me. A lot of growth here!

like
like

Don't you think it's high time ppl start calculating in hand salary and how much % hike to ask n all?? I feel that's immatured behaviour when few of them ask these questions 😐
Itna padliya, coding bhi ati h, exp bhi h... Phr kyu??

likefunny

I've lost all motivation in my job and have done maybe 40 hours of real work since the beginning of August. I've built up a good track record the past couple years, and am good at bullshitting so people have been giving me the benefit of the doubt, but know the party can't keep going forever.

like

30th birthday present watch accessory ideas.

A lot of knowledge on here so asking for some help. It’s my partner’s birthday and I’ve no idea what to buy him. He’s a watch fanatic - Pateks (sports and dress), Audemars (sports and dress), Rolex (sports), Omega (sports).

I’m obviously not buying him a watch for his birthday (in his dreams!) but any idea for some good accessories? He’s already got a PP watch winder, and has bought multiple nice straps for the dress watches. I’m completely lost.

like

Does anyone have any suggestions on small side gigs or other ways to make some quick cash for the holidays?

like

Hi fishes,
I'm looking for job change
My skillset - Informatica power center, sql, Unix, Informatica IDQ
EXP - 3.9 years
Notice period - 15 days
Please let me know if there are any vacancy

Busy season has public accountants like

Post Photo
like

what's the best app/site for planning an itinerary? I'd like to list all the things I want to see and be able to plan out the order by day. surely this must exist. tripit seems very manual/lacking.

like

Does anybody have any articles to share or experience working with legal hemp farms?

like

At this time next week, the most awaited F1 press conference of the year will have happened.

Can't wait for next week at Spa.

like
like

I have got an offer based in Boblingen, Germany with 60k euro as fixed. Will it be enough for a couple with a 3 year old kid ? My major expense would be accommodation, groceries, kid’s school and transportation. Please do let me know your valuable inputs. TIA

like

Not trying to matriculate into a top 5 school, but let's talk accredidation. Does an MBA not have weight to it if the school isn't lets say, AACSB accredited but is still accreditated, i.e. SACSCOC?

Hello Mastercard employees. I have been trying to break into MC for long now.

I have 2 yrs workex post MBA. I have experience in data analysis and consulting. But I don't want to get into consulting anymore. I am looking for analytics roles. Anyone here would be able to DM and guide me on the available options at Mastercard?
Location: Gurgaon

like

Hi,

I have submitted docs on 16th October and CTC discussion has been done on 23rd October. No response after that. HR and HR manager bothnot picking the call. How long it will take to release the offer letter?

How much $ do FT mid-level creatives make in Amsterdam?

like

Additional Posts in Excel Genius

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

How do you fix microsoft excel cannot paste data error?

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Would anyone be willing to teach me vlookup?

like

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

How do I compare two sheets to make sure they are identical?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal