@Alex Medved _ConfiForms_ Hello!
I need to set up value scoring.
I use the FORMULA field type.
After saving the form, everything is displayed correctly
But, I need the sum of all fields to be displayed before saving
For example:
Here I want to see the result
I use expression ([entry.s11]+[entry.s22])+([entry.s33]+[entry.s44])+([entry.s55]+[entry.s66])
how to make calculation before saving the form?
This usually happens when the references to field values, such as [entry.s11] result in empty values
Consider using ZEROIFEMPTY wrapping function
https://wiki.vertuna.com/display/CONFIFORMS/Supported+math+operators%2C+formulas+and+functions
(ZEROIFEMPTY("[entry.s11]") + ZEROIFEMPTY("[entry.s22]") + ZEROIFEMPTY("[entry.s33]") + ZEROIFEMPTY("[entry.s44]") + ZEROIFEMPTY("[entry.s55]") + ZEROIFEMPTY("[entry.s66]"))
Alex
how to make calculation before saving the form?
Formula is calculated on submit
Use the "Set expression" rule instead, and not the formula field, but something like a read-only field
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Alex Medved _ConfiForms_ thank you! Now it works well. I did it by "set expression"
In this scoring i have few statuses that depends on points
for example
<=5 -"take on the task"
<21 - "send to backlog"
<41 - "refine the idea"
So, how can I set up to automatically choose status that depend on points? Before saving the form
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Add 3 more rules with a “set value” as an action that execute for each condition, all bounded to the field that you set with a “set expression” rule
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Alex Medved _ConfiForms_ which condition should I use?
s111 is the readonly field
I need to set if the number is less than or equal to 5 to set the status to number 1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Interesting namig convention, but yes… that’s about right
I would adjust the condition to be as follows though
s111:<=5
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No problem. Happy to help
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Alex Medved _ConfiForms_ Hello! The last question :)
Everything works perfect.
But when I edit saved entries, the total value multiplies by 6, which leads to incorrect status setting
<ac:structured-macro ac:macro-id="0c0e822e-6a83-4d6f-967b-2299e8d3f5a8" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="closeButtonLabel">Закрыть</ac:parameter>
<ac:parameter ac:name="formName">scoring2</ac:parameter>
<ac:parameter ac:name="saveButtonLabel">Сохранить</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="b24366ee-17f1-45ea-8898-be9b6466b1e1" ac:name="confiform-entry-register" ac:schema-version="1">
<ac:parameter ac:name="overrideSaveButtonLabel">Сохранить</ac:parameter>
<ac:parameter ac:name="overrideCloseButtonLabel">Закрыть</ac:parameter>
<ac:parameter ac:name="registrationButtonLabel">Создать</ac:parameter>
<ac:parameter ac:name="autoAlign">true</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="3529f30e-f395-44ce-9e47-337942536ad5" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">c1</ac:parameter>
<ac:parameter ac:name="withLabel">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="96511ec6-d759-43dc-805d-027c428afea5" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">c2</ac:parameter>
<ac:parameter ac:name="withLabel">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="851ad7b6-7cee-432a-915e-92f84652b711" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">c3</ac:parameter>
<ac:parameter ac:name="withLabel">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="13c4cbc6-6acd-415a-998e-04d9d4ca20f5" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">c4</ac:parameter>
<ac:parameter ac:name="withLabel">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="29caa9ad-e00e-4c82-aea0-9c7a7463c140" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">c5</ac:parameter>
<ac:parameter ac:name="withLabel">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="4775cb4d-4aa4-4caa-9d6a-03f84eac7d65" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">c6</ac:parameter>
<ac:parameter ac:name="withLabel">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="ad321737-f69c-4230-b789-4197e92f765a" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">c7</ac:parameter>
<ac:parameter ac:name="withLabel">true</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="740be4e5-9f83-411d-b1d5-8299b083b2a0" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">c8</ac:parameter>
<ac:parameter ac:name="withLabel">true</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<ac:structured-macro ac:macro-id="225caf72-8209-400c-bc6b-45cf2bbfcf64" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">c1</ac:parameter>
<ac:parameter ac:name="fieldLabel">Вовлечение других подразделений</ac:parameter>
<ac:parameter ac:name="values">false[0=Можем реализовать силами своей Дирекции / проектной группы / отделения|1=Требуется вовлечение других Дирекций внутри Центра|4=Требуется вовлечение других Центров внутри Блока|7=Требуется вовлечение других Блоков|10=Требуется вовлечение всего Банка|]</ac:parameter>
<ac:parameter ac:name="type">select</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="b8c8e8f6-acca-4eb8-abd5-88d4c4546752" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">c2</ac:parameter>
<ac:parameter ac:name="fieldLabel">Срок реализации</ac:parameter>
<ac:parameter ac:name="values">false[1=Быстро (до 3 месяцев)|4=Средне (3 – 6 месяцев)|7=Долго (6 – 12 месяцев)|10=Очень долго (более 12 месяцев)|]</ac:parameter>
<ac:parameter ac:name="type">select</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="e9f2935e-e507-4a89-a18c-a6da32f232ee" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">c3</ac:parameter>
<ac:parameter ac:name="fieldLabel">Срок достижения эффекта</ac:parameter>
<ac:parameter ac:name="values">false[1=Быстро (до 3 месяцев)|4=Средне (3 – 6 месяцев)|7=Долго (6 – 12 месяцев)|10=Очень долго (более 12 месяцев)|]</ac:parameter>
<ac:parameter ac:name="type">select</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="17ea0842-5e72-4ba7-888f-349011aea119" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">c4</ac:parameter>
<ac:parameter ac:name="fieldLabel">Бюджет</ac:parameter>
<ac:parameter ac:name="values">false[1=Бесплатно|4=В рамках бюджета Дирекции / Центра|7=Необходимо привлечение бюджетов нескольких Центров|10=Необходимо привлечение бюджетов нескольких Блоков|]</ac:parameter>
<ac:parameter ac:name="type">select</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="a6c5da7f-f617-4fab-8e3c-fdbed5732bb8" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">c5</ac:parameter>
<ac:parameter ac:name="fieldLabel">Необходимые IT-ресурсы</ac:parameter>
<ac:parameter ac:name="values">false[1=Достаточно имеющихся IT-ресурсов|4=Необходима небольшая доработка силами Банка (внутренние подрядчики, например BCC Hub) или небольшая закупка в рамках резервов бюджета|10=Необходимы большие закупки оборудования и/или ПО, привлечение внешних подрядчиков — за рамками утвержденного годового бюджета|]</ac:parameter>
<ac:parameter ac:name="type">select</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="c44e95a5-84a2-419c-a25f-8f6b78b784f8" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">c6</ac:parameter>
<ac:parameter ac:name="fieldLabel">Эффект</ac:parameter>
<ac:parameter ac:name="values">false[1=Очень большой эффект: влияние в масштабах всего Банка, всех клиентов и всех партнеров|4=Большой эффект: влияние в масштабах всех отделений / нескольких Блоков / большей части клиентов)|7=Средний эффект: влияние в масштабах группы отделений / Блока / категории клиентов (ФЛ, или МСБ, или Корп.)|10=Малый эффект: влияние в масштабах отделения / Дирекции / минимальной группы* клиентов|]</ac:parameter>
<ac:parameter ac:name="type">select</ac:parameter>
</ac:structured-macro>
</p>
<p>_____________________________________________________________________</p>
<p>
<ac:structured-macro ac:macro-id="f59ba3ec-4ee8-49d7-8056-a925955ca90f" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">c7</ac:parameter>
<ac:parameter ac:name="fieldLabel">Итог</ac:parameter>
<ac:parameter ac:name="type">read_only</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="6b404d4b-8b39-4bd1-aab7-f758f3f376bd" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">c8</ac:parameter>
<ac:parameter ac:name="fieldLabel">Статус</ac:parameter>
<ac:parameter ac:name="values">false[1=Взять в работу|2=В бэклог Дирекции|3=Передать в бэклог Комитета инноваций|4=Доработать идею|]</ac:parameter>
<ac:parameter ac:name="type">select</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="68bbdca5-cf19-49b1-be45-160d11373b89" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="values">c7=(ZEROIFEMPTY("[entry.c1]") + ZEROIFEMPTY("[entry.c2]") + ZEROIFEMPTY("[entry.c3]")+ ZEROIFEMPTY("[entry.c4]")+ ZEROIFEMPTY("[entry.c5]")+ ZEROIFEMPTY("[entry.c6]"))</ac:parameter>
<ac:parameter ac:name="action">Set expression</ac:parameter>
<ac:parameter ac:name="actionFieldName">c1,c2,c3,c4,c5,c6</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="9134c09e-b2ad-41f4-a91a-1b8f07cdd960" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="condition">c7:<=5</ac:parameter>
<ac:parameter ac:name="fieldName">IF(LEN("[entry.s111]")<=5, "Взять в работу", "Not good at all")</ac:parameter>
<ac:parameter ac:name="values">c8=1</ac:parameter>
<ac:parameter ac:name="action">Set value</ac:parameter>
<ac:parameter ac:name="actionFieldName">c7</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="bf59ebde-58bb-41fd-8fc0-9bbc2aa1a6de" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="condition">c7:<=21 AND c7:>5</ac:parameter>
<ac:parameter ac:name="fieldName">IF(LEN("[entry.s111]")<=5, "Взять в работу", "Not good at all")</ac:parameter>
<ac:parameter ac:name="values">c8=2</ac:parameter>
<ac:parameter ac:name="action">Set value</ac:parameter>
<ac:parameter ac:name="actionFieldName">c7</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="b580a193-f334-40d5-8168-4267be0b024e" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="condition">c7:<=41 AND c7:>21</ac:parameter>
<ac:parameter ac:name="fieldName">IF(LEN("[entry.s111]")<=5, "Взять в работу", "Not good at all")</ac:parameter>
<ac:parameter ac:name="values">c8=3</ac:parameter>
<ac:parameter ac:name="action">Set value</ac:parameter>
<ac:parameter ac:name="actionFieldName">c7</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="a98dbe6a-fd59-4477-a019-5094084d0dde" ac:name="confiform-field-definition-rules" ac:schema-version="1">
<ac:parameter ac:name="condition">c7:>41</ac:parameter>
<ac:parameter ac:name="fieldName">IF(LEN("[entry.s111]")<=5, "Взять в работу", "Not good at all")</ac:parameter>
<ac:parameter ac:name="values">c8=4</ac:parameter>
<ac:parameter ac:name="action">Set value</ac:parameter>
<ac:parameter ac:name="actionFieldName">c7</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="fe61ebfb-6ef2-48d6-b8f7-ac2c0038748f" ac:name="confiform-table" ac:schema-version="1">
<ac:parameter ac:name="formName">scoring2</ac:parameter>
<ac:parameter ac:name="sort">created DESC</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="37426a36-a690-4242-829c-07f1c4e8ac2e" ac:name="confiform-entry-edit" ac:schema-version="1">
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Make the rules to run ONLY on "user action"
You can see what happens by enabling the "debug mode" in the ConfiForms Registrations Control macro (will show you which rules are triggered.. and when)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.