General

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?

Hello,  When I press a button right now it generates a excel file but I want at the same time to generate the excel file and also execute stored procedure, is there such a way, with one click of the button ? a!buttonArrayLayout( a!buttonWidget( label: "Excel", saveInto: { a!exportDataStoreEntityToExcel( entity: cons!BBO_OpportunitiesReportExcelDataStore, documentName: "Excel Export " & now(), saveInFolder: cons!BBO_ReportsFolderPointer, onSuccess: a!save( local!exportDocId, fv!newDocument, ), /*This displays an error if there is an issue executing the the save*/ onError: a!save( local!errorMessage, "Error Exporting File to Excel" ) ), a!save( local!staussave, true ), } ) ) And this is the stored procedute code:  executestoredprocedure( dataSourceName: "jdbc/Appian", procedureName: "deleteOppExcelData" ),

Hello community, I would like to rename some fields in a CDT to match the naming used in the JSON input. When I began to build the naming wasn't clear yet.Offcourse I can map the data, but like it better if the naming in the CDT match the naming of the input.After I changed the name, I noticed that the name is not updated in expressions.I probably have to manually rename in code referring to the old name.But when I try to remap in the process model the old name still appears in the node and I am not able to select the renamed field.the situation is like: CDT.oldName changed to CDT.newName but I am able to select CDT.newName. Kind Regards, Erik

Hello,  Is there a way generated Excel file with Excel File tools inside Process to be automatically downloaded for the user once the file is generated ?

Hi  Let's see I have a filter, it gives you fromTime and endTime. and I have 4 time point which is:    00:00,   9:00,    13:00,   17:00 The text number I give to those block as  "00","09","13","17", now, base on the filter's fromTime and endTime, if my fromTime = 00:00 and endTime is null, it should return me {"00","09","13","17"}.         if my fromTime = 07:00, endTime is null, it should return me {"09","13","17"},         if my fromTime = 09:20, endTime is 13:20 , it should return me {"13"}, How should I do the if condition smartly to achieve this, thanks!!!!

I need to send mail to multiple people based on selected location.. lets say: I need to send mail to people based on selected location. There are multiple location (A,B,C,D) There mail needs to be sent to 4 people: (M1,M2,M3,M4). If i select Location A then a mail should be triggered to that location only and all  4 people should receive mail for that particular location. Can someone help with the logic 

Hi All,         i have a requirement to create custom picker for populating country code based on the country name or country code entered. for eg: if i enter USA then it should show 1 and if i enter  1 then it should show all the codes containing 1. My doubt is will custom picker allow user to search from multiple data subsets(name and code).i have checked the documentation ,there it is mentioned using only single data subset. kindly provide your suggestions if possible with any examples. Thanks in advance. Pradeep.B

I want to store the value of 'Monitoring Day' text field into rule input. Please find the below code I am using: a!textField( label: "Monitoring Day", labelPosition: "ABOVE", value: text(ri!monitoringDate,"dddd"), saveInto: a!save(ri!monitoringDetails.monitoringDay,save!value), showWhen: not(isnull(ri!monitoringDate)), required: false, readOnly: true, validations: {} ), It is not storing value in ri!MonitoringDay.

Good morning, Is there a way to re-assign a task that has been accepted by an user for other user? For example, user A accepts the task, but user B (a kind of admin/supervisor) needs to assign the task to other user I know that if user A assigns the task to user B, this could be possible, but that is not usefull for us, we need user B has the direct option to re-assign Thanks

Hi All, How to get ids as{7570,6645} from multi-file upload expression: {fn!todocument(7570), fn!todocument(6645)}? Answer: toInteger() is it possible to store array as {7570,6645} in DB column docID? then retrieve to display uploaded dox list on UI. Answer: using another table to store ids in each row