Title: #REF for a defined ID
Last modified: August 20, 2016

---

# #REF for a defined ID

 *  [jonburr](https://wordpress.org/support/users/jonburr/)
 * (@jonburr)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/ref-for-a-defined-id/)
 * This is giving me a hard time…
 * I’m unable to calculate a total for this table. I get a #REF error, while using
   defined id’s in the formula.
    The table is here: [here](http://www.arrangerforhire.com/arrangement-cost-estimator/)
 * I’ve tried everything I can think of.
    (baserate + (instrument * 1.40)) * totalpages(
   baserate + addlines) * totalpages
 * I created subtotal input fields also with no success.
    It seems the parser is
   REALLY PICKY about the syntax, whether or not there are spaces, etc… and there’s
   no documentation!
 * My field id’s are
    baserate instrument addlines (cost per line * # of additional
   instruments) transcription bpm timesignature mins totalpages totalbars secs total
 * I seem to be able to calculate the number of pages OK. But, I can’t multiply 
   it by the baserate!
    And – what is the FACTOR field for in the input options?
 * Thanks
 * [http://wordpress.org/extend/plugins/jazzy-forms/](http://wordpress.org/extend/plugins/jazzy-forms/)

Viewing 1 replies (of 1 total)

 *  Thread Starter [jonburr](https://wordpress.org/support/users/jonburr/)
 * (@jonburr)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/ref-for-a-defined-id/#post-3591310)
 * I have decided to abandon jazzy forms due to lack of documentation, response 
   and support, and their failure to work in an intuitive fashion. I have switched
   to Calculated Fields… that’s what’s on the page now, and it’s operational

Viewing 1 replies (of 1 total)

The topic ‘#REF for a defined ID’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/jazzy-forms_dac291.svg)
 * [Jazzy Forms](https://wordpress.org/plugins/jazzy-forms/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/jazzy-forms/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/jazzy-forms/)
 * [Active Topics](https://wordpress.org/support/plugin/jazzy-forms/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/jazzy-forms/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/jazzy-forms/reviews/)

 * 1 reply
 * 1 participant
 * Last reply from: [jonburr](https://wordpress.org/support/users/jonburr/)
 * Last activity: [13 years, 1 month ago](https://wordpress.org/support/topic/ref-for-a-defined-id/#post-3591310)
 * Status: not resolved