Foundation

Hi All,     can anyone please let me know, is there a possibility of creating a tile based chart in Appian like below,     Thanks in advance     

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.

Hello! How to debug an process model in order to find the reason why it stops? when the flow comes from the node SLA, it pass the other check(OR node) normally and the flows continue, but if the flow comes form the SLA2 , it stops on the OR node(Feedback all positive?). at this point I do not have any instance, any of current task and any error shows.  Where might be the problem? How I can find the solutions at this point? Thank you !

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

The multidropdown field now has the ability to search for specific items within the list of options. I noticed it's quite fast at finding what I'm looking for even with a list of 1000+ items. I would like to know how the search it's being implemented to achieve this level of performance. The reason why I'm asking is because I would like to try to implement it inside a custom picker if possible. The implementation I have is the same provided by Appian with a foreach loop and checking every item against the provided search. However this stalls with large amounts of data. I know I can just replace the picker with the dropdown since it does the search for me and I have done that. But I would still like to know if there is a way to have that nice search inside the picker for future reference. Thanks in advance.

I have stored data in so many rows for same date in editable grid. Now I am trying to display this data as read only grid in another interface row-wise. But I am getting data of only one row and not all the rows. The code related is inserted below:  a!localVariables( local!newGridRow: 'type!{urn:com:appian:types}Monitoring_Roster'(), local!addRow:'type!{urn:com:appian:types}Monitoring_Roster'(), { { a!gridLayout( label: "Monitoring Roster for: "& text(ri!monitoringDate,"dddd") & " " & ri!monitoringDate, labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell( label: "Monitoring Slot" ), a!gridLayoutHeaderCell( label: "Monitoring In Charge" ), a!gridLayoutHeaderCell( label: "Comments" ) }, columnConfigs: { a!gridLayoutColumnConfig( width: "DISTRIBUTE" ) }, rows: { a!forEach( items: local!newGridRow, expression: { a!gridRowLayout( contents: { a!textField( label: "Monitoring Slot", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: cons!Testing_TIME

Hi guys,  There is an option to change the background color/style showed in Tempo of the interface? Thanks, Erzen 

I have an ask to make a checkbox field have the following logic.  Checkbox has four items. If option ITEM 1 is selected then selection of ITEM 2, ITEM 3, ITEM 4 should be deselected automatically. If options ITEM 2, ITEM 3, ITEM 4 are selected then option ITEM 1 should be deselected automatically. Below code tracks the current values for the checkbox field in local!setA, previous values in local!setB, and the difference between the two sets which indicates what object the user just clicked in local!setDIFF. The issue we are encountering is that when the deselection logic is triggered, I can see local!setA's value meets the requirement but the checkboxField UI doesn't. It still shows the options as selected when they have been removed from local!setA. User has to make another mouse click action like clicking around the page then the UI reflects the local!setA values. Has anyone experienced a similar issue with checkboxField and were able to have the checkbox options re

Hello, I have created one CDT and it's first column is auto generated primary key and the same CDT is used to store the column values of the editable grid. I have used the below code: Here "Slot Id" is primary key of CDT stored in the newGridRow local variable. I don't want to display this primary key column as editable grid column but want to store the value of this primary key along with the remaining editable grid columns in the database table. I have Write to Datastore Entity smart service. It is adding the new row to the database table with auto incremented primary key but not adding the values of other columns of editable grid in the table.  Please help me.