Discussion Categories

Hi All, I have made some changes in interface (adding another interface having grid values) .I have tested by passing inputs in the interface changes that I made are visible but they are not loading into process model . How can I get them into process model

I am trying to achieve a functionality where a user upload an excel then added a function to check the format of the excel file whether it matches with cdt or not. if matches, then user can proceed otherwise a hidden section layout will appear with a warning and download option for correct excel sample format but i am getting error in readexcelsheetpaging() as it shows null value error for document parameter.i try to fix it by using if condition and it solves the null error but now when i try to upload an excel file it shows other error "Interface Definition: Expression evaluation error at function 'readexcelsheetpaging' [line 2]: com.appiancorp.suiteapi.content.exceptions.InvalidContentException: Invalid Content ID".a!localVariables( local!excelFormatFromFile: readexcelsheetpaging( excelDocument: if( isnull(ri!excelFile), cons!SD_EXCELFILE, ri!excelFile ), sheetNumber: 0, paginginfo: a!pagingInfo(1, 1), numberOfColumns: 11 ).

Hi Team, I was facing some issue while querying and performing larger data such as approx 1M+ data at a time. Considered I'm querying data from approx 5 table using some filter to reduce some search results and storing in seperate variable with the help of index() function. Even I'm having more data and I'm performing approximate n time (rare case n^2 times) as looping so Appian expression rule was failing shows as one pop up with please try later in the code such approx 502, 504. Is there any limit in Appian hold particular level of data or no such limit? Anyone has any idea is there any better way to handle this larger case of data... Thanks and Regards, Vigneshkumar Radhakrishnan

Hi , How can I overcome  this error. Expression evaluation error : Cannot compare incompatible operands of type List of Variant and type Number (Integer)..index(ri!approval,"meetingId",{})=ri!meetingID //ri! approval type is on etable and array is enabled,whereas meeting id is number

I want to verify an excel file after uploading, whether the order of columns in excel file matches with CDT. for example, I have fields like PhysicsMarks,ChemistryMarks as second and third column respectively in excel file and want to ensure that this order of column matches with my cdt like if my cdt have 2nd and 3rd column as PhysicsMarks and ChemistryMarks. How can i achieve this function?

Hi All, I am creating Process Models, Process Metrics, Task Metrics Reports in the Appian. and then I am fetchiing the data from the report in the process models and using it. My query is what is the data retention period of those reports in Appian. Like how old data it could have and how can we configure this. ? and is it something manages by the APPIAN DB itself or managed by the organisation. if by the organisation than where we can find that configuraiton.. Thanks

I want a form to be popup upon click of button in UI (a form will be there to enter details and open click on button a new form needs to be displayed)

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.