1. Huubss
  2. RO CSVI
  3. Tuesday, 31 August 2021
  4.  Subscribe via email
Hello,

I have a custom field which has values yes or no. Now I want to combine these fields so that if one of the fields is Yes the value in the exported field will be Yes and if both of the values are No, the value in the combined field will be No. How do I do that?
Accepted Answer Pending Moderation
Hello,
Do you mean that there are two custom fields and they have values Yes or No? Based on the combination of these custom fields values another export field will get yes or no value in export file? Am i correct? If not, can you give me more details on the fields?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello,
Do you mean that there are two custom fields and they have values Yes or No? Based on the combination of these custom fields values another export field will get yes or no value in export file? Am i correct? If not, can you give me more details on the fields?


Yes that is correct.
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
You need to do this using RO CSVI Conditional rule. You need conditional rule like in the attached screenshot. Replace export field with the template field name which has to get value Yes or No on export. Apply the conditional rule on both of the custom fields in template fields page.

Also please note yes or no text in the rule is for reference. You need to correct these text like the way it is stored for custom fields. Let me know on how it goes.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Looking at the code it seems that the Yes eventually gets replaced by the other fields No if both of the value aren't Yes, is that correct? Or isn't that how it owrks?

This is my situation:

If:

field 1 = Yes, field 2 = Yes, export field = Yes
field 1 = Yes, field 2 = No, export field = Yes
field 1 = No, field 2 = Yes, export field = Yes
field 1 = No, field 2 = No, export field = No
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Looking at the code it seems that the Yes eventually gets replaced by the other fields No if both of the value aren't Yes, is that correct? Or isn't that how it owrks?

Thats correct. The check is on first custom field, if export field is replaced with Yes then with next condition rule on second custom field, Yes will get replaced to No if the custom field value is No.

If:

field 1 = Yes, field 2 = Yes, export field = Yes
field 1 = Yes, field 2 = No, export field = Yes
field 1 = No, field 2 = Yes, export field = Yes
field 1 = No, field 2 = No, export field = No

There is no option to check values on two fields. The possible option is to check the value on one field replace value on another field. That is the reason i suggested for one rule on two fields so check condition runs on both the fields and value is applied on export field.

Does the suggested conditional rule works for you? If you have any problem, please share screenshots on how you have the rule setup.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!