Bienvenido, Invitado

TEMA:

google sheets integration problem 1 mes 3 semanas antes #273748

Mirec
Ausente
Ultimate Breezer
Mensajes: 2676
Karma: 2
Gracias recibidas: 145

Hi,

In the init script of FORM create three-element (Data, Time, Record ID), and in the advanced of the element, please hide all those elements

you can find code for three-element (Data, Time, Record ID) In the init script of FORM

function ff_QuickForm839841140_init()
{
setInterval('test()',500);

setInterval('function1()',500);
} // ff_QuickForm1180771232_init

function test(){

var date = new Date();
	date.setHours(date.getHours());
         month = '' + (date.getMonth() + 1);
        day = '' + date.getDate();
         h=''+date.getMinutes();
 s=''+date.getSeconds();
 if (month.length < 2) 
        month = '0' + month;
    if (day.length < 2) 
        day= '0' + day;
  if (h.length < 2) 
        h= '0' + h;
  if (s.length < 2) 
        s= '0' + s;

   ff_getElementByName("data").value=date.getFullYear()+'/'+month +'/'+day;

  ff_getElementByName("time").value= date.getHours() + ':' + h + ':' +s;

}






function function1()
{
  	
 jQuery.ajax({
                type: "POST",
                
                url: "<?php return JURI::root(true ); ?>/test.php",
                data: 'test',    
                success: function(data) {

        ff_getElementByName('recordid').value=data;

           
      }
});

}

Please do not forget to change the names of elements into code, you can do it in these pieces of code

ff_getElementByName('recordid').value=data;
ff_getElementByName("data").value=date.getFullYear()+'/'+month +'/'+day;

ff_getElementByName("time").value= date.getHours() + ':' + h + ':' +s;

function ff_QuickForm839841140_init() -> add name of FORM instead 'QuickForm839841140'

For the IP addresses of the user, please create one text element and then hide him and add this code in the value of the element

<?php return $_SERVER[REMOTE_ADDR];?>

when you get all values in the elements, then in the gdata connect they in the sheet (do not forget to create a row in the sheet for all those elements).

Please download->unzip->and install it (BF->Configuration->Package Installer->select this xml file->Install Package).

In the zip file I sent one PHP file which is necessary to insert in the Joomla root, the file name is 'test'

It is all please test this and let me know!

Regards,
Mirko

Adjuntos:

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Última Edición: Post by Mirec.

google sheets integration problem 1 mes 3 semanas antes #273850

midomni
Fuera de línea
Junior Breezer
Mensajes: 28
Gracias recibidas: 0

Any updates on the final fixed version of this plugin?

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

google sheets integration problem 1 mes 3 semanas antes #273854

Mirec
Ausente
Ultimate Breezer
Mensajes: 2676
Karma: 2
Gracias recibidas: 145

Hi,

Any updates on the final fixed version of this plugin?

not yet, but I can solve it, I have another solution, let me know and I will help you!

Regards,
Mirko

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

google sheets integration problem 1 mes 3 semanas antes #273871

midomni
Fuera de línea
Junior Breezer
Mensajes: 28
Gracias recibidas: 0

Looking for a final solution not a temporary fix. My sheets are very complicated with formulas and the band-aid solutions are not working. This is going on 8 months now and I have super pissed clients especially because I'm trying to give a fix timeline and its just not happening. Looking like a fool here! Is there possibly a drop dead timeline that can be shared and met?

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

google sheets integration problem 1 mes 3 semanas antes #273890

Mirec
Ausente
Ultimate Breezer
Mensajes: 2676
Karma: 2
Gracias recibidas: 145

Hi Midomni,

Looking for a final solution not a temporary fix. My sheets are very complicated with formulas and the band-aid solutions are not working. This is going on 8 months now and I have super pissed clients especially because I'm trying to give a fix timeline and its just not happening. Looking like a fool here! Is there possibly a drop dead timeline that can be shared and met?

This will be finished in a month at most two because I working on more things at the same time and I need time for all.

This problem has a solution, and it does not matter how much is FORM complex, if you want to send me the backend data and the name of all your FORMS I will adjust this for all.

I do not see the reason that you do not use gdata, and why you awaiting a new version.

I'm here that help you all, you only need to send the data and the name of the FORM and I will adjust it all!

I have couple more problems to solve on gdata because Google is again changing some things with security policy and it requires adjusting gdata workflow.

I have a lot of jobs on gdata and I will solve all, it is not the problem.

For us, currently is most important that currently, the plugin gdata works and that we can use him for our needs.

I'm sure that by the end of August we'll have a new version gdata plugin with all news.

If you have more questions, feel free to ask, I'm here to answer all your questions!

Let me know!

Regards,
Mirko

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Última Edición: Post by Mirec.

google sheets integration problem 1 mes 3 días antes #274482

gary3890
Fuera de línea
Junior Breezer
Mensajes: 58
Gracias recibidas: 0

Hi Mirec,

Is there somewhere a guide about how to install the latest temporaryy solution with the app files?

And when the final solution will be here, will it be easy to put everything on the final plugin or do we have to install everything all over again?

Por favor, Identificarse o Crear cuenta para unirse a la conversación.