Community

Hello, I am new to Appian, have been working with it for a few months.  Have done the developer training and studying for my CERT. I have a request where they would like to put data in a Excel spreadsheet and then have a interface to click a import button and have the system import the Excel data into cloud databases.  The would like to add data into Excel and then when done do the import. Trying to wrap my hands around this and figure out if it can be done and confused when looking through the Documentation. Can someone let me know if this can be done and point me to documentation that shows it and explains it. Thank you

Hi, I have a interface which displays all the data from the record type. And I have a process model which retrieves the data from integration. When I'm doing this facing error showing on the interface.  Could any please tell what would be the best way to handle this.  

how to active our Appian community Edition site ?when the site is inactive after 5 days.

Hello Is it possible to support View Template functions such as 'tiles' in the interface object? Purpose:In the case of multiple people developing. Want the developer to focus only on the interface part that the developer is working on.And not worry about other layouts. ex) When 'developer A' is working on the red box interface part, there should be no difference made to the grean and pink box. For now, the layout changes as what goes into the red box. Thank you.

GM: Just learning Appian as a business analyst. I have a basic app built, one CDT integer field as a array for documents, with the subsequent Appian-generated table for the "many" if the user loads more than one document. How do I display the list of documents for a particular record from that array field? I'd also like to use a link field so another user can download one of the documents if needed. I've seen the editable grid pattern from other developers but I was hoping for a simpler solution since I'm still learning, and don't have a coding background?? thx in advance Current code for single document but doesn't work for multiple: a!textField( label: "Revised/additional documents", labelPosition: "ADJACENT", value: if(rule!APN_isEmpty(ri!record['recordType!Saving.fields.{folderId}folderId']),"-",document(ri!record['recordType!{Saving.fields.{folderId}folderId'],"name")&"."&document(ri!record['r

Getting null as output when I'm doing aggregation. 

I am new to appian and try to change language on appian cloud environment but it does not work. I tried this step. 1.Click Admin Console2.SYSTEM > Click Internationalization 3. Local Setting > Primary Locales (I changed English(US)[en_US to Japanese[ja]4.Logout and Login again but nothing change!!!!! Thnaks

I created a data grid to display from a database table, and allow me to add new entries using an associated interface. The data grid gets its data via a data store that is linked to the underlying MariaDB database. I had created some dummy records using my data grid and its associated data entry interface. Consequently, to clean it up, I went into the MariaDB and deleted the dummy rows from the database table. However, the data grid still shows the rows I deleted.  It is only when you try to open the row in the associated interface to modify the row, that you notice that there are no values for the fields. Can anyone explain how this might be occurring?  Is the data cached somehow in the data store object or perhaps the record type object? Thanks heaps, David

Hello everyone My requirement is when loading a page there should be a default values in pickerFieldCustom. And also should i have to change the values afterwords. Values for pickerFieldCustom will be a user values. Can anyone help me on this

The Requested Record Type Is Not Available Expression evaluation error [evaluation ID = 369b5:18e35] at function a!recordList: An error occurred while retrieving the data for "CMS commission type". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. (APNX-1-4198-000) I have this error when i click sync in record type and take many time . then show this message

Dear all , I want to ask about how to generate reporte from database and i didnt kown count of rows, then daownload as aspacific format pdf file

Can I navigate to an Interface from another one by using button or link component? such as navigate to a login page using the logout button?

Hello, I know that there are some row limit when using "record type with sync enabled", and have a question about it. (https://docs.appian.com/suite/help/22.1/records-data-sync.html#row-limit-for-a-record-type-with-sync-enabled) Is the row limit of the "record type with sync enabled" based on the record types Data source's database table? Or are the tables in the relationship also included in the limit?

Let me set an example. I have a SOAP Web Service “MyServer/MyWebService.asmx” with a returned wsdl with 2 ports with unreachable addresses (this could be because the web service was moved from an older infrastructure, or it is the developers terminal etc) as shown below: setup in Appian in the expression editor: webservicequery( wsConfig: a!wsConfig( wsdlUrl: "https://MyServer/MyWebService.asmx?wsdl", service: "{http://tempuri.org/}MyWebService", operation: "{http://tempuri.org/}GetMyData", port: "MyWebServiceSoap12" ),... when using one of the service ports by name (for example “MyWebServiceSoap12”), as expected the following error occurs: Caused by: com.appiancorp.ws.RetryableWSException: The maximum time to establish a connection with the remote server was reached. Location: https://UnreachableServer/MyWebService.asmx (APNX-1-4045-003) ... Caused by: org.apache.axis2.AxisFault: Connect to UnreachableServer timed out ... Caused by: org.apache.h

In the given exercise https://docs.appian.com/suite/help/22.1/Grid_Tutorial.html When below expression is used  Results in  When I tried the same no data is fetched 

Hi readers, I would like to know the use of publishing an application. Even if the application is not published it can be used right? then what is the use of publishing the application ??

Hi All, Do anyone know why the below code is coming when the PDF is downloading from SAIL? {"error":"APNX-1-0000-000","message":"Invalid Content ID","title":"An Error Has Occurred"}

Hello, I am new in appian and  I need to import a excel and save in local variable, after that I need to validate the content of the file (number of columns, etc),  I don't how to start. Could recommend me the function to do it,   Could you help me , please? Best regards,

Hi, what are the necessary thing which are required for successful import application process (one environment to another) from older version to latest version in APPIAN?

Hi, There is supposed to be a Data tab, Functions and Rules and Constant tab on the expression editor.  However, I am not able to see these tabs on my expression editor. Being new to Appian I am sure I am not doing something in order to view these tab. Can someone help ?? Of course not a big problem.. I can always type the expression but just wondering why am I unable to see these tabs thanks in advance jaideep

Hi, to print large numbers as it is with decimals. for ex: 12367864322345678965.0000008 output need to be same as this 12367864322345678965.0000008.How can I achieve this?

I just want to convert exponential values to number,which function should i use?if i give large number like more than 12 digits ,it should return as same as that number. Can someone answer this?

[Where can I find the table that contains data of process report in the Appian installation databse?] I checked the part where the informatin of the process report is queried through the [a!queryProcessAnalytics() ]. I want to know where the data of the "Process Report" is stored in the Appian Installation Database. I checked all the tables in the Appian Installation Database, but couldn't find it. If I want to check the information(table) accumulated in the "Process Report" in the Appian Installation database, How can I do it? Thank you.

Hi Friends, How to validate two rows and also between rows where the two rows are equal. please let me know how to do...

as title, my excel column logintime previously let it transimit to be text(String) into database successfully. However, if i want it directly insert into datetime format always fail, the example shows in excel as "2019/11/28  8:08:27"