Discussion Categories

Hi, After every user input task completed i have called write to data store entity to insert data to table so over all in main process i have called three times so after every user input task a new row creating the values is not getting updated but after every user interaction a new row is getting inserted. i have updated the details correctly like below in input and also in output tab i stored the ac values to cdt. kindly suggest me on this and autoincrement i have given to Id column in cdt Query:

How do you install and set up Automated Versioning Manager if you're using Appian Cloud? Thank you.

We have imported our certificate in the admin console => Integration =>Client Certificates,  is there any way of retrieving the signature form here to  sign the xml  document ?

Hi all, I have encountered an issue in an interface while switching from expression mode to design mode in Appian. The issue is mainly cause of nested indexing (An alternate approach that I have used in UI). Below are 2 code snippets, while switching to design mode, the second snippet causes the error to appear. I am trying to use a single index() instead of nested index(), is there any sort of performance difference between these two approaches, or any benefit of one over the other? a!localVariables( local!list: { a!map(key: "test1"), a!map(key: "test2"), a!map(key: "test3") }, a!textField( value: index(index(local!list, 1, {}), "key", {}) ) ) /* Works well */ a!localVariables( local!list: { a!map(key: "test1"), a!map(key: "test2"), a!map(key: "test3") }, a!textField(value: index(local!list, 1, "key", {})) ) /* Gives error in switching to design mode */ Error: Cannot switch to Design Mode The function 'index' [line 7] has 3 p

Hi all, I've got OpenID Connect (Google) set up on my environment for SSO and it works perfectly. I've got SSO set up for employees but guest/test accounts still use the usual username/password to access the environment. Problem is that all of the usual login links my-environment.appiancloud.com/ or my-environment.appiancloud.com/suite/ or my-environment.appiancloud.com/suite/tempo/ all now default to the Google page where you select your Google account to log in with. That's fine if you're an employee but if you're not, there's no option/link to redirect you to the native Appian login page my-environment.appiancloud.com/suite/?signin=native to enter your username and password. Unless somebody knows the native link, they'll just be stuck in a Google and Appian loop where they're unable to sign in. If they try their Google account (which obviously won't work as they're not employees) it takes them to the Unauthor

Hi, I have been using Appian for last 6 months, I'm beginner. Through my learning path for Appian Developer I have decsoverd confusion in online course 23.1 Exercise 3: Manage Users and Groups. On page 5 in exercise 3 under note it says that Editor permission level allows users to delete documents, but documentation on your site says that user must have Administrator permission to the document and its folder in order to delete it. Please help me understand.      

Hi Champ, I am using document download in my portal application. When user clicking the link, it usually flickers and download it in a next tab and comes back to main page.  Can we somehow stop this flickering behavior? Regards, Ghanashyam

Hi Champs, For one of the requirements, I have to enable the masking for the account number field. It's working fine but when we are navigating from one screen to other, the browser is asking for store the password. can we disable the feature by somehow? Regards, Ghanashyam

Hi All, Can someone suggest me the ways of converting an encoded base 64 format into a PDF file? Thanks In Advance, Gousii.

Please Check the sample of data i am getting from big query ,,.. I am creating Row id and Unique id after retrieving the data ..  how to filter data on based on npiMap unique_id "1.591111183E9_1902142920_INDIVIDUAL_RIDER_NOT_CHECKED_INITIAL"(Text) row_id 2(Number (Integer)) event_timestamp "1.591111183E9"(Text) npi "1902142920"(Text) rider_type "INDIVIDUAL_RIDER"(Text) trinary_status "NOT_CHECKED"(Text) roster_type "INITIAL"(Text) Map unique_id "1.591111225E9_1922475623_INDIVIDUAL_RIDER_NOT_CHECKED_FINAL"(Text) row_id 3(Number (Integer)) event_timestamp "1.591111225E9"(Text) npi "1922475623"(Text) rider_type "INDIVIDUAL_RIDER"(Text) trinary_status "NOT_CHECKED"(Text) roster_type "FINAL"(Text)NOTE: I dont have an access to the big query where i can filter from initial stage .. but i have this data i only want to filter this retrieved data . 

