Confiforms calculated field. I want the dropdown that's only visible to admins to.

Confiforms calculated field original Jul 24, 2025 · SUMMARY (Required): text area. 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. Here we have a simple form with 4 fields: May 8, 2024 · I would like to have a field which gives me the string value "To be revised" if end date of a contract is in 2 months and it's "fixed term" (type==1) OR if the type of the contract is "open-ended" (type==2) and 3 years passed after start date of the contract, otherwise the value should be "Actual". I suggest to have a static part done with autolink and then a combination of prepend/append/asLink functions applied on the fly (in the field name parameter of the ConfiForms Field macro) Alex Oct 4, 2024 · Hello! I need to set up value scoring. I can see the data for the users who submit the f Create awesome forms for Confluence with ConfiForms. 20 of ConfiForms you are now able to source the data for your fields in ConfiForms directly from your databases. Field 1 : Checkbox Group which will have below options. When a user wants to submit the record. The field NAME is only required when the value in TYPE is set to INDIVIDUAL. Mar 3, 2025 · As, actually, through the smart field you can always access any field directly, for example, when creating a view over the Release form you can always have a ConfiForms Field macro added with a field name set to TeamName. ConfiForms blends deeply with Confluence’s permissions, allowing secure forms with field-level access control. I have looke In ConfiForms you have a very powerful macro called ConfiForms Field Definition Rules to setup interactions and rules for your form, one of very powerful features is the ability to filter the options in the fields based on conditions. Now I need to start summing values from different existing rows Is this possible? What advice would you give? Aug 27, 2021 · Just add a ConfiForms Field macro inside your "view" macro (TableView, CardView, etc) and set it field name parameter to employee. More on this below. I want one of the fields to be a hyperlink, but I can't find a good way to implement it. 12 you can use "cf_force=true" parameter to ensure ONLY the filter from the URL is applied on the ConfiForms View (overriding completely default filters defined by the view) Since version 3. For doing this, you need to insert the ConfiForms Table View macro and add the ConfiForms Form Field macros, one macro for each data input field used on the form. His name should be auto filled already in there Name In this tutorial you will learn how to use values stored in ConfiForms form in Javascript, directly on your Confluence page. Both rules are set to track "val" field and executed based on a condition, meaning based on the selection made in the "type" field. . 19. Sep 2, 2020 · Hi Alex, This section is a Field Form Definition, within Form Definition. This is done by configuring the ConfiForms Field Definition macro using the following parameters You can specify usernames or security groups, or can have a mix of usernames and security groups. FIELD_NAME] notation to reference field values ) CleanView - similar to ListView, with less capabilities but with a lot cleaner HTML With ConfiForms Field Definition Rules it is easy to configure your form to validate the fields to require values, conditionally. add (1209600000)])) set for this field Can I just use the validation rule section in the ConfiForms Field Definition, or do I have to add ConfiForms Rules for Field Definition’ Macro as well? Jun 6, 2024 · There is a field Last Submission Date , I want to Create a automated new Field ( Say New)which is 1 year after the Last Submission Date For eg Last Submission Date. Find more information about the ConfiForms app on the documentation site and in the Quick tutorial on how to use ConfiForms TableView and ConfiForms Field to show the data in a table format. If this is filled, the selected user should be added as a record owner (additionally to the record creator). Jan 16, 2025 · Solved: Hello, I have to assign the date to the end of the current year for the Confiforms Field Definition. Apr 7, 2025 · Hello, I am creating a form using ConfiForms Field Macro, and I am unable to establish two things. This allows you to control which fields are shown and how they are displayed. I want a table to show results filtered by if a summary field contains the word "TBD" and "Not now" On a slightly separate note. Oct 4, 2021 · Each field in ConfiForms must be defined via ConfiForms Field Definition In 2. ConfiForms has a lot of various field types to help you with building your data forms. Script Jun 1, 2019 · In Confiforms, how to update a field value without updating computed fields and IFTTTs? fbunting Contributor June 1, 2019 Create awesome forms for Confluence with ConfiForms. Multi-select checkbox - I have a status field which has multiple values. Important page to help you with accessing and transforming values can be found here: Accessing field values and properties Sep 5, 2017 · Alex from ConfiForms has been super helpful and answered my question. My actual use case will have multiple fields all entering in to the final display field. Each The values are actually stored as an array and you should use Velocity foreach loop to get them. Fields taken as expressions are given with the format like (may have references to May 9, 2025 · Hello everyone, I’m encountering an issue with the implementation of ConfiForms rules in my form, and I hope someone can help me. Jan 21, 2024 · Hello! What we've got: - a page with ConfiForms macros created according to the documentation - the ConfiForms page contains all the created pages in a list (links to the created pages by IDs and URLs) - the ConfiForms fields are multi-select and smart multi-select fields which values depends on t Sep 5, 2022 · Purpose Calculated Fields Use this script to sum the values of number fields on the form and place the result in a destination field. Feb 26, 2021 · Hello, I have a confluence form with a non-mandatory date field that will only be populated for certain types of requests. Oct 26, 2024 · Hello, This is continuation to my last question. fields. When I use a formula field the result is only calculated when the form is saved. I couldn't find any way to do this. We created a ConfiForms Field Definition for our status using this expression: ConfiForms IFTTT macro is a powerful tool which helps you to built integrations with other systems: to send emails, to create issues in Jira, to build workflows in Confluence, to organise templates and rules. Fields can be configured by placing "ConfiForms Field" macros inside View macros. 2 you can specify the view type via "cf_view" parameter to scope the filtering on a specific view type only. com/display/CONFIFORMS/ConfiForms+Field+Definition+Rules#ConfiFormsFieldDefinitionRules-Validationrule - using asLength virtual function) Sep 5, 2013 · I need to have multiple IF statements in a calculated field. 16 of ConfiForms TableView Merger macro supports "auto-discovery" for forms based on given search criteria and performs an auto-merge. I created a "Status" FieldDefinition where I defined 4 possible status, corresponding to the colors red, blue, purple, and yellow. I've tried to use ConfiForms Rules for Fields (CSS) as shown below, but it doesn't appear to work on drop downs. Table Filter & ConfiForms TableView 1. I have 4 fields which are read only where I am doing calculations with the help of Confiforms Rules for Field Definition (set expression) as follows- Field 1: Average value of fields A, B, C Field 2: Average value of fields D, E, F Field 3: Average CalendarView macro PlainView macro - when you need just values from ConfiForms and want to construct you tables/HTML widgets yourself (to be used in conjunction with HTML macro, for example; and using [entry. I am trying to create two separate validation rules: Allow only one person (first name Jane for example) to change the status from status:1 to statu Aug 15, 2023 · New to Confluence - so thanks in advance for any info (or redirection to documentation) that anyone can provide. Aug 21, 2023 · We use Confiforms Field Definition Rules to set value to add the values for a few calculated field, which is also done by Confiforms Field Definition Rules Set Value. We worked hard to make Date and Datetime pickers to be as localised as possible and to match the formatting and localization settings you have configured. I don't know how to code so I'm out of my comfort zone & in awe of the expertise you all have. MyField:[entry. 2. Jan 4, 2017 · Look for ConfiForms Form Field Definition macro parameter Since version 1. 30+ then consider this cookbook as " OBSOLETE " With newer version of ConfiForms, smart classifier fields have the same naming convention as the other fields, basically t he same name as you give it in ConfiForms Field Definition Sep 10, 2024 · Hello, I am trying to utilize HTML and javascript to place an HTML button within my confiforms forms and have it able to set a field in the Using value to match with checkbox in field rule Playground and DEMO space This is a playground and demo space for ConfiForms and ConfiDoc addons developed and supported by Vertuna LLC Aug 9, 2023 · Error when using ConfiForms to set value in a custom numeric field in Jira Mechee August 9, 2023 On the same page we add a ConfiForms CalendarView macro And configure it to use our form and use "mydate" field as a grouping field for calendar Then we add ConfiForms Field macro referencing our other field (text field) from the form CalendarView macro body will be used as a template when showing calendar items. s11]+[entry. In the f We would like to show you a description here but the site won’t allow us. New date Jun 3, 2023. s22])+([entry. Aug 21, 2024 · I get a total calculated here - but how do I get the totalisation to be calculated synchronously with the data input by the user and displayed directly in the form after an amount has been entered? Here is a simple demo to show how the formula fields can be used. Script Oct 12, 2023 · Hi, i have a problem with Masked Text field type Numeric in Registration FormView. However, sometimes, you may want to change the Look and Feel (L&F) of the ConfiForms fields, both when used in "views" and in the form This task is quite easy if you are familiar with CSS styles, as ConfiForms macros has a parameter to set custom Oct 28, 2019 · How to configure confiforms data in IFTTT? Similar to “Copy ConfiForms Data” action you can filter records on original form before copying, as well as “flatten” records in order to have multi-value fields as separate rows (if necessary) ConfiForms uses JDBC driver to connect to your database. 4. I want to the second field to display "Hi name, how are you?". One of such integrations is using the ConfiForms Field Definition Rules action called " Lookup and set a DB value " Oct 26, 2023 · Hi there, this is more of a "is this possible" question. Now every answer equals a diff Find more information about the ConfiForms app on the documentation site and in the Quick tutorial on how to use ConfiForms TableView and ConfiForms Field to show the data in a table format. However, I found that the value of "currency" Confiform field type can not be calculated, while "read-only" wit In this tutorial you will learn how to customise the output of the ConfiForms based on field values Feb 15, 2022 · Confiforms field definition rules - condition date syntax JN Contributor February 15, 2022 Aug 27, 2024 · I want to use the confiform fields in the jira issue macro and filter the query dynamicaly gets the value from the confiforms field ConfiForms filters is the core component of the app and is used absolutely everywhere where you need to describe a condition, filter the dataset or setup the behaviour (field and IFTTT rules) In this example we will be more focused on filtering the data, but will also touch the basics of a conditionally applied rules Let's consider these forms that will, logically, build the bookshelf. It also connects with Jira, enabling automated actions such as sending emails, creating issues, or triggering workflows when form data is submitted. Jun 10, 2020 · Solved: I have a form with a user field. I can Jul 27, 2023 · Hello, I’m still learning how to use Confiforms. And it has a very sophisticated system to retrieve the values stored, including accessing rich objects such as Page, User and other referenced Records when used together with "smart fields" It is a dropdown field with 2 choices: numbers (Numbers only) and letters (Letters only) Next important bit is 2 ConfiForms Field Definition Rules macros and their configurations. myFormDefinition. If I use a "Rules for field definition" (Set expression) to make a dynamic calculation within the registration control it won't work. Once the user submits the 1st form - they need to be redirected to Form 2 (separate form, which also has user related information to capture + other info related to the w Nov 5, 2024 · You need to add a ConfiForms Field Definition Rule with an "Apply Filter on Field" action to filter out options from a smart multi-row field You cannot set values on fields in a sub form May 29, 2024 · Hello All, Very Basic questions but i am stuck. The first field you enter your name. asList Simple tutorial on how to use ConfiForms Field Definition Rules#Showcontainer and it's counterpart ConfiForms Field Definition Rules#Hidecontainer ConfiForms Rules for Field Definitions to show and hide visual blocks in your forms conditionally These rules are usually used with custom layouts, where you have your own layout defined for the form and want to show or hide blocks of fields Export formats ConfiForms provides a way to export data in 4 different formats (or in 6 if you count flattened views as separate types) CSV (+flattened view) - comma separated values XLS (+flattened view) - Microsoft Excel format JSON - JSON format XML - dataset exported in an XML format First 2 are for end-users mainly and second 2 are for further data processing, as it depends how the data Dec 1, 2020 · I have a Confiform TableView that is populated with data and I’m looking to run a check to prevent a new record from being added to the table if a field in the record matches one already in the table. Jan 16, 2023 · ConfiForms: Creating a Sum of a Numeric Field on a dependent linked List Florian Seibold Contributor January 16, 2023 Action types available in ConfiForms Field Definition Rules (aka ConfiForms Rules for Field Definition) Rules are the best way to add dynamics to your forms, make validation rules conditional or customise form UI behaviour Available rules Using ConfiForms Rule for Field Definition to calculate the sums online Playground and DEMO space This is a playground and demo space for ConfiForms and ConfiDoc addons developed and supported by Vertuna LLC From ConfiForms version 1. I am not sure if this is a bug or not in the application. Setup is the following: Form (F1) is creating a Subpage when a record is created (based on a space template) Every field in the Form has different answer options (sometimes yes / no, sometimes other options). I tried the same method for Field Type = Text, and that d Using ConfiForms status fields in filters Playground and DEMO space This is a playground and demo space for ConfiForms and ConfiDoc addons developed and supported by Vertuna LLC The macro has been renamed from ConfiForms Dynamic Filter Control to ConfiForms Form Filter Control macro ConfiForms Form Filter Control macro supports custom layouts. vertuna. Also referencing without the virtual asList as: "[myfield. transform (fullName). com that works as expected, but not in the Confiforms validation rule. So including the calculations/formulas so that the table is updated if the numbers change. asList]" . labels. I set the following validation rule (. 27+) you can enable the rules to filter out choices on smart and db fields (or even just simple dropdown fields) based on the values in another field (or fields) This allows you to build forms with fields which are easier to fill in by your end users as the choices they have to make can be reduced automatically using the logic you set up As you can see, both forms have a commonly named field called "k" We gonna use this field as a "key" field in our TableView Merger macro What is important is that in TableViewMerger macro you specify the ConfiForms Field macros, but some are taken as keys (for grouping), while others are taken as expressions. Yes, the current Field Form Definition is setup as a Section, with some CSS to try and separate it out. When setting values using Confiforms Rules for Field Definition, how can I perform string functions? Is there any documentation? e. Can I filter by character count ex: showing all responses that were 100+ characters Thanks! Jul 9, 2023 · Hi there, With community's help, I use Confiforms TableView as source table and Table filter, table transformer macro with SQL to do difference comparison of two columns of source table. Prerequisites You should already have a web-service connection to your Jira service (done once by your instance administrator) ConfiForms app With recent update to ConfiForms (from version 1. I want to use this field in two different views (as a drop down in tableview and as a checkbox group in filter view). See below. +) to ensure the NAME field IS NOT EMPTY when TYPE = INDIVIDUAL and included a message to show when validation rule matches. The total can be successfully calculated in the beginning. One field I am auto-populating is the built-in ownedBy field. 1 you can now setup a rule to lookup a value from another form to be set for you into your form/field It expects 3 parameters to be set Values to set - You can set multiple values at once using (to be set on a TARGET form, the one which you have set up this Field Definition Rules macro) This validation is possible to automate in ConfiForms by using the "ConfiForms Field Definition Rules" macro and using it's "Action" selected to "Validation Rule" If you need to have 2 dates together consider using "Date Interval" field type in ConfiForms. There is also a way to do calculations with ConfiForms Field Definition Rules. The below table explains in detail the functions that can be used to create calculated fields. I use the FORMULA field type. 6. I would like this field to have, for example: 1) if i entry in this field 999999, the field showed the value 9 999,99 2) if i entry in this field 123456700 the field showed the value 1 234 567,00 I would like the fiel Dec 9, 2020 · I am creating a Confiform and would like to add a paragraph of instructional text at the top of the form before adding in the fields that the users will fill in. Similarly to "actionable field name" parameter you can provide a comma separated Jul 5, 2024 · Hi, I am kind of new to Confiform and would like to know how (and if) it is possible to set value by Field Definition Rules for User Type fields. Compatible tools Any scripting tool, such as JMWE, Power Scripts or Scriptrunner, that uses Groovy. This requires your database to be accessible from your Confluence server and you need to provide the connection configuration, before you can use those fields. I have a form that includes two fields: status (field type dropdown) and requester (field type user). In ConfiForms we have a number of integration points where you can supply the data from your database tables or views directly to ConfiForms. May 4, 2023 See here: Accessing field values and properties How to access ConfiForms metadata fields All these metadata fields, in addition to the form's defined fields (definitions), can be referenced using the "ConfiForms Field macro" in these ConfiForms macros: TableView macro ListView macro CardView macro CalendarView macro Add the following fields (by inserting ConfiForms Field Definition macros) into the ConfiForms Form macro body a Text field for the book's title a Textarea field for an introduction to the book a File type field to store a picture of the book Next, insert a ConfiForms Registrations (FormView) Control macro on the same page. Based on the number of participants, I want to filter a dropdown field (ort): If there This is something we hear occasionally from our customers. I think I use exactly the (very simple) way Aug 22, 2024 · In a Confiforms definition field macro, I have defined a validation rule using a regular expression for a text area field to have the user enter multiple IP addresses. I don't see a way to set a default value in the date field, but Jan 30, 2024 · I have a form with two fields. Define form once and show it multiple ways (via ConfiForms Registration Control) and show the data stored with this form on any page, any data subset and in the way and layout you want, with sorting and styling you need. See examples below. g. The functions are divided into 4 categories Action fields, such as quick actions, voting, enrollment Rich fields, such as Jira issue fields, Confluence page/blogpost fields, Riada Insight fields, User fields Helper and context fields: sequence number (autonumber), captcha, IP address Formula and calculated fields (Supported math operators, formulas and functions) ConfiForms is much more than a plugin It is a platform, a foundation that helps you to maximize and fully open the potential of Atlassian Confluence You can choose from 70+ custom field types Connect and reuse the data from your databases and external services Create dialog or embedded forms Forms with own custom layout and design Develop strict validation rules to fulfill your business Some guidelines on using database fields in ConfiForms Using Lookup and set a DB value action Using ConfiForms Field Definition Rules macro to reduce number of choices in a dropdown field based on the value selected in another field Working with Dependent DB dropdowns Database dropdown with extra fields in a table Jun 22, 2024 · Solved: We have been experiencing an issue with Confiforms. In Form1 I'm capturing user related information and other platform info. After hitting submit button, the value some May 18, 2021 · In Confiforms, I'm using IFTTTs with 'Create/Update ConfiForms Entry' action to auto-populate some fields before saving. 21 branch (upcoming) we are working on allowing users to set up forms that can allow one form to submit to master and details at the same time. 1. I have set it as drop down in field definition. Mar 16, 2017 · ConfiForms add-on also provides a capablity to output a table with collected results on any Confluence page and this is what we really need. I'm using ConfiForms Rules for Field In this tutorial we will create a data entry form with dependent fields form has 5 fields the form will have 3 rules one rule will set the values on 2 other fields another rule will be to show some field based on the value selected. List of math operators and functions supported in ConfiForms Field macro (calculated/formula fields and TableView Merger macro) + ConfiForms ValueView macro Please note that formulas are calculated PER ROW. Is this even possible? We start with very simple form with one text field (field name is "myfield" and it is of type "Text"). A Set Value rule then sets the Numeric Field "TotalScore" to the calculated value of "Score" so it shows on the form for the user to determine Aug 31, 2023 · Tried selecting 2/2/24 Value '1706860800000' for 'Due Date' does not match the validation rules (due:> ( [entry. But then the price field in the end shows "10 10 15". s33]+[entr Jul 7, 2021 · ConfiForms has fields that can hold the HTML - you can use those or even "textarea", but when you reference this field via ConfiForms Field macro then you can use "renderAsHtml" function Jul 17, 2025 · Hi @Alex Medved _ConfiForms_ and ConfiForms Team, We use ConfiForms to build an internal expense tracking system, and encounter issue that the expense total calculated and display in TableView is different from the "dialog mode" rendered from Edit Control (TableView number is corrent but rendering in Edit Control is wrong). In ConfiForms app you can setup view and edit restrictions for a field. Will add a default "ConfiForms Registration Control" here as well Like this: Then will add a IFTTT macro to react on onCreated event which will create a page based on the value entered in the form. f Feb 26, 2025 · Hello! My question is about using formulas I have a table where I sum values within a row using ConfiForms Rules for Field Definition. In this recipe we focus on " Edit restrictions " parameter Feb 27, 2025 · Hi, I have a form with multiple fields. We have 2 types of fields for calculations: You can use any of the functions or operations documented here: Supported math operators, formulas and functions. Goal: I have a form where the number of participants (anzahl) must be specified. I want to be able to see if a date is more than 60 days out, less than 60 days, less than 40 days, and less than 20 days. I want the dropdown that's only visible to admins to This should be a detailed tutorial one day but as we have very hectic times, I will quickly put a cookbook page showing the techniques which can be used with TableView Merger We use here: CONCAT function to concatenate values from 2 fields together and show it in one column We count (group by) by one field but use another as calculation input. MyField] Could please advise me, how it is possible t Apr 23, 2025 · I have a ConfiForms Field Definition with fieldName=PROJECTSTATUS with dropdown options such as "COMPLETE", "ABORTED","REJECTED". I am doing average and the answer is coming right in the read only field before hitting submit button. See example below (which groups by "status Creating links in original ConfiForms entry to just created page — In this tutorial, we will create a Confluence page with IFTTT module and then update the original ConfiForms entry with a page id of a just created page. Very useful when used in ConfiForms CalendarView Let's start with a simple form. I have a Table View showing the Completed requests and the number of days for each, but I'm unsure on how to offe May 7, 2023 · Hi Team, I have set below structure for users to input several fields, and provide a total using Field Definition Rules with "set expression" to calculate total. Jul 5, 2022 · Hey, I am looking for guidance on rendering the Labels array returned in a Jira payload on ConfiForms. Here we have collected the list of various forms you can create with ConfiForms app in Confluence Mar 21, 2024 · I would like to create a column in my database that calculates 60 days from a date column that already exists in my database. May 24, 2018 · Confiforms - How to create dependent smart dropdowns where all fields have values in another form? Dec 12, 2024 · Hello, so I've been trying to create a rule that will allow an item in the confiforms table to change or update a multi select dropdown field named Assignee based on user selection. Rather than use a calculated form field, use a "Formula" field type and the record will re-calculate when data is updated. When I simply type into the Confiform macro, nothing appears. Below, please find the list of field types available in ConfiForms. And ConfiForms forms look very native when used on Confluence pages. I tried with form validation by show field option if Entry. Field1=Option2 but no luck. Let's start with the form. However, the problem is that if user updates any field with "backspace" inste All forms have just one field and a number of validation rules (configured using the ConfiForms Field Definition Rules macro) And look lik ethis in edit mode You can see the 3 rules we have setup They all fire when record is new (ID is empty, id: [empty]) All 3 rules are very similar (the storage format for the first form looks like this) Using ConfiForms Field Definition Rule to set the date to 15 days after the date the user has selected Using ConfiForms REST API and JavaScript to calculate totals and percentage Using ConfiForms Rule for Field Definition to calculate the sums online Using ConfiForms status fields in filters Feb 13, 2023 · Hi There Would like to set a value and making the field read-only based on dropdown item dropdown field: name: status Values: A and I text file: name: pName When the user select status as "I" I would like to do the following pName = inactive pName become readonly with reverse I tried to u Oct 24, 2024 · Hello, I am using formulas and doing calculations in Confiforms Rules for Field Definition and setting values, using Set expression to a read only field. transform(value). 0. This is done with Rules for field definition >> set With ConfiForms record you always have access to metadata fields such as id - record internal id (UUID), unique for every saved record within dataset ownedBy - the username (s) of the users who own the record (and can fully control it) - multi-value field! Multiple users can own a record! ownedByName - the full name of the user who owns the record Use ownedBy. I need this field to feed into the created Jira Issue but unable to map blank fields from confiforms to Jira. fullName Since version 1. If you are using latest version of ConfiForms, or something after the 1. The global settings for Date and Datetime could Since version 1. How would I do this? Dec 16, 2020 · I've 2 forms (created using confiforms) Form1 and Form2. What is the appropriate way to approach this problem? In this tutorial you will learn by example how to setup a rule to lookup data from your JIRA server and set it to ConfiForms fields Aug 7, 2024 · Use value in 1 confiform field (a link) to update another field with text from link Since ConfiForms version 3. Purpose Calculated Fields Use this script to sum the values of number fields on the form and place the result in a destination field. 17 you can use the reserved word [unique] in order to check for field's value uniqueness. For example I have a drop-down field on a user form that has 2 drop down fields named RequestType and RequestorArea Apr 28, 2025 · Hi, I have couple of problems where I need help 1. See Multiple ways to show your form data in Confluence with ConfiForms These are the basic concepts you need to begin creating ConfiForms. Here we need 2 rules, because we want to show some field based on the selection and hide otherwise. I have a form for which there should be preset users added in specific fields, including User fields with 1 and User fields with 2 users to prepopulate. However, when we try to edit the entry through Edit Control, the "total" will be added several times, sometimes 8x, 9x, or 11x. I have tried referencing the array via a Formula field type and the expression as: "[myfield. Let's assume that the multi-select user field is named: Requestor (ConfiForms Field Definition's field name) Then to get the values stored in this field in IFTTT macro body (to create a page or send an email) you will need to do the following: Apr 30, 2024 · I have a confiform field definition macro for name. asList Feb 4, 2025 · Under the field "Page where the ConfiForms Form is defined" to configure the smart multi-select field, I am only able to select a form on the same page in which I am building the multi-select field. 2 custom metadata fields are injected into the dataset _sourcePage - of type page _sourceForm - of type text Referencing this fields via ConfiForms Field macro will show the source Sep 10, 2024 · Field "R" is a dropdown field (High/Medium/Low) When the user selects their choice a Set Value rule sets the Numeric Field "RScore" to a number (30/20/10) The same for Fields "O" and "OScore" The Field "Score" is a Formula field with the above formula. Supports filtering per field as well as free text search (filter to match against any field value). Operators AND and OR are case-sensitive! (as everything else in You can show the data stored with ConfiForms in various ways as table, using ConfiForms TableView macro - best for showing your form's data in a tabular form as card, using ConfiForms CardView macro - best for showing the data in a card as calendar - grouping by date/datefield field and showing the contents of a form in a calendar as list / wysiwyg, using ConfiForms ListView macro - best for Feb 13, 2019 · So as an Executive Assistant, I'm a total novice with confiforms & macros in general so any assistance will be greatly appreciated. We will define a form with 3 fields: text, textarea and date We will also have a Apr 4, 2023 · Solved: Hi there want to set a value based on calculating 2 dates field, here is what I have Date field 1 = dateF1 Date field 2 = dateF2 Status field You can set multiple fields in the "actionable field name" parameter, by using comma separated value list: field1,anotherfield,field3 You can do the same with 1st parameter in the ConfiForms Rules for Field Definition macro - and "bound" your rule to track changes in multiple fields (1 rule on multiple fields). Jan 7, 2025 · The below table explains in detail the functions that can be used to create calculated fields. I'm creating an incident reporting form using cloud version of ConfiForms Each record stored with ConfiForms has the following fields stored in addition id - record internal id (UUID), unique for every saved record within dataset ownedBy - the username (s) of the users who own the record (and can fully control it) - multi-value field! Multiple users can own a record! ownedByName - the full name of the user who owns the record Use ownedBy. But the result shall be shown before saving the form. We have 4 type of fields which can be backed by a database: DB Dropdown DB Multi-select Jan 22, 2025 · I am trying to set a filter in FormView Registration Controll a Field (Dropdown type) that should filter valies from other Field that is defined on another page. Essential pages you need to check when you start with ConfiForms app ConfiForms is very flexible at how it can show the data your store. So I need multiple IF statements for the criteria, but when I try, the syntax fails. Lemail to access the Lemail field that corresponds to the TeamName Alex Mar 17, 2021 · Hi Team, I have a table created in excel, which contains calculation on rows/ columns (simple calculation like adding/multiplying/ dividing numbers). They are custom fields, I have tried defining them as cf00000 or customfield00000 but nothing works. It works fine when submitting the form. Configuration You can easily set up the Field Definition to be required via macro parameters But what if you need the field to have a value only when some other field is set? Aug 24, 2018 · I'm working on a time-off request system using Confiforms in Confluence, and I'm looking for a way to calculate the number of completed vacation days an employee has taken for the year. Apr 26, 2023 · Yes, that's right Calculated on create/update If you need it to be a unique or user specific each time then I guess this needs to be something with "asLink" function (as well as "prepend/append"). At the moment you need to have a 2 step process to create a record in master form and then start adding your "blocks" We would like to show you a description here but the site won’t allow us. The rule works if the field is empty; the message is displayed. 13 (DC/Server, and also available in ConfiForms cloud) we have introduced a new field to help you with configuring fields that take their values from the fields in Jira. In ConfiForms we try to use the same classes and styles as your Confluence uses. There is a way to reference the source of the automerged record. Bear in mind that I cannot use spaces or special Nov 1, 2024 · Solved: Hi Everyone, i found the following article for hiding / unhiding confiforms fields: Dec 6, 2021 · Works for me as well in a forumla or calculate field. I want to create the same table in Confluence. Basically the answer is simple: ConfiForms uses the global format configured in your Confluence installation for date and date time. We will use built-in HTML macro (disabled by default in Confluence), but you can do the same thing using Confluence custom User Macro. I tested that way: "Apply filter on choices": myPage. _today. Nesting expressions is possible Supports filtering for expressions that start with a wild-card. I tested the regular expression in regex101. Is there a way to accomplish this? Jun 24, 2020 · Solved: I have a form, with a field that is calculated during registration / entry. The issue is, I have many Sections with fields under them, and as a result it is hard for users to determine which Section is what. See the details below form uses standard registration control ConfiForms plugin uses 'Lucene like' syntax for expressions, supports grouping using parenthesis and AND/OR logical operators. in my Values to Set: IssueDescription=[entry. I am using a "Simple Date" field type, but I would like to disable that and have the date the form is being submitted on be the one selected. And also to create various types of cool things around ConfiForms and Confluence. There are 2 types of filtering rules: Apply filter on field Apply filter based on criteria Apply filter on field This is quite an easy one to use - you choose NB! Since version 2. Jul 24, 2018 · I have tried several 'ConfiForms Rules for Field Definition' according to the different possible options. May 26, 2025 · Hello everyone, hello Alex (probably :D), In Confiforms, I want to assign a default status to newly created records. I believe that the “Validation rule (dataset)” option on the Confiforms Field Definition Rules is t Aug 31, 2023 · Solved: I have a ConfiForms form with some fields. If you wish to have a free text search with custom layout then add a ConfiForms Field macro inside the Filter Control macro body and set it's field name parameter to * (wildcard) Oct 2, 2024 · ConfiForms does not enforces any limits by default, but you can implement own validation rules to check the length of the field (https://wiki. Jun 3, 2024 May 4, 2022. Add the Table Filter macro to the ConfiForms TableView macro. Option 1 Option 2 Option 3 Now i need to create Field 2 which should be visible only if Option 2 is checked. The functions are divided into 4 categories Dec 3, 2024 · Hi Alex (guessing), I have created a working ConfiForm within Confluence that creates JIRAs, but some fields are not being populated into the JIRAs. May 3, 2024 · Solved: I want to send emails displaying the user names of a multi-select user field in confiForms. duzxxv vdafnr qbqe csvzze vddw ztbciv jyzua etxc beomil ovordf yeh nknqkkx vxfulx vtwd pum