Community resources
Community resources
Community resources
- Community
- Products
- Confluence
- Questions
- Confiforms: Autogenerated IDs
Confiforms: Autogenerated IDs
I need help with autogenerating id in my form. I have nested forms: project id in my main form and task id my smart multi row I have a taskid.
I need task id to begin at one for each project created. Here is an example:
| Project ID | Project Name | ||||||
| 1 | Test 1 | Task ID | Activities | Start Date | End Date | Status | Owner |
| 1 | |||||||
| 2 | |||||||
| 3 | |||||||
| Project ID | Project Name | ||||||
| 2 | Test 2 | Task ID | Activities | Start Date | End Date | Status | Owner |
| 1 | |||||||
| 2 | |||||||
| 3 | |||||||
| Project ID | Project Name | ||||||
| 3 | Test 3 | Task ID | Activities | Start Date | End Date | Status | Owner |
| 1 | |||||||
| 2 | |||||||
| 3 | |||||||
<hr />
<p />
<ac:structured-macro ac:name="confiform-table" ac:schema-version="1" data-layout="default" ac:local-id="6f8638e0-a796-4af4-8da5-c6c329b770d0" ac:macro-id="bd515667f87fc102cd03ea2d05bca216ff0f2459dd3fa62a9ff1df32bcd77ee4">
<ac:parameter ac:name="pager">100</ac:parameter>
<ac:parameter ac:name="formName">Project</ac:parameter>
<ac:parameter ac:name="exportFields">Project ID, Project Name, Tasks, Task ID, Activities, Task Start Date, Task End Date, Owner</ac:parameter>
<ac:parameter ac:name="distinct">ProjectID</ac:parameter>
<ac:parameter ac:name="inlineEdit">true</ac:parameter>
<ac:parameter ac:name="sort">ProjectID ASC</ac:parameter>
<ac:parameter ac:name="export">true</ac:parameter>
<ac:parameter ac:name="enableSearch">true</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:name="confiform-field" ac:schema-version="1" data-layout="default" ac:local-id="52dcdfcc-dd25-4bac-81ff-3fbd55fbdaaa" ac:macro-id="99d42f14-a437-4909-8382-ff0352f70341">
<ac:parameter ac:name="fieldName">ProjectID</ac:parameter>
<ac:parameter ac:name="title">Project ID</ac:parameter>
<ac:parameter ac:name="macroHash">-1280310195</ac:parameter>
</ac:structured-macro>
</p>
<p><ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:local-id="40e732c3-af02-4c32-9bcd-27e37b1966ad" ac:macro-id="6c19561e-6081-4fa2-8762-82d86de76263"><ac:parameter ac:name="fieldName">ProjectName</ac:parameter><ac:parameter ac:name="title">Project Name</ac:parameter><ac:parameter ac:name="macroHash">-949384787</ac:parameter></ac:structured-macro> <ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:local-id="bb5ed93d-c9aa-4db0-803f-a4e2cf2f3107" ac:macro-id="a34ea331-541b-44a6-bd04-99a799e21bc6"><ac:parameter ac:name="fieldName">Tasks</ac:parameter><ac:parameter ac:name="title">Tasks</ac:parameter><ac:parameter ac:name="macroHash">-906395999</ac:parameter></ac:structured-macro></p>
</ac:rich-text-body>
</ac:structured-macro>
<p />
<p />
<ac:structured-macro ac:name="confiform-entry-register" ac:schema-version="1" data-layout="default" ac:local-id="d83c5717-6a80-41da-b68b-da943143dc1c" ac:macro-id="e8e88d0a636ed59921dc3f7a2c020bcb91dd5aa795f8074fc2f03f9d984f1041">
<ac:parameter ac:name="redirectMode">Edit</ac:parameter>
<ac:parameter ac:name="formName">Project</ac:parameter>
<ac:parameter ac:name="formTitle">Add New Project</ac:parameter>
<ac:parameter ac:name="presetValues">Project</ac:parameter>
<ac:parameter ac:name="registrationButtonLabel">Add New Project</ac:parameter>
<ac:parameter ac:name="type">Button</ac:parameter>
<ac:parameter ac:name="autofocus">true</ac:parameter>
<ac:parameter ac:name="autoAlign">true</ac:parameter>
<ac:parameter ac:name="showMessageAs">Above the form</ac:parameter>
<ac:parameter ac:name="useFullWidth">true</ac:parameter>
<ac:parameter ac:name="afterSubmit">Form reload</ac:parameter>
<ac:rich-text-body>
<p />
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:name="confiform" ac:schema-version="1" data-layout="default" ac:local-id="a3476c71-5087-4e52-836c-bcd2a2660197" ac:macro-id="eb9640ab7d5c59cc59f4f9460b4ef29e110f20b9341d1a04b7215cea2edaaefa">
<ac:parameter ac:name="formName">Project</ac:parameter>
<ac:parameter ac:name="storageType">Atlassian</ac:parameter>
<ac:parameter ac:name="registrationFormTitle">ADD PROJECT Form</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" data-layout="default" ac:local-id="0fdf8e11-055b-4c9a-af4f-460c2e76ac27" ac:macro-id="69a39c1a-b6e9-49cf-b0e2-0523867bf354">
<ac:parameter ac:name="mapping">|CDOP: Project Number|undefined</ac:parameter>
<ac:parameter ac:name="fieldName">ProjectID</ac:parameter>
<ac:parameter ac:name="fieldLabel">Project ID</ac:parameter>
<ac:parameter ac:name="validationMessage">Required Field</ac:parameter>
<ac:parameter ac:name="extras">number:</ac:parameter>
<ac:parameter ac:name="type">auto</ac:parameter>
<ac:parameter ac:name="separator">CDOP: Project Number</ac:parameter>
<ac:parameter ac:name="macroHash">-153435784</ac:parameter>
</ac:structured-macro>
<ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" data-layout="default" ac:local-id="d1fd8131-cb1c-4d77-80e5-eb96ddfb4e8b" ac:macro-id="032f35b2-0135-4aac-865e-3407387acf76">
<ac:parameter ac:name="fieldName">ProjectName</ac:parameter>
<ac:parameter ac:name="fieldLabel">Project Name</ac:parameter>
<ac:parameter ac:name="validationMessage">Required Field </ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
<ac:parameter ac:name="separator">false</ac:parameter>
<ac:parameter ac:name="macroHash">-1700712645</ac:parameter>
</ac:structured-macro>
<ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" data-layout="default" ac:local-id="0f6c1762-143d-4998-96ea-1dc262e73e82" ac:macro-id="40943c2e-e9e3-467d-beae-fbc5cdc1c00e">
<ac:parameter ac:name="fieldName">Tasks</ac:parameter>
<ac:parameter ac:name="fieldLabel">Tasks</ac:parameter>
<ac:parameter ac:name="values">[689210795|F2|TaskID,Activities,TaskStartDate,TaskEndDate,TaskStatus,Owner,]</ac:parameter>
<ac:parameter ac:name="extras">card</ac:parameter>
<ac:parameter ac:name="type">smartmultirow</ac:parameter>
<ac:parameter ac:name="separator">false</ac:parameter>
<ac:parameter ac:name="macroHash">-588507215</ac:parameter>
</ac:structured-macro>
<ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" data-layout="default" ac:local-id="ecbfda3d-dda6-41f2-b228-731be9e95718" ac:macro-id="2c99cbde-77ce-4e28-b9ae-1aad99ed0b63">
<ac:parameter ac:name="fieldName">recordIDs</ac:parameter>
<ac:parameter ac:name="extras">true</ac:parameter>
<ac:parameter ac:name="type">autopage</ac:parameter>
<ac:parameter ac:name="required">true</ac:parameter>
<ac:parameter ac:name="macroHash">-1377615954</ac:parameter>
</ac:structured-macro>
</ac:rich-text-body>
</ac:structured-macro>
<p />
<ac:structured-macro ac:name="confiform-entry-register" ac:schema-version="1" data-layout="default" ac:local-id="8cec478b-420b-48f1-858a-d2ea9a673a55" ac:macro-id="8b55bb93f508762c52555fe819ce00dd2a413f106707654c6d4369fe5b0909ec">
<ac:parameter ac:name="redirectMode">Edit</ac:parameter>
<ac:parameter ac:name="formName">F2</ac:parameter>
<ac:parameter ac:name="formTitle">ADD ACTIVITIES FORM</ac:parameter>
<ac:parameter ac:name="presetValues">TaskID</ac:parameter>
<ac:parameter ac:name="registrationButtonLabel">ADD ACTIVITIES FORM</ac:parameter>
<ac:parameter ac:name="type">Link</ac:parameter>
<ac:parameter ac:name="autofocus">true</ac:parameter>
<ac:parameter ac:name="autoAlign">true</ac:parameter>
<ac:parameter ac:name="showMessageAs">Above the form</ac:parameter>
<ac:parameter ac:name="useFullWidth">true</ac:parameter>
<ac:parameter ac:name="afterSubmit">Form reload</ac:parameter>
<ac:rich-text-body>
<p />
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:name="confiform" ac:schema-version="1" data-layout="full-width" ac:local-id="252417cf-fbf9-4017-b7f1-833e7c69c7de" ac:macro-id="6d119b9de0fd3737064fbfebb1ab866f1f769b71af1fa450d31e5f237d34088e">
<ac:parameter ac:name="formName">F2</ac:parameter>
<ac:parameter ac:name="secureStorage">true</ac:parameter>
<ac:parameter ac:name="storageType">Atlassian</ac:parameter>
<ac:parameter ac:name="registrationFormTitle">Add Task</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" data-layout="full-width" ac:local-id="a26440b2-8449-47ce-a160-c1c69e10481b" ac:macro-id="dc181f07-11bb-4272-b038-4c8803f54159">
<ac:parameter ac:name="css">min-width:75px;width:75px;</ac:parameter>
<ac:parameter ac:name="mapping">|CDOP: Project Number|undefined</ac:parameter>
<ac:parameter ac:name="fieldName">TaskID</ac:parameter>
<ac:parameter ac:name="fieldLabel">Task ID</ac:parameter>
<ac:parameter ac:name="validationMessage">Required Field</ac:parameter>
<ac:parameter ac:name="type">auto</ac:parameter>
<ac:parameter ac:name="separator">CDOP: Project Number</ac:parameter>
<ac:parameter ac:name="macroHash">1095699854</ac:parameter>
</ac:structured-macro>
<ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" data-layout="full-width" ac:local-id="9487cb39-ad9c-45d7-ab4f-c24f67dd7841" ac:macro-id="22eb25e3-e98b-48c0-93a1-ad2d7ececf0c">
<ac:parameter ac:name="mapping">|CDOP: Project Number|undefined</ac:parameter>
<ac:parameter ac:name="fieldName">Activities</ac:parameter>
<ac:parameter ac:name="fieldLabel">Activities</ac:parameter>
<ac:parameter ac:name="validationMessage">Required Field</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
<ac:parameter ac:name="separator">CDOP: Project Number</ac:parameter>
<ac:parameter ac:name="required">true</ac:parameter>
<ac:parameter ac:name="macroHash">734470087</ac:parameter>
</ac:structured-macro>
<ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" data-layout="default" ac:local-id="e06ab576-5160-436b-8a3d-888ea7fde5a2" ac:macro-id="b462dbe6-4561-46de-a06a-15eb52832bda">
<ac:parameter ac:name="fieldName">TaskStartDate</ac:parameter>
<ac:parameter ac:name="fieldLabel">Start Date</ac:parameter>
<ac:parameter ac:name="extras">MM/DD/YY</ac:parameter>
<ac:parameter ac:name="type">date</ac:parameter>
<ac:parameter ac:name="macroHash">74177683</ac:parameter>
</ac:structured-macro>
<ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" data-layout="default" ac:local-id="dd2182a6-a1ee-4449-8450-227a701c158f" ac:macro-id="713d9856-0773-4d49-9f86-0c0790b1e880">
<ac:parameter ac:name="fieldName">TaskEndDate</ac:parameter>
<ac:parameter ac:name="fieldLabel">End Date</ac:parameter>
<ac:parameter ac:name="extras">MM/DD/YY</ac:parameter>
<ac:parameter ac:name="type">date</ac:parameter>
<ac:parameter ac:name="macroHash">1621629491</ac:parameter>
</ac:structured-macro>
<ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" data-layout="default" ac:local-id="72453110-484a-45b2-bfa6-6cc5c1ae2084" ac:macro-id="2140e3a2-41ca-44a9-9a30-b5b8d59d921b">
<ac:parameter ac:name="fieldName">TaskStatus</ac:parameter>
<ac:parameter ac:name="fieldLabel">Status</ac:parameter>
<ac:parameter ac:name="values">1=G|2=A|3=R|4=C|5 =N|</ac:parameter>
<ac:parameter ac:name="validationMessage">Required Field</ac:parameter>
<ac:parameter ac:name="type">select</ac:parameter>
<ac:parameter ac:name="macroHash">-227705458</ac:parameter>
</ac:structured-macro>
<ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" data-layout="default" ac:local-id="bf383a92-876c-496e-83fa-5f3bf1b775b5" ac:macro-id="7a9b2856-258e-4534-965a-acb495ed9109">
<ac:parameter ac:name="fieldName">Owner</ac:parameter>
<ac:parameter ac:name="fieldLabel">Owner</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
<ac:parameter ac:name="macroHash">1797796308</ac:parameter>
</ac:structured-macro>
</ac:rich-text-body>
</ac:structured-macro>
<p />
1 answer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.