Categories
View Replies (1)

Resolved How to generate a calculated field within an export template

  1. New
  1. Heinz-R
    Heinz-R
  2. RO CSVI
  3. Saturday, 14 June 2025
  4.  Subscribe via email
Using RO CSVI to export some user based custom fields I should build an additional field based on the birthday which is called "unter30" when the person is not yet 30 years old. This should be like the Excel formula:
'=IF(DATEDIF("custom field birthday"; TODAY(); "y";)<30;"X";"";)

Would this be possible within an export template?

Thanks
Heinz
0
Responses (1)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Heinz,
With current RO CSVI rules it is not possible to have any formula processing in export but you can write your own rule plugin and code this formula in the rule. The way I see this new rule is that

1. Create custom export field and set Column header as unter30 .
2. Use RO CSVI copy rule plugin and copy custom field birthday to unter30 export field
3. Create a new RO CSVI rule plugin with the given formula and process it with the copied custom field birthday value and get the new value on the field.

Try and let me know if it helps.
Kind regards,

Tharuna

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


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