I am trying to show Student Data in editable grid through excel with marks in subjects. there is a field with total marks which is depend on marks from other fields. Problem is i am able to when i change marks of any subject changes get reflect in the MarksObtained field which is the sum of marks of all subjects but when i submit it does not store the changed data in Marksobtained field. it stores the original data which is in excel file.a!localVariables( a!formLayout( label: "Student Details", contents: { a!sectionLayout( contents: { a!gridLayout( label: "Editable Grid", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: "RollNumber"), a!gridLayoutHeaderCell(label: "FullName"), a!gridLayoutHeaderCell(label: "Hindi"), a!gridLayoutHeaderCell(label: "English"), a!gridLayoutHeaderCell(label: "Maths"), a!gridLayoutHeaderCell(label: "Physics"),

I have uploaded multiple images in the document folder in my application using 'Upload File' option in the Action and Image Id of these images is stored in the database table. Now I want to display these images in the record grid for which I am using the below method in the 'Edit List' feature of the List option of the record: a!documentImage( document: fv!row[recordType!Car.modeldetails.Image] ) Where image is the name of column storing image IDs in the modeldetails database table. But by executing this I am getting the below text as the result in place of image: [@attributes=[@anyAttribute=[_cId:7ea9cd6ac69bf45fb67452fc4de3351f], @nil=], document=[Document:405304], caption=, altText=, link=, actions=, backgroundColor=, version=] Please help me as I want images to be displayed in place of text (image details).

Hi All, I have a table Emp_personal_details and i have around 200 records in that table. Now I need to Insert around 400 new records into the same table. But the new records have some duplicates which are already in the DB. How can I write a sql script to check duplicates in the table and insert the remaining records into the Appian DB. Thanks

wherecontains(null, {"a", "", "b"})   returns 2 i need to get an index of non null values , e.g. in above case it should return {1,3}

load( local!empStatus: { { name: "Ajay", status: "test1" }, { name: "Ajay", status: "test2" }, { name: "kumar", status: "test3" }, { name: "phani", status: "test4" } }, local!empDetail: { { name: "Ajay" }, { name: "kumar" }, { name: "phani" } }, a!boxLayout( label: "Form", contents: { a!gridField( label: "grid", data: local!empDetail, pageSize: 5, pagingSaveInto: fv!pagingInfo, columns: { a!gridColumn(label: "Name", value: fv!row.name), a!gridColumn( label: "Status", value: a!forEach( items: local!empStatus, expression: fv!item.status ) ) } ) } ) ) Hi All, I have added the sample code and the output where I need to display the corresponding status for that particular name. for example: Name: Ajay   Status should be Test1, Test2 and similarly for       

Hi all, I am facing some error regarding insufficient group permission. I used a!isusermembergroup() function in a query filter inside applywhen parameter for validation to get list of tasks for a particular group. I am not ale to view the tasks if I am not part of admin group. The visibility permission is "Restricted" for all the groups and gave administrator access for admin groups in security .Please let me know how to resolve this error on insufficient permission.

Hi All, I have a scenario where I am getting a URL of the attachment through an API , So I need to hit that URL , So that my file are downloaded . How can I achieve this with the help of Process model or is there any other way  Thanks In advance 

How to change Appian configuration so that all Appian servers don't send publish emails to users.

From the above pic, in the local variables bankruptcy there will be constant 4 values and in the local variable creditPublicRecord there will be some values can be null or more than 1 value. Here we have to compare the creditPublicRecord values with the bankruptcy values and check whether the the creditPublicRecord values matches the bankruptcy values and need to return the count. Can someone suggest the way to complete this. Thanks In Advance, Gousii.

Hi All, Can any one guide me to use Unarchive process smart service plugin? I just need to know the security permission required to unarchive a process. If i am system administrator, I was able to unarchive process but i am not able to do the same if am having basic user permission.  Note: I have administrator access to both "Unarchive PM" and target PM(Which i need to unarchive). Also I was able to use "Archive process" smart service successfully with basic user access. Please suggest any reason behind this. Thanks in advance!

Can any one send me where is integration video tutorials for practising in deep

Dears, I have a problem in the calendar interface when the appian language is in ARABIC. The date shows and saves in Persian numbers such as : ١١٠٥٢٠٢٣. how can I keep the date language for all dates in English even though the user language still Arabic? the Persian numbers are causing me massive errors when I map them.

Hello  Team, In Appian  we have a Inbuilt function for sentiment score calculation for Text . "a!sentimentScore() " - only for text. And we do have Google Cloud Natural Language connected system to perform entity and sentiment analysis to collect information from HTML or plain text. But,my question is how do we calculate sentiment score based on voice. if the person who is taking Interview , how his voice is analyzed and get Sentiment score. Could you please help me in understanding How sentiment score calculate for Voice in Appian. Regards, J Vinay.

when we apply multi-select dropdown .. comma separated value is getting store in table in single row ..but i how to put in different rows. Output i am getting  Field Field Value Dropdown 1,2,3,4 Expected  Field Field Value Dropdown 1 Dropdown 2 Dropdown 3 Dropdown 4

Hi, I am working on an editable grid which shows excel data. I am fetching excel data from excel using "readexcelsheetpaging()" function. Now i want to map data to editable fields and i tried to do fv!item.fieldName but it is not working. a!localVariables( /*local!studentData:excelreadcellsbyname(ri!excelFile,{1},{"A1","B1","C1"}),*/ /*local!studentData:excelreadcellsbynumber(ri!excelFile,{1},{1,2,3},{2,3,4,5}),*/ local!studentData:readexcelsheetpaging(ri!excelFile,0,a!pagingInfo(2,10)), local!gridDataType: 'type!{urn:com:appian:SD}SD_Student_Data'(), a!formLayout( label: "Student Details", contents: { a!sectionLayout( contents: { a!gridLayout( label: "Editable Grid", labelPosition: "ABOVE", headerCells: { /*a!gridLayoutHeaderCell(label: "ID"),*/ a!gridLayoutHeaderCell(label: "First Name"), a!gridLayoutHeaderCell(label: "Last Name"), a!gridLayoutHeaderCell(label: "Em