concatenate and conditionals

All Topics → → concatenate and conditionals

I have 2 questions

1). I have a dropdown for data from entries which shows “last name”, but there are several names that are the same so I need to concatenate the lastname shown in the dropdown with firstname or an id

2). is there a way to use conditionals in frm statistics, such as display a count of all records where field 17=”in storage” and field 100=”bed”

 

See this Knowledge Base page on Combining two fields into one to address your concatenation question. http://formidablepro.com/knowledgebase/formidable-hooks/frm_validate_field_entry/#kb-combine-multiple-fields-into-one-field
The code given here would be added to your theme's functions.php file or to a new plugin.

Please take a look at this page on form stats: http://formidablepro.com/knowledgebase/add-field-totals-and-statistics/

You should be able to check for certain values in other fields as long as they are in the same form:

Any field ID or key in the same form – Only count entries where another field in the entry has a specific value. Use key/id=value pairs (Integer=”string” format).

[frm-stats id=x 25=Hello]

In this example, 25 is the field ID of the other field in the form and “Hello” is the value that field should have in order to be counted toward this statistic.

Topic closed.