Foundation

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 ?

Hello, I have a local variable which holds the data retrieved by the rule(queryEntity columns). The columns retrieved are Col1, Col2. I want to add Col3 to this. eg. local!QA[1]: [Id:243,value:"Question"]  these are the columns retrieved from the rule . I want to add column "Answer" to this. There can be multiple rows. I tried getting the individual row using foreach(), but then idk how to add anothe column to the row. how can i do it?

Hi,  I have the following case: - interface that is built with one large main boxLayout which has 5 boxLayouts inside it and 1 buttonLayout (sectionLayouts and formLayouts are not option AFAIK because this interface must be child interface) - there are some casual "required property" validations and some with more complex calculations - "required" validations are present in all 5inner boxLayouts and this complex one is present in the last boxLayout (last boxLayout contains a gridLayout and these validations are regarding SUM of values in grid rows and chronological order of the dates in the grid rows) - I need to perform these validations ONLY on a click of a button in the last part of the initial boxLayout - this button is NON submit and it saves values to 4 rule input CDTs and finally starts a process with a!startProcess - this interface is child interface of the existing parent interface (it is embedded inside one of its columnLayouts) a!boxLayout(

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

There was a new feature added recently in 21.1 where you can view the history of all archived processes in the monitoring view. With this feature, can I unarchive any archived process? Or would this only work on process archived after this update? I don't see anything when I select Archived for process status. And yes I have several process that are set to archive in 1-7 days.

Hi All,      I have a Paragraph field in the grid, which i have limited to 500 char, but i want to show the count of characters below the paragraph, for that am using Instructions,still with no luck,     Can anyone please help me on this,     a!paragraphField( value: fv!item.comments, saveInto: fv!item.comments, height: "SHORT", instructions: "Number of characters " & len(fv!item.comments) & "/500", refreshAfter: "KEYPRESS", disabled: if( local!accessoftheGroups = cons!CMP_GROUP_ACCESS_VALUES[2], true, false ), validations: if( len(fv!item.comments)

Hi All, Please help me to display a pop up message for when the process  has been completed successfully when the form values has been successfully added to the database 

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

Hi, I would like to show date range (Mon to Fri by default and I have created rule for this) so I have a requirement to show date range in dropdown field. Thus user will select particular date range and data will modify according to date from Monday to  Friday. Is there any best approach to do that ? Will appreciate your help. Below are the images for ref. in first image user has selected date range 5/3/21 - 5/9/21 (Mon To Fri) and it's filtering data by date in 2nd image

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

My dropdown field is this: a!dropdownField( label: "Appliance Id", labelPosition: "JUSTIFIED", placeholder: "Select the appliance", choiceLabels: rule!LN_Concatenate_Appliance_Customer_Details(local!userId), choiceValues: rule!LN_Fetch_Appliance_Based_Customer_Id(local!userId).data.applianceId.applianceId, value: if(isnull(local!applianceId), null, local!applianceId), saveInto: {local!applianceId, ri!Servicing.applianceId.applianceId}, showWhen: ri!isCustomerCare ), I want the selected Choice Label to be saved in a rule input variable. How can I do that? The choice values is basically the id, but I need it, so I cannot replace it with the same expression rule as choiceLabel. Thanks in advance!!

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