Integrating Google Sheet in forms

quisiera que me ayuden con UN horario laboral de trabajo El cual tienen listas desplegables Tengo UN formato El cual ocupo y quisiera ver si pueden ser con El MISMO formato y que Tenga actualizacion en tiempo real mandare UN link para que pueden ver y ayudarme de como lo quiisiera planter

Hi Mauricio,

Thanks for reaching out to Jotform support. Our Spanish Support agents are busy helping other Jotform users right now, so I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Spanish, let us know and we can have them do that. But, it might take a while until they're available again.

Now, coming back to your question, I checked your account and the link that you provided. It seems that it has the same titles, but your forms do not have any elements or fields. You could achieve the same data saved in the Google Sheet but has different format by integrating it into your form. Make sure that all the columns you have in the Google Sheet has its own field in the form. Let me show you how:

1. In Form Builder, in the orange navigation bar at the top of the screen, click on Settings.

2. Click on Integrations on the left side of the screen.

3. Select the Google Sheets Integration.

4. Now, select or connect your Google account.

5. Click on Create a new spreadsheet.

6. Now, click on Save and you're done.

The form will automatically update when a user successfully submits a form, or modify it. Also, since it has a different format in sheets, it would be best to create a new sheet. Here is my cloned form that you can use as a reference. We also have a guide on How to Clone an Existing Form From a URL that you can check out. If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?

Give it a try and let us know how it goes.

I couldn't understand your explanation very well about how it could look similar or almost the same to the Google link I sent, could we make a schedule from 0?

Hi Mauricio,

Unfortunately, we cannot format the integrated Google Sheet the same as the Google Sheet you provided. The format of the integrated Google Sheet is default and the integration will automatically create each field a column on their own. That means, we cannot create merge a column in the integrated Google Sheet and fill data on it.

As a workaround, we can create a field on each column the same as the Google Sheet you provided. As for the merged column, we can separate them individually. Since your forms are empty, I cloned it and added fields on my cloned form based on the Google Sheet you provided.

You can also share with us the rules or any information that applies in filling out the form, so we can help. Did you also mean by making a schedule zero, is that you want a new record? If yes, we did create a new sheet so it will not contain any data until someone will fill out the form. If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?

Check out my integrated Google Sheet to see my result. You can refer to the previous reply to see on how I integrate Google Sheet on my form.

Once we hear back from you, we'll be able to move forward with a solution.