Discussion Categories

HI All,  We need to read a formatted text file and then convert it to Excel sheet with headers and data.  We need to create a single row for each supplier details in excel sheet along with the data per headers. Has anyone got such a requirement?  Can you please suggest a way? Sample file is below see attachment/cfs-file/__key/communityserver-discussions-components-files/11/ExpenseReport.txt

Hi Everyone! Recently, we have one requirment, once the claim is submitted by the customer in the Appian portal. we need to generate and send a link to the respective customer via SMS/Whats app. In this, the link is an unauthorized link where customer click the link and acknowledge the form. In the form we need to display all the information in the readonly format and customer will go thorugh the form and acknowledge it. Once customer acknowledge the form, in appian we need to update the status. Is this possible in Appian? Thanks in advane

Hi everyone! I am facing the following issue: I have a toggle button that activates a startProcess!, which is a Process Model designed to update the dates of a list of tasks. This list can contain more than 100 tasks which should be analyzed one by one in an iterative loop in the process model. However, I have noticed that the onSuccess variable, which should be displayed in a grid is not correct . This problem might be due to exceeding the 50-node limit. I have checked the process, and everything appears to be correct including the onSucess variable. Can you advise me on any way to retrieve this variable with the correct values?

Hi I am trying to display file preview for attached documents. We have provided a dynamic link when clicked ,we are calling a PM to fetch the document from Documentum and store it in Appian folder. However the PDF type file does not preview for some users, whereas Dev team with admin access have no issue viewing the preview for the file. FYI it is happening only for PDF type files PNG files seems to be working fine.

hi,  I am trying to use upload Files function. this is one of the step in my process. I have a final summary screen, which shows the files uploaded and they should appear as document upload link.  I used a!submitUploaded files in the next button, which actually goes to fIle Upload Screen to the summary screen.  It works fine , when I tested the interface. But shows an error in site.  An error occurred while executing a save: Expression evaluation error: a!submitUploadedFiles() cannot be evaluated in this environment. Target folder is not Document or Folder but marked as Folder. Also, editor access permissions has been given to the Users for this folder.  

I have a value of type Date, inside two arrays. First array has only one value, Second array has multiple values. When I try to evaluate their typeOf(), I get 54 (Date with Timezone) for first one, & I get 7 (Date) for second one.The question is, why does the data type change for todate(now()) in first and second array ?Code:a!localVariables( local!singleItem: { todate(now()) }, local!listOfVariant: { 2, todate(now()) }, { typeOfSingleItem: a!forEach( items: local!singleItem, expression: typeof(fv!item) ), typesOfListOfVariant: a!forEach( items: local!listOfVariant, expression: typeof(fv!item) ) } ) Screenshot:

Hello, I have a field for mobile numbers in my Appian application, but it is in text format instead of integer. Appian does not support 10 digits as an integer, so I cannot change it. I need to sort this mobile number field on a read-only grid, but it is sorting as a string due to the text format. I need it to be sorted as an integer field.

I am facing a strange issue, I have created a custom record field, which i'm able to fetch the value in the interface, but while checking the Site the value is not getting populated. I am using a one to one relationship to fetch the value from the record. I have tried fetching other fields from the same record, even those are getting populated in the interface but not on the site.  Thanks in Advance! 

Details: javax.persistence.PersistenceException: org.hibernate.id.IdentifierGenerationException: ids for this class must be manually assigned before calling save(): PFYoutubeDT11569: org.hibernate.id.IdentifierGenerationException: ids for this class must be manually assigned before calling save()Why is this error occuring?

this is the UI  using this sequence column from record i have to rearrange the UI columns  how can i achieve this 

Hi, Is it possible to make the line chart smooth, meaning without the data point dots. Regards, Sowvik Roy

I have a map and a dictionary.. How can I merge them and save the output to a datasubset?

