Community

Hi Experts, I Need your help. There is a use case where I am designing an Interface from where the user uploads a CSV file and I have to convert that CSV file data to CDT. And once this has been converted into CDT I have to show that data in a read-only grid on the Interface. Thank you in advance for your support! Below is the overview of the data of my file:

Hi, I want to export the data in excel on page load using ExportDataStoreEntityToExcel. how we can achieve this? I am successfully able to export the data on saveinto but here want to export on page load. Below is the code which i am trying. Code is not throwing any error but seems not calling this export service also. local!exportDocId: a!exportDataStoreEntityToExcel( entity: cons!SCE_SITS_VW_INCIDENTS, documentName: "test Report", sheetName: "Test Report", saveInFolder: cons!TEST_DOCUMENT_FOLDER, onSuccess: a!save( local!exportlink, fv!newDocument ), /*This displays an error if there is an issue executing the save*/ onError: a!save( local!errorMessage, "Error Exporting File to Excel" ) ),

A feature is being deployed to the test environment.In which environment is unit testing performed for the feature?

Hi Everyone, With the update in the appian version the record object created in previous versions will be updated and will have new features? Thanks!

a!localVariables( local!publication: cast( typeof( 'type!{urn:com:appian:types:ISR}ISR_StudyDetail'() ),{} ), a!boxLayout( label: "Publicaton Plan", contents: { a!gridLayout( totalCount: count(local!publication), headerCells: { a!gridLayoutHeaderCell(label: "Publication Type" ), a!gridLayoutHeaderCell(label: "Publication Name" ), a!gridLayoutHeaderCell(label: "Year Estimate" ), /* For the "Remove" column */ a!gridLayoutHeaderCell(label: "" ) }, columnConfigs: { a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight:3 ), a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight:3 ), a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight:3 ), a!gridLayoutColumnConfig(width: "ICON") }, rows: a!forEach( items: local!publication, expression: a!gridRowLayout( contents: { a!radioButtonField(

Hi Everyone, Is there a way to find out where the stored procedure created in database is being called in which process model through execute proc smart service? Thank you!

Hi Team, Can we extract process instance logs on Appian. Eg: For a process instance, we see the details of the process in the process history tab. Can we extract that?

in my app I have a Loans table and the client wants to be able to add new Loan Balances to the loan with date, balance, & notes fields. The best way I know to do this would be to create a Balances table related to the Loans table so that each Loan could have many Balances. What I am wondering is if there is a way to set up a Balance field on on the parent Loans table that will always display the most recent balance entered into the Balance table? Short of that i know I can show a record list of the balances on the interface with add buttons so they can add new balances that way, but they also want to be able to report of the current balances and to use the child table would mean having to pull several pieces of information from the parent Loan table down to the child Balance table which I think would be much more difficult to do.

Hi All, Can we insert multiple drop down within another multiple drop down.If yes please provide me information.

On the creation interface for a table there are a few dropdowns, so on the update interface for the same record, I need to have the same dropdowns available in case a change needs to be made, but how do I make the default value be what was selected during the creation process? I believe it has something to do with the Selected Value input on the dropdown component configuration, On the creation interface the local variable for that list of choices goes into the Selected Value input. I tried putting a "a!defaultvalue" formula there but then when you make a change, it doesn't hold the new selection. Also, as it may make a difference how it is set up, these dropdown's selections are drawn from related tables, not hard coded in the expression.

When creating records for a Loans table, I have 6 dropdowns where the choices are fed via related tables. The dropdowns work fine, however, after the record is saved and viewing the summary view for that record, the selections in those dropdown fields are not showing, only getting a "-". The following is the code used in the display value portion for the summary view of the dropdown fields. This works fine on other tables I have done and is the same on the community Acme Auto app but I can't figure out what is missing. a!defaultValue( if( isnull( ri!record['recordType!{6e4edeaf-030d-4fc2-917a-ab20f1027418}DC Loans.fields.{6c4213e9-38dd-4430-ac99-141cf70a9ebb}loanSourceId'] ), "â`“", index( a!queryRecordType( recordType: 'recordType!{beec71c0-c52d-4b00-8311-cbcf34fcd0c7}DC LoanSources', fields: 'recordType!{beec71c0-c52d-4b00-8311-cbcf34fcd0c7}DC LoanSources.fields.{7413e7ce-3dc8-4513-bf9a-13a6376dfb11}loanSourceName',

Hi Everyone, I am using Import excel to DB smart service to import excel data in Appian. And my requirement if date column in excel is in any format then it should be changed to "dd/mm/yyyy" before inserting into DB. I dont see any option to format the dates in smart service. Can anyone please help me out? Many Thanks!

Hi,I'm new to appian. I created a simple employee onboarding form (1 wrapper interface contains 3 sub interfaces(personal details,address,bank).when i click submit all 3 tables in DB needs to be updated uing write to multi data store entity in interfaces itself(not using process models).the problem i'm facing is once employee details submitted then we get primary key(emp id) this needs to updated in other 2 tables(address,bank) parallelly. i dont know how to configure the on success parameter for doing this.

I am getting the following error when using the record action button created to create a child record that pulls the parent record ID into the child record to connect them: An Error Has Occurred Could not cast from DC Loans to DC PrincipalLoanBalance. Details: DC Loans cannot be cast to DC PrincipalLoanBalance I have the button and process model just like I set up a few others in another app that work fine, which I followed the example on the community app Acme Auto Solutions to get those right. Not sure what is causing this error, thoughts?

***New to Appian and still learning*** I am receiving the following error when testing a create interface for a record type and select an option from the first dropdown that I configured to utilize another table for the choices. I followed the same steps as another interface that works perfectly but this one isn't.: Expression evaluation error [evaluation ID = ddb37:dcfb0] in rule 'dc_createloans' at function a!dropdownField [line 12]: An error occurred while executing a save: Expression evaluation error: Field with [identifier=ff748bfd-bb00-441d-a6b3-60434c5f439e] not found on the Record Type I get the just of what the error is saying, but when studying the Record Type, I don't see any field that could be missing. I'm not sure how you utilize the highlighted field identifier in the error message to figure out which field it is referring to. Below is the code from the create interface, please let me know what you see. It's probably going to be something stupid a

Hi All, I have written the expression rule to fetch data from the tables and I have given batch size = 50. Now I want to know what' the right way to consume the data so that I can get everything based on the given filters. As it would contain data more than 50 rows so how can I consume the data properly ? Any example process models will really be helpful. Thanks

Hi,  I have a requirement to add the number of working days to the given date. I'm using caladddays() function. Its behaviour is different sometimes. The same thing works as expected when I use a!addDateTime(). Can anyone explain why it happens? Thanks in advance.

Hi Team How is Appian Support forum  different from community. Is there a documentation to understand the complete features that are provided in the forum. Eg: Raise a support, maintenance activity and monitor environment.  This will help to leverage the use of forum. Thanks.

Hi Team Will system administrator gets all the errors of the app. Is that the default thing. When record type sync fails system administrator of the environment is getting notified. Is there a way to restrict this and main goal is to alert the support group when the instances fail and we have added the support group in the alert in the process model. Team, is there a way to fix this.

How to provide Appian with a list of AWS Principals that will send connection requests to the endpoint service?

Hi, can someone tell me how to create VPC endpoint services in Appian?

Hi All, I am trying to Load CSV to DB, there are no errors in the instance. Have ensured correct mapping of table name, but CSV is not getting reflected in the DB. Let me know if anyone has faced similar issues.

Hi all, can anybody please let me know what is property function? and what is the main difference between property and index function. Thanks in advance

Hi Everyone, Can anyone suggest me if I need to export DSE to excel which have more than 50 columns, which smart service to prefer. Since Export DSE to excel smart service works for only 50 columns. Thank you!

Hi, I recently completed ACD100. My company is an Appian partner, and a 50% discount was automatically applied for me. However, my colleague did not receive the discount, and his site is also inactive. Is there any specific reason why the discount was not applied for him?