Discussion Categories

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',

Hello! How can I make a query (it would be based on an id introduced by the user in the start form of the process) to a record and save the value to a process variable, in order to use it further in the model?

Hi! I´m trying to make a logic between a value entered by user in my process model and a related field (linked by relationship). But the logic isn´t working and I dont know how to pass the relationship in the model (as I do easily in the interfaces). In the first "write records" the relationship appears in the node inputs But then, when I make the logic in the XOR, the relationship does not appear. Even if I put it manually, the logic fails. What can be causing that? 

Hi! I am facing a problem in my process model. The fact is that, when I run the process for the first time, the fields introduced by the user (interface from start form) are saved correctly. But when I finish the process and I try it a second time, the values of the process variable are not overwritten ( they are correctly written in my record, but it is like they are not saved in the process model, so all my logic runs according to the first time introduced fields). I have some captures of the problem: Fields introduced for second time  But when you search in process variable, the recordFact fields are not updated The most confusing thing is that, even though it seems they are not saved correctly, the updates appear in my records Any help would be useful Thanks a lot

Hi! I have created an app in which the user enters some purchase order fields, and one of them is a PDF file, saving each file that is uploaded in a constant folder of documents. When I end the user task, the document is saved correctly in the folder.  But the fact is that I want that the exact file which the user uploads (related with a Purchase Order ID), to be shown in the summary view for each Purchase Order ID. By now I can upload a the same static PDF for all the summary views, pointing to a constant. But I would want to associate the PDF with its order and show the correct one for each PO. How can I do that?  Thank you so much for your time

Hi! I´m trying to reference a related record action (update of fields, which has another interface and works properly) in another interface. I´m using the "record action field" component in the interface menu, but some errors appeared:  First of all, I tried to emulate the same code that I had in my related record action, but it doesnt recognize the rv!identifier and the following error appears ("could not find variable rv!identifier") That´s why I skipped that part and tried to put only the rule, being my code  the following one:  In this case, the related record action appears correctly in the interface. But the following error appears when I click in the button ("An error occurred while applying the context for the CPF Maestro Pedidos related action [identifier=235]. Details: The record data does not exist, has been deleted, or you do not have sufficient privileges to access it.") On the other hand

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?

Hi All, I have requirement to read content of PDF having Table and Paragraphs which is structured and unstructured and store it into TABLES without any manual intervention. I have used the Appian inbuilt feature doc extract but its not providing me accurate reading capability like some fields are readable but some are not.  https://docs.appian.com/suite/help/23.2/evaluate-doc-extraction.html We would like to stick with Appian as it keeps the doc in Appian rather than using Google  Any suggestion will be helpful Thanks

Hi. I have a dropdown list. It fails when I select one of the values. Here is the code: a!localVariables( local!formAnswer: { function: "", subFunction: "" }, local!dynameiceValue: { functionList: rule!JRA_QRY_getBusinessOwnerFunctionList_AbbVie(), subFunction: rule!JRA_QRY_getbusinessOwnerSubFunctionList_AbbVie( businessOwnerFunction: local!formAnswer["function"] ), }, { a!dropdownField( label: "function", value: local!formAnswer["function"], placeholder: "select", choiceLabels: local!dynameiceValue["functionList"], choiceValues: local!dynameiceValue["functionList"], saveInto: a!save(local!formAnswer["function"], tostring(save!value)) ) } ) I get the options by query rule and put it into a variable. It looks like good. But it will throw the error when I select the value. This is the error message: Interface Definition: Expression evaluation error at function a!dropdownField [line 23]: A dropdown comp

With the implementation of Appian 22.3, we had to upgrade our LDAP Tools plugin to the latest version due to a java error. This also required us to replace the LDAP User Profile Synchronization smart service nodes wherever they were used. We copied parameters from the old version of the smart service into the parameters on the new nodes. The parameters were copied exactly. Now, when these processes run, they are pulling users from "similar" baseDN's. Example, when we try to sync baseDn "OU=ITS,OU=Depts,DC=abc,DC=company,DC=com", the node is also pulling users from "OU=Contractors,OU=ITS,OU=Depts,DC=abc,DC=company,DC=com". This assigns the Contractors to groups only intended for employees, presenting us with a possible security issue. Is there a setting or filter that will force the Sync node to ignore the members of extraneous groups with "similar" baseDn string values? Please note that the ldapsearch function works as expected and does

We want to be able to launch the X appian instance from the Y so that the details can be passed by the system.

We are getting some error while calling a sub process from a main process with the following error:Invalid 190dbe45-bafb-4e8c-92bb-e7ba7605bb0e: Cannot validate type, incorrect number of elementsThe UUID is referring to the record type.  Any idea on what might be the root cause for this?? 

Hii,   To set up and run the SFTP, after installing and importing in the Appian, the required details are needed for the interaction, as listed,      server hostname      server port      scsExternalSystemKey      private key file      server username:      server password:  And upon searching through the Appian website, I found this Obtain SFTP Credentials: Contact your system administrator or Appian support to obtain the SFTP credentials required for connecting to the Appian Server. You will typically need the SFTP server address, port number, username, and password. And please suggest the best SFTP software among them: WinSCP, Cyberduck, or command-line tools: OpenSSH.

Fitness Testing : How to write test script to validate grid field level validation messages through fitness I wanted to test fitness required field validation for a grid row and grid validation message. Please guide me with the cheat sheet code. 

***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 Team,  I am converting html file to pdf, The image which i show as logo is not displaying and show white blank when i convert it into pdf, Attached html code , Any suggetsions ? <!DOCTYPE html><html><head><style>table { font-family: arial, sans-serif; border-collapse: collapse; width: 100%;} td, th { border: 1px solid #dddddd; text-align: left; padding: 8px;} tr:nth-child(even) { background-color: #dddddd;} img { display: block; margin-left: auto; margin-right: auto;} </style></head><body> <img src="">www.cscsw.com/.../cscsw-logo.jpg" width="200" height="200", class="center"><h2>< </body></html>

In signature field , i am unable to configure target document. could any one help me out !!!

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 there, we are trying to read the data from SAP tables, for instance the table "T001". This table holds maybe only about 100 entries. For this reason we do not have any conditions. We already have a connection to our SAP System and we are using several BAPI's. But with the BAPI "RFC_READ_TABLE" we do have some issues. a!sapInvoke( scsExternalSystemKey: cons!SAP_EXTERNALSYSTEMKEY, usePerUserCredentials: false, hostname: cons!SAP_HOSTNAME, clientNumber: cons!SAP_CLIENTNUMBER, systemNumber: cons!SAP_SYSTEMNUMBER, bapi: "RFC_READ_TABLE", importParameters: { QUERY_TABLE: "T001" }, tableParameters: {} ) Errormessage: Details from external system: java.lang.IllegalArgumentException: InvalidFieldType We have tried unsuccessfully several option for "importParameters" and "tableParameters". Any idea how to create a simple call to read from a SAP table? thanks Yusuf

Hii,   In the process of moving the log files from Appian to AWS cloud watch, I found a way i.e to possibly download the .csv and .log files in bulk amounts and then move them to the Aws S3 Bucket. So to do so I found a function in the SFTP plug-in, "queryappianlogs()" but not sure what are the parameters to pass like the SQL statements. Can you please help me to sort out this one, this allows me to download fixed to 1000 rows.