Formül Sütunu Hakkında

Merhaba, forma eklediğim formül sütunu Google Sheets entegrasyonunda görünmüyor. Entegrasyonu kaldırıp yeniden tanımlamama rağmen görünmedi. Nasıl çözebilirim? Yardımcı olabilir misiniz?

Hi Operations Top Ten,

Thanks for reaching out to Jotform Support. Unfortunately, our Turkish Support agents are busy helping other Jotform users at the moment. 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 Turkish, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

Now, let me help you with your question. Unfortunately, only the form fields and the columns shown in the integration menu can be sent to the Google Sheets integration.

While the feature you’re looking for isn’t currently available, rest assured we’re always working to add new services and features to Jotform. 

I've gone ahead and escalated your request to our Developer Team. When or if it's developed depends on their workload, how viable it is, and how many other users request it. If there are any updates, we’ll circle back to this thread and let you know.

As a workaround, you can send the data if you can use the Form Calculation Widget to perform calculations directly on your form. This is a solution that can be applied only if the calculation can be done directly on your form for each submission. In this way, the calculated values will be counted as form fields and could be passed to Google Sheets. You might want to check out this guide about How to Perform Form Calculation Using a Widget 

Give it a try and let us know if you need any other help.

Hi Joseph,

It's totally fine. Thank you for your quick response. Actually, we want this feature only to use the trim function and maybe some text editing before passing the data to Google Sheets. As of my understanding, it's currently not possible.

Having the raw data in Google Sheets is crucial for our business, so the Form Calculation Widget can not solve this problem unfortunately.

Please let me know if there is any update on this.

Thank you for your support.

Tolga