Bienvenido, Invitado
Recordarme

TEMA:

google sheets integration problem 1 mes 3 semanas antes #273748

  • Avatar de Mirec
  • Mirec
  • Ausente
  • Ultimate Breezer
  • 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

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

  • Avatar de Mirec
  • Mirec
  • Ausente
  • Ultimate Breezer
  • 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

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

  • Avatar de Mirec
  • Mirec
  • Ausente
  • Ultimate Breezer
  • 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

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.

Moderadores: ForumSupport
Tiempo de carga de la página: 0.090 segundos