Discussion Categories

Hi team, I am capturing data from process metrics report and storing to oracle db as it's business requirement. Now I just want to check is there any inbuilt functionality of Appian which only writes the rows in table which has been not inserted in the previous run ? if not is there any suggested way you recommend that can be followed to achieve the same ?

a!currency() what is the role of:-- isocode:"USD" ,"EUR format: CODE,LOCALE,SYMBOL how they related to each other

Hi. I have a doubt in nested if's here, if the first condition is true, then it will be return the statement "should be 18 digits". If it's false, I want null value to be returned. Since  I am using nested if's its returning "must be numerical and no more than 12no's". how can we resolve this. Can someone help me here?

As soon as I type the first character in Appian's Chat-GPT box, the red "Invalid Search String" error displays below, and nothing I type in makes it go away

Is it possible to create exact Record Save Filter UI.When user click on funnel icon it will show clickable options.Same as below.

Hi, We have are requirement where we need to embed documents as Base64 in a JSON request and keep the format of the JSON in such a way as the called system requires. Here we are talking about two collections , where second collection is a array of some repeated fields and one is base64 where document is passed.  Now Appian in its notes says that we should let it convert it to JSON for documents to convert to Base 64. But then how ill we achieve this structure of the request we need to send to the called system? Sample example is- {   --colection1 "DocInitialization" :{"Input": [ {"Id":"IdValue1","Value":"ValueHere1"}, {"Id":"IdValue2","Value":"ValueHere2"}, {}  --so on ]," DocCollection":  - collection 2 [ {"base64":document1, "mimetype":"MimeValueHere", "SomeOtherAttribute1", "Value here1" }, {base64":document2, "mimetype":"MimeValueHere", "SomeOtherAttribute2","Value here2"},  {}.. so on ] Here how to achieve this patte

We are currently exploring way to connect Redshift and Appian. however, We do not have access to Redshift yet. has anyone integrated Amazon Redshift and Appian together? also what are the different ways that we can utilize to connect these together?Thanks.

Does anyone how to send OTP to aadhaar linked mobile number using integrations? 

a!currency() what is the role of:-- isocode:"USD" ,"EUR format: CODE,LOCALE,SYMBOL how they related to each other. pls explain me not able to understand from  appian docs

Hi All, I'm creating an application where I have a form with an add button on it. Using this button, I want to add a row into an editable grid with recently added data. Then, using the same form, I want to add the data in the same Editable Grid in the next row. Finally, if the user clicks the submit button, all the grid data is stored in the database. Adding a row to the grid when I click the add button here I am facing the problem

After installing latest hotfix 23.2, we cannot start the Appian Service Manager windows service.  Here is the error: Service Kafka failed to start Error running script: Unable to start transaction log. com.appian.komodo.StartKomodo$TransactionLogNotStartedException: Unable to start transaction log. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at org.codehaus.groovy.reflection.CachedConstructor.invoke(CachedConstructor.java:72) at org.codehaus.groovy.runtime.callsite.ConstructorSite$ConstructorSiteNoUnwrapNoCoerce.callConstructor(ConstructorSite.java:105) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:59) Unable to start distributed tran

a!gridField( data:index(local!datasubset,"data",{}), columns:{ a!gridColumn( value:apply(concat(_,"-",_),merge(index(fv!row,"id",{}),index(fv!row,"exhibit_id",{})) ) ) } ) Error comes:---- at merge() function  only  list are allowed .how i change fv!row to list  

Hi, I have a requirement where I need to duplicate a particular section on clicking add button. In the section I have some text fields and clicking on the "Add" button the text fields should get duplicated where I have to enter new values in the field. Is it achievable? or is there any other method where I can duplicate the fields on clicking the button ?Please let me know Thanks

Is there any official recommendation or does anyone happen to know of any benefit of removing intermediate versions generated while working on an object. For example I'm working on an interface and I happen to save my changes 55 times during the development on the page...... so I have 54 versions saved that I don't need since I only want to save the last one. Other then making the version history cleaner to go through is there any other benefit?

Hi, for the process we are automating, we need to display a document saved in the S3 bucket. To do this we used: 1) an integration for downloading from the bucket to an Appian folder 2) a safelink with web API/ a documentDownloadLink to download/view it from the user. Our requirement in terms of user experience would be to use a single click for both activities. How can we handle our problem?  Thank you for suggestions, Eleonora

We applied Hotfix 23.2.346 and Kafka will not start when restarting the Services Engines using the Windows Services.  The error log shows the following: Starting Appian Service Manager Found k.sha256 - a74b78fd5ab833a02c740879b7e962074e9b823cf9a08029ddaa003c03e51684 Detected Appian version 23.2.346.0 from build.infoStarting Distributed Transaction Log services: [all]Executing command: '[cmd, /c, start, "Zookeeper", /min, "%JAVA_HOME%\bin\java.exe", -Xms128m, -Xmx256m, -Dzookeeper.log.dir=e:\appian\logs\service-manager\zookeeper, -Duser.timezone=GMT, -cp, e:\appian\services\zookeeper-3.8.1\lib\zookeeper-prometheus-metrics-3.8.1.jar;e:\appian\services\zookeeper-3.8.1\lib\zookeeper-jute-3.8.1.jar;e:\appian\services\zookeeper-3.8.1\lib\zookeeper-3.8.1.jar;e:\appian\services\zookeeper-3.8.1\lib\snappy-java-1.1.7.7.jar;e:\appian\services\zookeeper-3.8.1\lib\slf4j-api-1.7.30.jar;e:\appian\services\zookeeper-3.8.1\lib\simpleclient_servlet-0.9.0.jar;e:\appian\services\zookeeper-3.8.1\l

We are trying to connect to Box and using the box connected system. We have followed the steps to set up an app in Box however when trying to authorize the connected system in Appian using the client Id and Secret it is giving the below error. 

i am trying to save the selected data into some local variable but it was saving as id i need full data to be save in the local or RI this is my code: a!localVariables( local!items: { a!map(id: 1, firstName: "John"), a!map(id: 2, firstName: "Michael"), a!map(id: 3, firstName: "Mary") }, local!selectedReport, local!data, a!gridLayout( headerCells: { a!gridLayoutHeaderCell(label: "Summary"), a!gridLayoutHeaderCell(label: "Qty", align: "RIGHT"), }, columnConfigs: { a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 5), a!gridLayoutColumnConfig(width: "DISTRIBUTE"), }, rows: a!forEach( items: local!items, expression: { a!gridRowLayout( id: fv!index, contents: { a!textField( /* Labels are not visible in grid cells but are necessary to meet accessibility requirements */ label: "summary " & fv!index, value: fv!item.firstName, readOnly: true ), a!integerField( value: fv!item.id, readOnly: true,

Hi everyone, I would create a note entry for my application in the record details page to create a history of the actions performed by a user who accesses the following interface. I created a manual action that allows you to write these notes in an anonymous field of the record. However what I want to create is a history of these notes: from the note entry screen in the screenshot I would like that every time a note is entered the old one is no longer selectable and a new line appears in the record detail screen under the appropriate section, as depicted in the screenshot. So the result has to be like this in the record details page. What the record call does is simply an override in a field of the selected record. Thanks everyone for the help. P.S: i don't want to simply write note in a box field in the interface: this information must be visible into 2 different sites, so i have to memorize this notes somewhere in the records

Hi All, i am developing an application in whcih I have to fetch all the records from table. now the problem in doing so is while running the expression tule it's failing which i think is failing because  i am fetching everything at a time. I want to fetch it in batches how can I make it in such a way that it fetch in batches but while writing, it should write it all at once. And also one thing this table will increase everyday by 5-7k rows. And also if i fetch data in batches won't it hit db multiple times ? What should be preffered batch size ? Please suggest me good practice to achieve the above.

Hi All, I downloaded the health check report, in that report for description column for user input task i am getting below Description. 29 calls, 1.2MB max interface, 360 max component count, 84.6KB average interface, 296 average component count. .what is the exact meaning of this description Thanks in Advance.

Hi All, If i have  two tables where possible relationship can be configured, is it better to create view from both table OR create relationship to query data from both table? Thanks in advance

Though it's an extension to below thread: https://community.appian.com/discussions/f/user-interface/20858/merged-or-nested-column-headers-in-an-editable-grid I was trying to follow the approach in above thread to achieve grid format I have attached as image in this thread post. The above logic works good but there are lots of alignment issues when grid is viewed across different environment screen like wide desktop, mobile, etc. The column widths in read only grid changes on different screens which most of the times cross the limits of above cards, for example - I have one main header "A" under this I have two headers "AA", "AB" and one more main header "B", have only one under it  "BA", when I change screen to wide the width changes and unaligns. Mostly, I see columns which should only be under "A", some part of those columns move under "B" header. Also, with paging grid, it is getting diffic

Hi, Is there any option to generate below 3d report in Appian.    Thanks in Advance.

Hi All, I am trying to update data from one table to other table using execute store procedure smart service but i am getting below error while executing smart service. (conn=8566693) Incorrect string value: '\xAC\xED\x00\x05ur...' for column. can any one suggest what it is referring for.   Thanks in Advance