+ Reply to Thread
Results 1 to 9 of 9

Help with a button to transfer data.

  1. #1
    Registered User
    Join Date
    04-03-2022
    Location
    Sulphur, LA USA
    MS-Off Ver
    Office 365
    Posts
    5

    Help with a button to transfer data.

    Can this be done?

    I have a google sheet “form” that I need to take the information someone imputes and with the push of a button, the script will transfer the data from the form and place it in a row on another sheet and then clear the form to make ready for a new entry. Each time new data will be transferred, the button will add it to a new row.
    Can the script do this in a button?

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Help with a button to transfer data.

    Hi rdaughdril and welcome to the forum on #2 post.

    I recorded a macro in Excel and will give you the attached back that does what you wanted. I have no idea how to do this in Google Sheets.
    Here is the VBA Code (not optimized) and the workbook with VBA in Excel.
    Please Login or Register  to view this content.
    Copy Form to LastRow Transpose in VBA.xlsm
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Help with a button to transfer data.

    A Google Form could easily send the data to a Google Sheet. Have you considered that option?

    example-form.jpg
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  4. #4
    Registered User
    Join Date
    04-03-2022
    Location
    Sulphur, LA USA
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Help with a button to transfer data.

    What you suggested would be perfect. I have not worked with Google forms so I'm not very familiar with the process. The reason for the Google sheets form is that the submitter will be getting their data from a Google Sheet to fill form the form. I have mutable agencies that will be submitting the form data from their own Google Sheet and I will be compiling the data into one central Google Sheet.

    Thanks for all the help.

  5. #5
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Help with a button to transfer data.

    the submitter will be getting their data from a Google Sheet to fill form the form
    Im confused what you mean.
    Why does a user need to get their own information from a google sheet and then enter it again?

    I have mutable agencies that will be submitting the form data from their own Google Sheet and I will be compiling the data into one central Google Sheet
    Why do you need separate google sheets?
    A single google form can be shared with everyone and then all the data will be on 1 google sheet, or you can create copies of the form (one for each agency) and then all the data will be on their own agency google sheet.

  6. #6
    Registered User
    Join Date
    04-03-2022
    Location
    Sulphur, LA USA
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Help with a button to transfer data.

    Here is a more in-depth explanation of what we are trying to accomplish.

    A provider has all their data pre-loaded in the spreadsheet.
    Upon activation, they choose a unit and crew member to be on that unit.
    They do this by the use of a Google Sheet that is in a form format.

    ****Here is where I need help***
    The form uses a lot of look-up fields from the spreadsheet to complete the form.
    What I need the form to do is that the different fields that they have submitted and compile their form data on a new row to a "Total Data" sheet. They will have numerous units and crews.

    We share this data with the provider/state/contractor.

    Again, thanks for all the help.

  7. #7
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Help with a button to transfer data.

    Ok, as you need a form to lookup fields, a Google Form can not do that in the way you have explained it.

    So you would need to:
    * create an Apps Script
    * create a drawing (the button)
    * attach the Apps Script to that button
    Whenever you press the button, the data will be "transfered" (using getValues and set Values) to the location defined in the Apps Script.

  8. #8
    Registered User
    Join Date
    04-03-2022
    Location
    Sulphur, LA USA
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Help with a button to transfer data.

    How do I make the movement of data of the form go to the last row of my data and choose that row to add all my data?

  9. #9
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Help with a button to transfer data.

    You will need to create/write an Apps Script.

    To get started, on the toolbar, select Extensions then Apps Script

    Screen Shot 2022-05-02 at 2.35.17 am.png

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] data transfer from one sheet to another with button
    By majidsiddique in forum Excel General
    Replies: 15
    Last Post: 04-19-2019, 09:00 AM
  2. Button to transfer data from one sheet to another, new row each time
    By BroBanKata in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-25-2019, 10:34 AM
  3. Transfer Data according to Radio Button and Checkbox
    By 323100N in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2018, 02:59 AM
  4. Macro for button won't transfer data to another sheet
    By titchroberts in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-16-2017, 10:37 AM
  5. Button Macro to transfer data.
    By Corogrin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-03-2016, 02:22 PM
  6. Button to transfer data to another sheet
    By maRGas in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-22-2012, 06:23 PM
  7. VBA macro for button to transfer data from one sheet to another.
    By coolhit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2009, 02:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1