I am below error in user interface.Please help to resolve. Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function 'wherecontains' [line 52]: Invalid types, can only act on data of the same type (Text, Any Type) Below is the Code and the place where wherecontains is there is highligted in red.Please help to resolve as to what changes needs to be done. ri!selectedSkuId ), local!selectedSku: a!refreshVariable( refreshAfter: "RECORD_ACTION", refreshOnVarChange: local!selectedSkuId, value: rule!APN_first( index( local!skus, wherecontains( local!selectedSkuId, local!skus['recordType!{9de47fad-3776-4334-bca6-7870632f65f6}NGP_PC_Sku.fields.{821936eb-32c0-4523-ab28-06972108537f}pcSkuId'] ), {} ) ) ), { a!columnsLayout( columns: { a!columnLayout( contents: { rule!NGP_PC_CMPT_skuInfo( skus: local!skus, refCountries: local!refCountries, selectedSkuId: local!selectedSkuId, selectedSku: local!selectedSku, def

Hi Team, In records we can create a text filed filter. Thanks, Nagesh

Member Inclusion with Tick Marks and Non-member Exclusion with Crosses Facing issue in accurately displaying membership status within groups Difficulties in correctly identifying group membership. Seeking assistance. a!localVariables( local!selectedGroup: ri!initialGroup, local!distinctUsers: getdistinctusers({local!selectedGroup}), local!groupMembers: if( a!isNullOrEmpty(local!selectedGroup), "Please select a group", local!distinctUsers ), local!groupName:a!forEach( items: local!selectedGroup, expression: getgroupnames(fv!item) ), { a!sectionLayout( label: "User And Group Management", contents: { a!pickerFieldGroups( label: "Group Picker", labelPosition: "ABOVE", maxSelections: 5, value: ri!initialGroup, saveInto: ri!initialGroup, ) } ), a!sectionLayout( label: "User Information", contents: { a!gridField(

Hello everyone!Scenario: A process gets an unexpected error and stops. (No error management flow, like a rule error) Is there a way to do more than the standard appian alert email and automate a robot or a process that, for example, sends that error information to other system (like opening a ticket in Service Now throguh API). Apart from the main question, what options exist if a customer wants to view all the possible monitoring information in they're own dashboards system? Information like:-Healthcheck dashboards-CPU, Ram, Disk Alerts-System Metrics -Process Alerts -Flow Errores (like integrations) The customer mentioned dynatrace (which Appian does not recomend and we have a cloud environment) and ServiceNow Thanks everyone!

Hi Team, Has anyone come across this error: "An error occurred while executing a save: This page has timed out. Changes you made may not be saved. Click OK to refresh the page." any thoughts on handling this? Actually, we found this error message from Heath check analysis report. Regards,Sandeep

HI All,                    how can I add new user to the community edition. The reason for this is, we both need to work on the same application.

Hello All,I wanted to give appian certifications. I am Appian developer do i need to give analyst certification prior to associate developer?Thanks

Cannot sort by field because it is from a one-to-many record relationship.

We have a Process Model with a User Interface step. In the step there is a related action that launches off another Process model. Is there a way for this newly launched process model to notify the main process model when it is done?

If i want to write records more than 1000 rows sync fails in appian how to avoid that?

a!richTextDisplayField( value: { a!richTextIcon( icon: "check-circle-o", caption: fv!row['recordType!{690a8496-4f15-4d0b-8e98-6ffb8ca39cd8}OE Clients_Compts.fields.{3c17620a-de81-45df-9416-aa7527efb509}podeDeclarar'], link: a!dynamicLink( saveInto: a!save( fv!row, a!update(fv!row, fv!row['recordType!{690a8496-4f15-4d0b-8e98-6ffb8ca39cd8}OE Clients_Compts.fields.{3c17620a-de81-45df-9416-aa7527efb509}podeDeclarar'], not(fv!row['recordType!{690a8496-4f15-4d0b-8e98-6ffb8ca39cd8}OE Clients_Compts.fields.{3c17620a-de81-45df-9416-aa7527efb509}podeDeclarar'])) ) ), showWhen: fv!row['recordType!{690a8496-4f15-4d0b-8e98-6ffb8ca39cd8}OE Clients_Compts.fields.{3c17620a-de81-45df-9416-aa7527efb509}podeDeclarar'] ), a!richTextIcon( icon: "times-circle", caption: fv!row['recordType!{690a8496-4f15-4d0b-8e98-6ffb8ca39cd8}OE Clients_Compts.fields.{3c17620a-de81-45df-9416-aa7527efb509}podeDeclarar'], showWhe

HI there, We currently have a gridfield which displays record data, and we have a requirement where on a button click we will show additional information which is fetched from an API and displayed in the grid. I'm trying to find a way to fetch the data from the API for only the records which are currently shown in the grid. Is there a way to get the list of values currently being shown in the grid without forcing the user to select them via a checkbox? Or is there an alternative solution to this? I was considering saving the paging information into a local variable and using that to query the record, which will in turn query the API, but that will only work if the user performs a paging operation. Thanks for any help.

What is the meaning of the first "=" symbol in this expression in process model? As far as I'm aware, in Appian code, the ' = ' operator is used for comparison, and ' : ' is used for assignment. When editing an expression in a process model the first '=' sign at the start of the expression is always added automatically,which leads to an expression like this, that seems to be valid. In this case the comparison with true() is completely redundant, but it's not my point.What is the purpose of the first '=' sign? Where in the documentation can I find something about it?