Preloading elements in the fabrik form

[crchaves]

Hello, formerly a member of Fabrik, has supported me with this query. He did the following:

insert into the cpanel 2 files

public_html/components/com_fabrik here user_ajax.php

public_html/components/com_fabrik/js here form_11.js


form_11 = Formulario mercado producto (id= 11)

attached images of the contents of the form

in the group precio producto. precio minimo, precio maximo, precio mas frecuente and observaciones, You do not need to preloaded these fields

anyone knows this and can help me, my client need to do this?

anyone know another method?

please help, we paid two months trying to figure this !

It is very important to do this preloaded elements in the fabrik form

 

[troester]

Can you describe your setup and what you are trying to do?

How do you call this form/list combination - in a Joomla article via content plugin?
When do you call it - via a menu item, a list's custom "Add" link, some other custom link?

Is the form belonging to the list (e.g. a form to create a new record in the list displayed below) or is it a search form (to filter the list)?

From your description I assume it's for creating a new record which should be pre-populated with some of the elements the logged-in user has set in his "last" record - is this correct?

 

[cheesegrits]

How do I get at the site? The only credentials in your "My Sites" don't get through the initial htaccess challenge.

-- hugh

 

[crchaves]

Thanks for your answers

Troester : From your description I assume it's for creating a new record which should be pre-populated with some of the elements the logged-in user has set in his "last" record - is this correct?

Yes, insert a new record and when I save that record must be preloaded

Is this possible?

 

[cheesegrits]

Yes, it's possible, but in order to help we'd need access to the site, as per my last post.

-- hugh

 

[crchaves]

The access you need, is the front end and back end?

no problem if I put the access here?

Thanks !

 

[troester]

Fill your site and creditals (backend) into
http://fabrikar.com/you/my-sites
Include .htaccess infos etc.

 

[crchaves]

I already upgraded my site and creditals, if you can not get in, my hosting provider blocks some IP for not being Spanish speakers.

what is your IP ?

 

[crchaves]

S.O.S !!!!!
Please I need your Help!!!
I already upgraded my site and creditals, if you can not get in, my hosting provider blocks some IP for not being Spanish speakers.

what is your IP ?

 

[troester]

In new records elements can be pre-populated with the "Default" setting, you can use php code with "eval"=yes.
Or you can add a form php plugin running "On" = "new" with Process script "onLoad"
Code something like

$db =JFactory::getDbo();
$query = $db->getQuery(true);
 
// select maximum ROW ID (is it id_merca_produ?) from your MERCADOR IDs - this should be ID of user when he loggs in (is this id_mercado?)
$lrow = '{$my->id}'; //the Joomla userID of the logged-in user
 
$query = "SELECT MAX(`id_merca_produ`) FROM `merca_produ` WHERE `id_mercado`=$lrow LIMIT 1";
$db->setQuery($query);
$thatRow = $db->loadResult();
 
// values are ordered the same as they are loaded in your form
$query = $db->getQuery(true);
$query = "SELECT `id_tip_mercado`, `id_mercado`, `id_producto`, `nom_variedad`, `id_origen`, `nom_uni_venta` FROM `merca_produ` WHERE `id_merca_produ`=$thatRow LIMIT 1";
$db->setQuery($query);
$myrow = $db->loadObject();
 
//preload your elements
$formModel->data['merca_produ___id_tip_mercado']=$myrow->id_tip_mercado;
//etc

I don't understand why you are using UserAjax and JS.

 

[crchaves]

Thank you for your support.

userajax.php and form_11.js the files were for the help of another person. If there is an option that works, I remove these files.

What I recommended to preload the form elements?

 

[crchaves]

Hi! did you see the last reply?

Regards

 

[troester]

If you have multiple elements to preload I would use the php plugin.
Otherwise you'll have to repeat the queries in every default setting.

 

[crchaves]

Thank you for your support.

You could tell me where is php plugin?
Can you make an example?

I would appreciate it very much

Regards !

 

[crchaves]

Hello, I saw my last post???

I have another question. In Frabrik elements.

You can display a user group created in Joomla?

currently it is showing all users.

Any method for this?