Foundation

Does Appian support changing configuration settings without downtime? Does Appian support existing database components like stored procedure for querying data? Can we implement custom styling for existing Appian UI components?

Hello Community, I want to make an editable grid with fields having below details Column Names -  studentCountry  , studentName, subject , status - (Pass or Fail)I've Created the grid where the studentName will be repeating and read only because of the different subjects  & also  subject will be read only-> the user (teacher) should fill the studentCountry and his status - (Pass or Fail) in editable grid,Now my requirement is such that when a teacher selects student country for a particular student it should update the studentCountry for all the rows having that particular student name.How should I achieve this. Any suggestion will helpful.Some sample data for better understanding      studentCountry    studentName   subject        status1)   dropdown             Student A         Maths          Ye

Hi all I am trying to export data store entity into excel via the process model and am receiving the following error. Kindly help out in this regard. Error:  An error occurred while attempting to setup the export for VOPS data. Please contact your system administrator for additional details. (APNX-1-4505-054)

Hi, Reg: Need an advise in pushing the huge volume of XML data to database tables. Using the SFTP smart service, I am receiving the complex structured .xml file which holds ~200 MB of data in Appian. Now I am looking for a optimal design/solution to push the entire file data into staging tables of the mariaDB. Could anyone help me out with the steps how can I approach this particular situation? Any suggestions would be really appreciated.

there is requirement for a form to be moved to the next step(automatically submits) after a fixed time how could we implement this any ideas?

I would like the description of my own functions (expression rules) to appear the same way as the description of Appian's built-in functions. I wonder whether that is possible by using some sort of mark-up in the description of the functions (Properties -> Description) - something à la JavaDoc? Specifically, I would like to mark-up descriptions of arguments and return value, so as to make them appear like in this example: Regards, Søren Juul

Hello There,  I am getting this error,:"Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!imageField [line 182]: The image at index 1 in an image gallery component [label="Image"] has an invalid value for "document". "document" must not be null." Visibility: not(rule!FOV_ISNull('recordType!{cdcf96e7-71f5-4a66-90e4-9d29efd1a922}FOV Vehicle.fields.{7924e1ce-3938-4fbb-aae4-8636d37e830c}imageId')) a!documentImage( document: ri!record['recordType!{cdcf96e7-71f5-4a66-90e4-9d29efd1a922}FOV Vehicle.fields.{7924e1ce-3938-4fbb-aae4-8636d37e830c}imageId'], showWhen: not(rule!FOV_ISNull('recordType!{cdcf96e7-71f5-4a66-90e4-9d29efd1a922}FOV Vehicle.fields.{7924e1ce-3938-4fbb-aae4-8636d37e830c}imageId'))) I have a list of cars some have images other not (null), How can I fix it?   

