TOPIC:

google sheets integration problem 4 months 1 week ago #272096

  • silvio
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 13
  • Thanks: 0
first time with google account is goes wrong
ask for a new authorisation code

there will be 2 access you need to enabled

Select what mirko BreezingForm can access

1) See, edit, create, and delete all of your Google Drive files. Learn more
2) See, edit, create, and delete all your Google Sheets spreadsheets. Learn more

then you would have the correct Authorization code

Please Log in or Create an account to join the conversation.

google sheets integration problem 4 months 1 week ago #272106

  • Mirec's Avatar
  • Mirec
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 2952
  • Karma: 2
  • Thanks: 150
:lol:

Please Log in or Create an account to join the conversation.

google sheets integration problem 4 months 1 week ago #272134

  • Mirec's Avatar
  • Mirec
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 2952
  • Karma: 2
  • Thanks: 150
Hi,


this problem who is connected with ordering values in the sheet row,
For these users who use a solution with the sign '-' as values in an element, I have another solution that users can not see the sign '-' in the front of the site.

the solution is :

Step 1.

In the properties of the FORM in the section 'Include submit button' set to 'NO'.

step 2.

please, on the end of FORM create one submit button, and in the Advanced of the button, in the section 'Actionscript' select type custom, Action 'Click' and click on the 'Create code frameworks
In the code box, in the code between code line 'case' and 'break'
function ff_nameofButton_action(element, action)
{
    switch (action) {
        case 'click':

Insert code 

            break;
        default:;
    } // switch
} // ff_bfQuickMode9938012_action


add this code below :

var elem = document.getElementById('ff_form1').elements;
var counter;
for(var i = 0; i < elem.length; i++){
if(elem[i].id.substring(0,7) == 'ff_elem' && elem[i].value == '' ){
if(elem[i].type=='text'){
elem[i].value="-";
}
if(elem[i].type=='textarea'){
elem[i].value="-";
}
if(elem[i].type=='number'){
elem[i].value="0";
}

}
}

ff_submitForm();


Required changes in the code:

- var elem = document.getElementById('ff_form1').elements; -> in the 'ff_form1' instead '1' add ID of the FORM!

-The ID of the FORM you can find in the database in the table '_facileforms_records`' row 'form' on the based row 'name' we can find the corresponding ID of FORM.

With this solution, you do not need more setUp sign '-' in the values of type elements 'TextElement', 'Textarea', 'Calendar', 'Responsive Calendar', 'number', and you can wipe sign '-' in all of the elements, not to be showen of the frontend of the site!

You can try this solution and let me know if you have a problem adjusting your FORM to this solution!

Have luck! :)

Regards,
Mirko




Attachments:

Please Log in or Create an account to join the conversation.

Last edit: Post by Mirec.

google sheets integration problem 4 months 11 hours ago #272579

  • seppi
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 86
  • Thanks: 1
Dear Mirko

Thanks for staying on the case :). Are there any news yet about the correct distribution of fields to the spreadsheet columns (without workaround)? Our customer loves his spreadsheets so it would be great to get it connected to BF properly again ...

Thanks!

Please Log in or Create an account to join the conversation.

google sheets integration problem 4 months 11 hours ago #272588

  • sursumweb
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 4
  • Thanks: 0
Hi Mirco,
will be available again the options for date, ip, user, etc? I test the last version, but it doesn't.
Thanks

Please Log in or Create an account to join the conversation.

Last edit: Post by sursumweb.

google sheets integration problem 4 months 11 hours ago #272590

  • Mirec's Avatar
  • Mirec
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 2952
  • Karma: 2
  • Thanks: 150
Hi,


did you see my previous comment!

On that solution FORM works perfectly, only you need to spend a couple of mins to adjust your FORM! If you need help, I will do it for you! :)

Currently, I worked on another plugin, which isn't working and I didn't have time to solve it all, another plugin was been a priority because it is broken and needs to be fixed, while the sheet order working using this alternative!

In a short time, I will solve this problem!

Please let me know!


Regards,
Mirko

Please Log in or Create an account to join the conversation.

Moderators: ForumSupport
Time to create page: 0.099 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

September Discount!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!