Foundation

Hi All ,  I want to generate a table inside a word doc. I am trying "MS Word 2007 Doc from Template" but unable to create a table. In other threads i see someone recommended "Advanced Document Templating" plugin.  Please can someone share a sample code for this.  sample table  UserName Project ABC 22222 Xyz 33333 Thanks!

Hi All, I have my expression rule as below and I'm trying to get 100 records in 1 batch to pass to the process model. Now I need to fetch the 1st row from this rule output into a process model - perform some action and then loop back to fetch the second row - perform some action, loop back third record to fetch 3rd row and so on until I reach my 100th record. Please advise what expression do I need to write here to fetch the rows and loop back? Rule:a!localVariables(local!getData: a!queryEntity_22r2( entity: cons!SAC_ENTITY_CLIENTCASES, fetchTotalCount: true, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { ), a!queryFilter( field: "docsSent", operator: "is null" ) } ), selection: a!querySelection( columns: { a!queryColumn(field: "caseId"),a!queryColumn(field: "caseStatus"), a!queryColumn(field: "clientName"), a!queryColumn(field: "folderId") } ), pagingInfo: if( rule!APN_i

Hi I am trying something like this , I have editable grid for which data will be populated from local!data of type AB recordtype , I want to edit the row data and select them and save into another recordtype thorugh a rule input , I want to add new row also but when i try the rule input is getting updated but the grid row is not created and when i try to edit the pouplated data its not getting saved. I know im missing something I am a  beginner so can anyone guide me achive my requirement?  a!localVariables( local!datatype: a!queryRecordType( recordType: { 'recordType!{479ce76d-f462-432e-80f8-34a12cfb2725}RPM Candidate', }, fields: { 'recordType!{479ce76d-f462-432e-80f8-34a12cfb2725}RPM Candidate.fields.{6f148197-c427-48b6-a52c-0f8c403c81e2}id', }, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 100) ), a!sectionLayout( label: "", contents: { a!gridLayout( label: "Editable Grid",

Hi Team! I have a requirement and would like to know if anyone has faced a similar situation or has suggestions on how to approach it. Scenario:I have an interface where the user can dynamically add N sections. Each section has a unique ID (provided by the user) and a fixed set of fields (the same for all sections), but with different data. Example: The user adds 2 sections: ID 1 and ID 2. Each section contains the same fields (e.g., name, date, value), but with different values. At the end, I need to generate a dynamic PDF document that reflects exactly those sections and their data. Requirement:The generated document should include one section per user entry, with the corresponding data mapped correctly. If the user adds 5 sections, the document should have 5 blocks with the respective data. My question:What would be the best approach to generate this kind of dynamic document in Appian? Is it possible to do this using Document Generation? Do I ne

Hi All, I have a use case where I'm querying data from database table of 100 records set in paging Info. Now, Once I pass this data from my rule to process model, I need to extract the records one by one, perform some action on them and write to DB and then loop back again in the same process model to fetch the 2nd row data and repeat this in batches. My question is how do I fetch the data from a batch of 100 records and to get only one row and then 2nd row and so on without using an MNI? Please advise. 

= getdistinctusers(topeople(cons!IP_GRP_ALERTS)), a!queryRecordType( recordType: 'recordType!{3a27d5e6-31ce-4fe1-995f-821c7e573c8a}IP Add Details.fields.{7340349a-5cf6-4b92-a093-9d1d261d7be2}candidateMail', fields: 'recordType!{3a27d5e6-31ce-4fe1-995f-821c7e573c8a}IP Add Details.fields.{7340349a-5cf6-4b92-a093-9d1d261d7be2}candidateMail', filters: a!queryFilter( field: 'recordType!{3a27d5e6-31ce-4fe1-995f-821c7e573c8a}IP Add Details.fields.{7340349a-5cf6-4b92-a093-9d1d261d7be2}candidateMail', operator: "=", value: true ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500) ).data I am using the send email smart service and i used the "topeople" function to send the email to the group members first and then again i used the "user()" function to return a specific info from a field. Is this the correct way ?

What is the difference between process model with End Node and process model with End Node and Terminate Process?

Hi All, Since last week i am facing Appian slowness issue, for me all Appian environments are slow but working perfectly for other users. Tried opening in other browsers / Incognito mode cleared cache and other browsers settings but still facing same issue

  (Please ignore the text in the to field it was just somethings i was trying which is unrelated to the doubt i have asked below) So, as shown in the above image i am using a send email smart service. And in the to field, whenever i mention a specific user email its sending them the email without any issue, but when i choose a group its not. I don't get an email at all when i place a group in the to field. Can anyone help me what i'm supposed to do in such cases.Thanks and regards.

I would like to suggest a feature that allows the reuse of a package across different environments such as DEV, TEST, and PROD. So, whenever I create a package named "MY PACKAGE" in DEV and deploy it to TEST, I would like to be able to select this package in TEST as well (as it is already imported), and then deploy it to PROD with a few clicks Currently, I have to recreate the same package in TEST, because there is no other option to deal with it. At least, I haven't found it yet. Does anyone have any hint on this? Thanks in advance.

How can we achieve a field level audit . Can someone suggest step by step .

This error popped up when i was trying some things in the interface, now i'm stuck with this error i don't know what this error means, can anyone help me understand about this error.

So as you can see in the above pic i have 2 different fields and for both the fields i have used multiple dropdown option and i have used the same functions for them. But unfortunately, the multiple dropdown is working only for the status field and not working for the commitment field. i.e, when i try to select more than one option in the multiple dropdown field, it shows an error. . . . . "Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!wizardLayout [line 3]: A multiple dropdown component [label="Commitment"] has an invalid value for "value". All selected values must be present in the choiceValues array, but value was Career Growth and Learning; Work-Life Balance and choiceValues was Career Growth and Learning; Work-Life Balance; Environment Sustainability." . . . . Can anyone help me out with where i did the mistake.

can anyone help me. i have checked the process variables those all are correct, i configured the setup, output node. but i don't know why this error is coming. 

Hi everyone, I am working on a task where I want to compare values in a read-only grid. The data in the field consists of text-type values, for example: k(100), k(101), SH(300). While applying filters in the read-only grid, I want data whose values are greater than 100. Here, we should check only the number in the text. is there any possibility to achieve this functionality

Removed

The above image shows that i gave the field security so thats its visible to only particular groups, but when i accessed the interface from being in that group, i was unable to see the field even though i assigned the security so that it was visible to that particular group.

Hello All, Redirected to "Access Denied Page" if I enter  ../ in the text box, is this expected? a!localVariables( local!searchKeyword, a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Search By Keyword", value: local!searchKeyword, saveInto: { local!searchKeyword, a!save( local!searchKeyword, trim(local!searchKeyword) ) }, refreshAfter: "KEYPRESS" ) } ) } ) ) Key in../ and click on enter, then the page below is displayed, any idea why? Application logs:

a!richTextDisplayField( value: a!richTextItem( text: "Download Document", link: a!documentDownloadLink( document: todocument(110854) ) ) ) I am trying to download a document (The document exists in the folder ) but it is giving an error like: { "error": "APNX-1-0000-000", "message": "Unable to find File for content object with id: 110829", "title": "An Error Has Occurred" }

Is to possible to save useris, timestamp  and other details to database when user Accepts or reassign the task using default buttons shown below.

Hi every one,  My team wants set up a connected system with MS teams, but having no idea how to start. Is there any documentation or could you explain to me where can I find the data to input into the fields in below screenshot please?  Thanks so much,

The process model is showing as invalid, but there are no logs indicating the reason for the invalid status. I’ve reviewed all subprocesses, and they appear to be valid. What could be the possible cause? Is there a standard or recommended approach to debugging this issue?

I am doing example "Build an Application: Step 10". This is where you build from scratch a simple process model to enter in a maintenance request. Everything work fine from the process start form to writing the data back to the Maintenance recordType. However, the XOR cancel does not work. When I click it, the flow process as if I am submitting the form. I followed the step by step instructions exactly. I even completely deleted the XOR and is corresponding End node and rebuilt. Still same thing. 

Hi All, i want to know , how to configure the below logic BY default all the option should be selected. and also in dropdown i can have the option to deselect all /select all along with all the options. Please help me how i can go about this

My company has a huge process model, includes hundreds of nodes and a lot sub process, there are a lot form nodes in this pm, they all having activity chaining and assigned to same user, we are developing on this pm and also have changes on ui and forms. When user finish and submit this form, will automatically redirect to next form node and do next form. Form data is complex list of cdt saves in process variables, and will write to db The problem is, our form can add multiple blocks of a same form, this can make list of data very big, when we added too many form blocks, likely 30 + blocks, then submit, then it shows a little action complete banner, and redirects to home page, but you can countiune this process and find next task in current user’s tasks, user can countiune task with no error. And in process instance monitoring, no error.  I guess it’s data size problem, but I didn’t find a way to resolve this problem, some times there will be a huge form.