• 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: Joomla Article Custom Field (Checkbox) in RSForms

Joomla Article Custom Field (Checkbox) in RSForms 10 months 3 weeks ago #43448

  • agentur3
  • agentur3's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
Hello, how can I output a Joomla Article Custom Field (Checkbox) in RSForms to show the values ​​with a dropdown? I'm stuck and would appreciate some help, thanks in advance.
The administrator has disabled public write access.

Joomla Article Custom Field (Checkbox) in RSForms 10 months 3 weeks ago #43453

  • agentur3
  • agentur3's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
In a Joomla article i been created Joomla-Article Custom Field (checkbox) with selection options. These selection options should be choice in the RSFORM "Please select".

Can anybody help me please in implementing this?
The administrator has disabled public write access.

Joomla Article Custom Field (Checkbox) in RSForms 10 months 3 weeks ago #43457

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

Are you referring to retrieving the options that should be available in your form field directly from the database? If that is the case then you could try taking a look at the following article as a starting point:
www.rsjoomla.com/support/documentation/r...st-from-a-table.html
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.

Joomla Article Custom Field (Checkbox) in RSForms 10 months 3 weeks ago #43462

  • agentur3
  • agentur3's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
Hello, thank you for your answer.

I have made the integration according to this information. The SQL connection is there. It loads ALL checkbox values, not the selected one.

What is meant by: "your_value" "your_label"? The checkbox field is called "size". It contains sizes from XS-XXL or 32-52.
What is value and what is label?
"size" or "34" "36" "38" ...

Only the selected values ​​should be visible under "Please Select" e.a. 34, 36, 38, ...

i think i set the values ​​incorrectly, I don't know what I have to enter, can you help me, please?

I would be very grateful for some help, I just can't do it.
Thank you

Here my Code in RSForms Dropwon Field:

//<code>
// Prepare the empty array
$items = array();
// Prepare the database connection
$db = JFactory::getDbo();
// Keep this if you'd like a "Please select" option, otherwise comment or remove it
$items[] = "|Please Select[c]";

// Run the SQL query and store it in $results
$db->setQuery("SELECT 34, 34 FROM #__content");
$results = $db->loadObjectList();

// Now, we need to convert the results into a readable RSForm! Pro format.
// The Items field will accept values in this format:
// value-to-be-stored|value-to-be-shown
// Eg. m|M-sized T-shirt
foreach ($results as $result) {
$value = $result->size;
$label = $result->size;
$items[] = $value.'|'.$label;
}

// Multiple values are separated by new lines, so we need to do this now
$items = implode("\n", $items);

// Now we need to return the value to the field
return $items;
//</code>
Last Edit: 10 months 2 weeks ago by agentur3.
The administrator has disabled public write access.

Joomla Article Custom Field (Checkbox) in RSForms 10 months 3 weeks ago #43466

  • agentur3
  • agentur3's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
... please, can you tell me what I'm setting wrong? The checkbox is loaded but not the value.
The administrator has disabled public write access.

Joomla Article Custom Field (Checkbox) in RSForms 10 months 2 weeks ago #43467

  • agentur3
  • agentur3's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
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!