General

Hi,  User Needs to enter the data and complete row data needs to be sent via mail.  Have created a template and its working fine, If  user is entering the value for salary field  for first row. But when user is entering the value for salary field in second or later row then am getting the mail with Salary field empty with first row data. Though Data is getting saved in database if user is entering the Salary in second or later row.

Cannot apply operator [EQUALS] to field [cid] when comparing to value [TypedValue[it=3,v=ri!cid]].

I want to show all the details in record for particular user, but i am getting error a!columnLayout( contents: { a!radioButtonField( label: "Shipping Address", labelPosition: "ADJACENT", choiceLabels: local!fulladdresses, choiceValues: local!fulladdresses, value:ri!pmt['recordType!{0f579015-721a-48ec-8248-a710bdd30532}PMT Purchase Record.fields.{fullAddress}fullAddress'], saveInto:{ ri!pmt.fullAddress, } ), the above error i am getting in Record, when I click on particular user

I need to send mail from  say 'AKS-DoNotReply@HSBC.com'... but when am trying to send its saying "No valid recipients resolved". but from other mail id am able to send .. My doubt is AKS-DoNotReply@HSBCcom mail id needs to be created which Appian guy needs to create. Or is there some configuration am supposed to make if so please guide with steps. Note: Am using Custom Sender to send Email.  

Hi Team, We have a requirement where we have to create an action through which Project Lead can do mass update the records of those contacts who have left the organisation with a new contact. Can anyone suggest how to achieve this?Any help will be appreciated.Thanks, Anandita

Hi All, I am trying a way to create a list of users and their associated groups and download it in a csv file. This is the code snippet to generate list,a!localVariables(   local!users: getallusers(0, -1),   a!formLayout(      label: "Users & Groups",      contents: {         a!forEach(          items: local!users,          expression:              a!textField(                label: "UserName :" & " " & user(fv!item, "username")&","                & " "&"Name :"& " " &user(fv!item, "firstName")                & " " &user(fv!item, "lastName")&","&nbsp

Do we have the option to communicate with Hyperledger Indy and its smart contracts. Just curious to know

I have added new data source from Appian Console. -appian console -> data sources -data sources -> +new data source As I have added a new data source, Is there a way that I can verify newly added data source from Appian Cloud Database site. And work with the newly added data source within Appian Cloud Database site.

is it possible to endorse a member of an already completed project? this in order to complete the L3 certification

My DB is in GMT & Appian environment is in EST, when we take action in night time(after 7pm EST) date is showing always a future date so we tried to convert that date into EST by using this function text(gmt(local(now(),"EST")),"m/d/yyyy") its giving correct date, but in day time when we tried this its giving past date can anyone suggest what is the solution. Thank in advance.

Hi all, newly registered user here and still trying to figure out my way on the trial interface. I am looking to build a native mobile app for people to upload and share photos, something similar to Instagram. I would like to ask if anyone has used Appian for something similar before?

Data is auto-saved in the Appian. For eg if user Tries a search by number then list of prior searched numbers are listed in the text box. This is happening throughout Appian application where user has option to enter data in text box. Is this known behavior of Edge ? or do we need to any additional configurations ?

Hi Guys, Can you please help me with the below query, In my project, we are working on a private network and wanted to connect Appian cloud through Saas service. For that, to establish the mutual SSL handshake via the outbound proxy. How can we configure the digital certificate from our side to get trusted at Appian Cloud. Please guide me. 

I have a process model with only a smart service for sending emails but I only receive them in my outlook/hotmail account. If I try to send to my gmail account or other, I don't receive them. Can anyone explain why this happens? And what can I do to solve this? Thank you.

Case: Read Excel data and update few fields from the EXCEL in the database. Steps: 1. User exports the data (Including ID field) in an Excel from the Record type view(only download 20 attributes out of 50 in the data type field)2. User updates few Fields in the excel then uploads through an action given on the record type view.3. Action calls the process model which has an Interface for the user to upload the document (created a Process variable of Document type- BulkUpload).4. In the process model I call an expression rule which passes the document (BulkUpload) as the parameter in the Script task output and retrives all the output in a particular format. Issue: Script task output generates two null records and adds two null rows in the database. However, when I test the expression rule separately then the output is as expected and reading all the records accordingly.

Hello, I have the following query:  Dictionary  id1(Number (Integer))   currency"USD"(Text)  createdBy"user1@gmail.com"(Text)  value 1000 (Number (Decimal))Dictionary  id2(Number (Integer))  currency"USD"(Text)  createdBy"user1@gmail.com"(Text) value 2000 (Number (Decimal))Dictionary  id3(Number (Integer))  currency"USD"(Text)  createdBy"user2@gmail.com"(Text) value 2000 (Number (Decimal)) Question is how to foreach this and the result to be grouped by createdBy in this case and the value to be a sum.  Example result:  createdby: user1@gmail.com value: 3000 createdby: user2@gmail.com value: 2000

Need to compare time and if its not following order then color of box should change to Red(using TagField). Eg: I have to compare between T1,T2,T3,T4,T5,T6 Field Whose value am getting from database( T1=10:30,T2=10:35,T3=10:40,T4=10:45,T5= 10:50, T6=10:55) 10:30<10:35<10:40<10:45<10:50<10:55. My doubt is how to compare the timing since am getting it from Db. 10:30<10:35<10:32-- T3 box color should change to Red.

On submit button, I have ri!upload saved with two value [1]- docno:123,ticketNo:444 & [2]- docno:124,ticketNo:3334  when running process model getting above error? if more input details need to clarify my query please let me know.

If I have table values below from a database table. Column A Column B Column C Column D Value 1 Value 2 Value 3 Value 4 Value 1 Value 2 Value 5 Value 6 Value 1 Value 2 Value 7 Value 8 Is there a way to display it like below in Interface? Column A Column B Column C Column D Value 1 Value 2 Value 3 Value 4 Value 5 Value 6 Value 7 Value 8

I have a task form which has many data sections that users can update. Each section on the task form refers to a CDT and a table. In one of the sections, I have a column of type Number(Integer) int(11). Due to a new business requirement, I have to change the column to decimal(19,2). In order to achieve this, a new version of this CDT should be created by modifying the int(11) column to decimal(19,2). But there are hundreds of instances in production where this task form is still open. If the CDT is updated, only future instances of this task would be able to support decimal(19,2). All the old instances would only be able to support int(11). But we want this fix to be applied for both the old and new instances. As a work around, Instead of updating the section directly on the task, I have created a link using a!recordActionField() where I am showing the same section on a pop-up from the task form. Users will be able to update this section from the pop-up which runs off the latest versio

Hello, I have the following example:  ownerString is a text string: email1@gmail.com; email2@gmail.com value: a!forEach( items: split(fv!row.ownerString, ";"), expression: stripwith(fv!item, ";") ) the result of this code is:  email1@gmail.com; email2@gmail.com Where the expected result have to be  email1@gmail.com email2@gmail.com in order to be used inside user() function. The difference is the ;  which is not being removed.  Any suggestions are welcome Thank you. 

Hi All, I've gone through all the Appian foundation training online and about to explore hands on using my data. I have a excel file which is  want use it as records  in appian and build custom logic and build a process model and I'm stuck at the moment on how to bring my excel files Any thoughts please.

I want to copy rows of one editable grid to the database table for the another grid: Editable Grid1: abc (columns: column1, column2, mDate, column4,column5) Editable Grid2: xyz (columns: column1, column2, mDate, column4,column5) I want to copy values of columns(all rows) of editable grid1 to the database table for different mDate selected for editable grid2. 

I have used the remove icon as the last column of each row of the editable grid. When I click on it the respective row gets deleted from the rule input it is storing but not from the database table. I am using the below code: How to delete the specific row from database table as well by clicking on remove icon?

Suppose, I have created one local variable abc storing CDT: local!abc: 'type!{urn:com:appian:types}Monitoring_Roster'(), Now I want to store only 2/5 columns of this CDT in seperate local variable, How can I do it?