New to Appian

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?

Hi, I'm trying to save an array value to a local variable, it looks like getting saved, but when I check for the length of the local variable, I'm getting as 0. Where as when I save the same array during declaration of the local variable, I'm getting the length as expected.  What I'm missing here ? what is the proper way of saving into local variables after declaring them. I've tried using a!save() but no luck.. :(  Below are the snaps for your reference. Assigning array after initialization  Assigning array during initialization   TIA :)

HI All, I am trying to schedule the start node of the process model using Timer in Appian. PFB the configuration: I am trying to schedule it at an interval of some hour. I want this hours to be configurable so used constant rather than hardcoding it. Now the problem I am facing is whenever I change the value it only picks the old value. Let say the current value is 15 and if I change it to 20, it will still run after interval of 15 hour. and later if I change it to 22, it will run after 20 hours. So I am not sure why this weird behaviour.  anyone have notices this and anyone knows the solution to this ? Is there a way to refresh the values before using it . or something like that ? Thanks

Our school has been given a prep.appiancloud.com environment and appiancloud.com environment for our students to work in but there is absolutely nothing I can find to tell me how to utilize this service.

Hi Community,  We are getting this type of error e.g Cannot detect WSDL version of the file. Ensure a valid WSDL exists at the provided URL. Please suggest me the solution

Q1. a!dashboardLayout() is deprecated what layout should I use in place of it.. Q2. what was the role of a!dashboardLayout()

Hi Everyone, Is it possible to deploy objects to higher environment from lower env, if dont have access to higher environment. Thanks!

Q1.  what is role of readexcelspreadsheettocdt in appian? Q2. what  function should I used in place  readexcelspreadsheettocdt. It is deprecated?