I have this dictionary that I want to extract values from depending on one of its values: a!localVariables( local!myDictionary: { { user : { info :{ { name: {codeValue: 1, nameValue: "engineer"}, type : { codeValue: "role", nameValue: "role" } }, { name: {codeValue: "s101", nameValue: "science"}, type : { codeValue: "dept", nameValue: "dept" } } } } }, { user: { {},{} } } }, local!tempResults: //maybe too much going on index( if(isnull(property(local!myDictionary.user,"info",null)),"",local!myDictionary.user.info) ,if(isnull(property(local!myDictionary.user,"info",null)),"",wherecontains("role",touniformstring(local!myDictionary.user.info.type.nameValue))),""), local!tempResults ) I'm wanting to return either the 'codeValue' or 'nameValue' from 'name' (ie.1,engineer,s101,science), depending if the &#39

I have a requirement where I have to export form data to excel. I am using excel template to populate data in specified cells using "cell keys" and "cell values" but data is not coming properly. Expected Output should look like- column C,D,E are coming up additionally. Could anyone help me how to correct this. Below is the current configuration: CDT- pv!cdt, cell values- {  "B2",  "B3",  "B4",  "B5"} cell values-{pv!cdt.f1,pv!cdt.f2,pv!cdt.f3,pv!cdt.f4} Document_name_to_create- "Form Fields" Document_save_directory-cons!Folder Excel_base_template- cons!excelTemplate Include_header_row-false sheet_number-0 Starting_cell-"B1"

Hi all, I have this array of images: local!imgs: { "example","example","example","example","example","example","example", } I want to display for the user each 3 images in separate row. I need the output to be something like this: Thanks in advance,,

Hi all, I have this array of images: local!imgs: { "example","example","example","example","example","example","example", } I want to display for the user each 3 images in separate row. This is my image field will look like: a!imageField( label: "", images: a!forEach( items: { "example" }, expression: a!userImage( user: fv!item ) ), size: "LARGE", style: "AVATAR" ) I need the output to be something like this: Thanks in advance,,

Hi all, I have this array of images: local!imgs: { "example","example","example","example","example","example","example", } I want to display for the user each 3 images in separate row. This is my image field will look like: a!imageField( label: "", images: a!forEach( items: { "example" }, expression: a!userImage( user: fv!item ) ), size: "LARGE", style: "AVATAR" ) I need the output to be something like this: Thanks in advance,,

So the way the group picker filter works is you put a group in that filter and the picker shows any groups that are children of that group. Is there any way to also display that parent group as well? I'd like to show just the groups within a particular application so I'm using the application's all users group for the filter, but it doesn't show the all users group. I would rather not add some other group to put that all users group into if I can avoid it. Is there another option? If there's some other way to specify groups that are added to an application instead of the entire environment, I'd be open to that as well. 

Hi! I am trying to employ the Intelligent Document Processing application to extract data from identity documents using Appian as the vendor.In some cases, on the reconciliation interface appears an exlamation triangle showing the following message: By examining the process model, it should be due to the "Start Doc Extraction Smart Service" and "Reconcile Doc Extraction Smart Service" nodes, however their behaviour is not explicitly clear. Therefore, my questions are: Why does it show the above message? What does this behaviour depend on? Only on the OCR and on the quality of the images or are there more influencing factors? Is there any detailed source of information that explains in detail how the two aforementioned Smart Services and the Appian Document Extraction algorithm work? (Yes, I have already read the relative documentation and I am looking for in-depth information) Thank you in advance for all the help that you will be able to provide. Massim

Hi, I was trying to get Employee related data by executing a stored procedure with the help of "Execute Stored Procedure" smart service in a process model. To get the data, in "Output" tab of Data I have selected a variable as Target variable and type of which is employee CDT. There is a section with the name "Expression". What should I write at "Expression"? Because at the time of publishing it is showing error as follows:   The Output tab: Can any one please let me know what should I write at Expression box, so that I can get the employee data which is returned by the store procedure at Appian end?

My question is, if it is possible to go through a process node twice. Here is an example (I understand this could be designed better with a subprocess etc). The process initially saves data from the form into the TravelRequest DB table. If there is a comment it saves it to the Comments DB table. Later the Supervisor adds another comment through a user input task.  Looking at the process details I can see it does not go through the gateway a second time. Kind regards,

Hello! I have a requirment to have a complex gateway connected to 15 tasks star some  those tasks, finish them, then end the process. I am trying to figure out how have a gateway that goes forward only when the handful of tasks started complete. Here is a few examples. Process starts with a parameter of "Billing". My complex gateway starts tasks 5, 6, 8, 10, 11, & 12. Those tasks finish.  Meeting at some kind of end gateway.  Gateway somehow knows i want to proceed and the flow goes to the end node.(this is the part i need help with) Process starts with a parameter of "QA". My complex gateway starts tasks 4, 5. Those tasks finish.  Meeting at some kind of end gateway.  Gateway somehow knows i want to proceed and the flow goes to the end node. How do I make a gateway to deal with these incoming flows?  AND gates would wait for all 15 every time, complex doesn't work because the paths that need to complete are different so

Hello, I have a similar question to: https://community.appian.com/discussions/f/rules/21530/getting-one-property-value-from-dictionary-based-upon-another-property-value. But instead of returning true/false, I need it to match it against a string value on match condition: a!localVariables( local!myDictionary: { { item: 1, active: "A", description: "Widget", color: "Green"}, { item: 2, active:"B", description: "another", color: "red"} }, local!tempResults: if(fn!index(local!myDictionary,"active","") = "A" ,"yes","no"), reject(fn!isnull, local!tempResults) ) The index returns the "A", but when I do a condition against it (if statement), nothing returns. I want the string "Green" returned if it matches "A". IT says it doesn't match it.

How to remove extra carriage return on a generated text file in Appian 0085117,000011.55,000011.55CRLF0052514,000035.00,000035.00CRLFCRLF

How to configure stored procedures output parameters in execute stored procedures smart service to get data output from DB

Hi All, Is there any way that we can configure a default password for all the users created by create users smart service . Thanks in advance

Hi there, I have an interface, normally there is drop down which has multiple options, use select one, then click button "Next"("Submit" button) to get out to different interfaces. but the user want to just choose the option without clicking "Next" button, then system can automatically go to next one. any suggestion how to do it? I know in Appian you have to click a "Submit" button to  get out. and heard someone mentioned can set the timer, but dont have any idea. can anyone help here? Thanks. Lin

Hello , Is there any way to import an object even if it has a dependency not found? I can't access the application environment because it was an appian test environment and it has been removed. I only have the export package

Hi, I  would like to create an interface where it will add/insert multiple CDT (a Parent one) and it's child CDT ( one to many ). I am not using nested CDT. Once the user enter the details, in the process model, it will insert to respective DSE. I am finding difficulty to identify the primary key of each parent and update to its respective child CDT. How can I achieve this? Use Case: An interface where the user can multiple invoices and multiple line items for each invoice without using nested CDT. Regards, Surjit

I have a form, which is filled out by the Employee and then send as a task to the supervisor to review. As I understand the ID is generated in the table, therefore this information is not available intially when the user inputs the data. What therefore happens on the second write to DSE is that it creates a completely new record, with the status change as the difference as that is something i manually change in the DSE.  What I would need, is to provide the second Write to DSE with record ID that the first "Write to DSE" created in the DB. How can this be done? ------------------------------------------------------------------------------------------ I looked at the reference app, because there the process creates a new vehicle maintainance and records it. However I have not found how this ID is retrieved. A script task is created: which calls a expression rule.