General

As there are more and more ways to embed Record Types in interfaces, it would be really nice to be able to specify the text in the Record Type placeholder. This would make using OOTB Record functionality in translated applications easier. ref: https://community.appian.com/discussions/f/general/14673/search-bar-in-records

Hello All, We are working on a project where in we are sending a link into an email. That link consists of a URL of web api that has been built inside appian.  This works fine when user who clicked on a link is already logged into appian or have SAML enabled account but for other users it gives 401 error. I need to send API key in order to get it resolved but I don't know how. The link has been created inside an HTML template. I'm not sure how exactly we can pass the API key via html <a href> tag. Can someone please provide some kind of example here that can benefit me? Thanks in advance

Hi, I am getting cast invalid error when I am trying to store a value in my cdt field which refers as foreign key.  The scenario is  I am passing the product name as parameter and fetching all the details of that product using expression rules. Now the product id I want to store in another cdt  then it is showing cast invalid error. Please help me to resolve this error. Thanks,

I sometimes find the toggle button(with plus icon) of the rule inputs on the Interface missing. Anyone has an idea as to what is causing this behavior ?

Hi All, code:- !buttonArrayLayout( buttons: { a!buttonWidget( label: "Create", saveInto:{ a!forEach(items: local!filter,expression:a!save(local!items, append(local!items,{customerid: local!filter.customernumber[fv!index], tag: local!filter.tag.tagname[fv!index], portfolioname: local!filter.value[fv!index], portfolioid: local!filter.customerid[fv!index], tagid: local!filter.tag.tagid[fv!index]}))), a!writeToDataStoreEntity( dataStoreEntity: cons!portfoliomasterorg, valueToStore: local!items in the above code i am trying to insert the data into Db. how to not insert the duplicates into DB. Please help me to resolve the issue. Thank you

Hi, How can we print dates on mondays between the given start date and end date? Please provide the code for it. For Example: Input: Start Date: 24/May/2021 End Date: 25 June/2021 output:             31/May/2021              07/June/2021                14/June/2021              21/June/2021

How to compare letters of a single word in Appian: Suppose, We have to compare letters of word "Apple". The output should be: 1. Number of unique characters in word. In case of "Apple", it should be 4 2. Could of similar characters. Ex: In case of "Apple", A=1,p=2,l=1,e=1 Please provide code for this.

can someone help me... how to remove username from picker field if user is already reactivated.

Hi, I am implementing excel document upload functionality in Appian. My requirements is that when any document is uploaded on document folder on the same time a copy of original document will also generate on same folder.With the help of this we can maintain version(We do not want any modification on original file, so we need a copy of that document  on the same time). Please suggest the best way to implement this functionality.

Hello, How does the license deadline extension works? What is the expiration date for a long_term license?  Will there be notification message sent before the expiration? Thank you.

Appian Team, Please show a valid message after 14 days trail expiration instead of throwing error 404 and also please try to increase the free trail days 14 to 30 days. Thanks, Sivakrishna

If we need to update a value like status in cdt (multiple) with condition only update only where status =1 Is there a way to achieve this using updatearray and index or is the only option recreating cdt using a!foreach ?

Hi Team, When trying to deploy my application from Dev env to non-prod env getting the below error: The content [id= uuid=_a-0000e58e-c45f-8000-d3f4-680000680000_197245] was not imported because a required precedent is missing: entity [625a4a28-a511-4d5f-8c44-aca78e625125] in data store [id=54556 uuid=_a-0000dabc-5816-8000-048c-680000680000_28727] cannot be found. (APNX-1-4070-004) (APNX-1-4071-006) When trying to search with the uuid of missing entity in objects section of Dev env, there is no object found. But the object(query rule) which is dependent on this entity is already present in data store. Unable to figure out the issue. Please help. Regards, Anandita

a!buttonWidgetSubmit( skipValidation: true, style: "DESTRUCTIVE", confirmMessage: "Rejecting this batch will cancel all transactions from being processed and this action cannot be reversed. Do you want to proceed?", label: "REJECT", saveInto: { if( rule!CAS_canBatchBeCompleted(batchId: ri!deposit.depositId), { a!save(ri!buttonValue, cons!CAS_BUTTON_CANCEL_BATCH), if( rule!GBL_isBlank(ri!deposit.depositId), {}, { a!forEach( items: ri!sourceCashEntries, expression: if(ri!sourceCashEntries.allocationTypeId = 5, { a!save(ri!sourceCashEntries.suspenseIsOpen, true), a!save(ri!sourceCashEntries.isAdjusted, false)

Hi Team, When trying to add objects of my application into patch then getting the below error: HTTP Code: 500 APNX-1-4198-000 Error Evaluating UI Expression Expression evaluation error : [valid:false,syntaxError:false,value:Expression evaluation error: An error occurred while executing a save: com.appian.data.client.AdsException: The specified branch does not exist. Branch: 1052993] Any suggestions to fix this? Thanks, Anandita

Hi guys, We've got a process that runs daily, which gets login audit data from the system logs and populates them into a text document. We then use the "Import CSV to Database" smart service to populate those values into a table. On some of our environments it works fine, on others we're getting an error returned from the Import smart service: "No value specified for parameter 2". On further analysis, it appears the document we're generating using the "Text Doc From Template" smart service is being created empty, without any data, even though it should be populated. If I run the expression rule that populates it independently, it's returning values. Looking at it, as far as I can see the expression rule and the process that calls it are identical across all our environments, so I'm trying to figure out why it's creating an empty document when it should be populated. Any ideas how to troubleshoot further or what might be causing the

Since Appian is case sensitive. So my requirement is if I select a user "Radha" then it gets created but again if someone tries to create a username in lowercase"radha" then it should not get created. Do suggest how to check it.

Scenario: 1. John (Appian user) sends an email using the 'Send Email' smart service to an external user Sue. 2. Sue adds her response to John's email and sends it back to John, which comes back to John's Appian process (i.e., Receive Message) for email ingestion. 3. John identifies the incoming email from Sue as a response to his original email sent to her. But John wants to enhance the Appian process so as to emails in the same thread can be identified and categorized as such without his manual effort. ---------- I understand that above scenario can be implemented by inserting a key-value pair (e.g., [CaseID=12345]) into the email content. But I want to hide that custom key-value pair from the end user's view so that it cannot be tampered, intentionally or not. So, is it doable in Appian to: Assign/Insert a custom key-value pair to an email Send it out using the 'Send Email' smart service Retrieve the original key-value pair from an incoming email if

Greetings All, As I am very impressed with what I have seen with Appian and its strong community and marketplace, I am interested in getting a license. We are a new startup currently with four employees.  Over the next 12 months we will probably get to something like 10 employees and over the following year we will probably add another 10 employees.  So in roughly May of 2023 we should be at about 20 employees total. I was in a different forum asking about Appian pricing and an Appian Reseller told me there is a license program where the ability to use Appian would cost $1,000.00 per month. Can anyone kindly provide me a link that discusses the details of this offer? Is there a setup fee? How much would I pay for additional licenses for Infrequent Users and External Input? I understood that I would need a reseller to assist me with this.  Is there a German reseller reading this that can support the pricing as discussed by the other partner? Thanks very much!! Paul

How to add line break after formLayout contents , before buttonLayout. I have tried <br/>, and char(10), but none seemed to work. Thanks in advance

I just ran accross an interface that throws errors when I try to test it.  I noticed that it is running a!queryEntity so it should be an expression rule.  Is there an easy way to change it from an interface to an expression rule?

Hello,  Using Export Data Store Entity to Excel is there a way to be configured to not erase the current applied styles and formatting of the Excel File which is updating ? Currently of there is some kind of colors set-up it eliminates everything. 

I am trying to use import excel to database smart service for importing my data from excel into appian table. In my CDT i have columns of text and integer type. But when trying to use the excel file with integer column as blank it is throwing me error as:Incorrect integer value: '' for column `Appian`.`testBT`.`palletqtyno` at row 1??? where testBt is my tablename and palletqtyno is my column name whose data type is defined as integer in CDT

How do we call an interface with 6 user type and 2 group type in another interface.

In a!start process how do we call 2 user and 2 group type parameters from PM. Do posts code.