• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: How to extract the CustomFields from the article

How to extract the CustomFields from the article 2 years 10 months ago #41276

  • franco0
  • franco0's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
  • Thank you received: 1
Hi,
How can I to extract the CustomFields from the Joomla article and insert in RSform?
Regards
The administrator has disabled public write access.
The following user(s) said Thank You: gunerguk

How to extract the CustomFields from the article 2 years 10 months ago #41279

  • andreic
  • andreic's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 722
  • Thank you received: 59
Hello,

You can refer to the following articles as a starting point:
www.rsjoomla.com/support/documentation/r...-rsformpro-form.html
www.rsjoomla.com/support/documentation/r...le-author-email.html

You will need to use a similar custom script to retrieve your desired information from the database.
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.
The following user(s) said Thank You: gunerguk

How to extract the CustomFields from the article 2 years 10 months ago #41288

  • gunerguk
  • gunerguk's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 29
  • Thank you received: 3
Hi andreic,

To extract the value of a Joomla Custom Field and display it on a form would be something very useful for RSForm Pro users. But with the given examples to achieve a solution is not not easy for nonprogrammers like us. Could you please give a real example?

Thanks in advance.
The administrator has disabled public write access.

How to extract the CustomFields from the article 1 year 9 months ago #42085

  • info5963
  • info5963's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 13
  • Thank you received: 1
Here's how I solved it for myself:

$db = JFactory::getDBO(); //opens a new database connection
$db->setQuery("SELECT value FROM #__fields_values where item_id= '$user->id' and #__fields_values.field_id = 1");

$result=$db->loadResult();
if($result){
$val=$result;
}
The administrator has disabled public write access.

How to extract the CustomFields from the article 1 year 8 months ago #42181

  • info1248
  • info1248's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
I am looking for a similar solution.

Users should be able to change their user data via a form.
Some of the data is stored in custom fields and these should be displayed already filled in.

This would be an update and not an insert on the database, do I have to set something special for this?

Thanks for help
Corinne
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!