Discussion Categories

From the above pic, in the local variables bankruptcy there will be constant 4 values and in the local variable creditPublicRecord there will be some values can be null or more than 1 value. Here we have to compare the creditPublicRecord values with the bankruptcy values and check whether the the creditPublicRecord values matches the bankruptcy values and need to return the count. Can someone suggest the way to complete this. Thanks In Advance, Gousii.

Hi All, Can any one guide me to use Unarchive process smart service plugin? I just need to know the security permission required to unarchive a process. If i am system administrator, I was able to unarchive process but i am not able to do the same if am having basic user permission.  Note: I have administrator access to both "Unarchive PM" and target PM(Which i need to unarchive). Also I was able to use "Archive process" smart service successfully with basic user access. Please suggest any reason behind this. Thanks in advance!

Can any one send me where is integration video tutorials for practising in deep

Dears, I have a problem in the calendar interface when the appian language is in ARABIC. The date shows and saves in Persian numbers such as : ١١٠٥٢٠٢٣. how can I keep the date language for all dates in English even though the user language still Arabic? the Persian numbers are causing me massive errors when I map them.

Hello  Team, In Appian  we have a Inbuilt function for sentiment score calculation for Text . "a!sentimentScore() " - only for text. And we do have Google Cloud Natural Language connected system to perform entity and sentiment analysis to collect information from HTML or plain text. But,my question is how do we calculate sentiment score based on voice. if the person who is taking Interview , how his voice is analyzed and get Sentiment score. Could you please help me in understanding How sentiment score calculate for Voice in Appian. Regards, J Vinay.

when we apply multi-select dropdown .. comma separated value is getting store in table in single row ..but i how to put in different rows. Output i am getting  Field Field Value Dropdown 1,2,3,4 Expected  Field Field Value Dropdown 1 Dropdown 2 Dropdown 3 Dropdown 4

Hi, I am working on an editable grid which shows excel data. I am fetching excel data from excel using "readexcelsheetpaging()" function. Now i want to map data to editable fields and i tried to do fv!item.fieldName but it is not working. a!localVariables( /*local!studentData:excelreadcellsbyname(ri!excelFile,{1},{"A1","B1","C1"}),*/ /*local!studentData:excelreadcellsbynumber(ri!excelFile,{1},{1,2,3},{2,3,4,5}),*/ local!studentData:readexcelsheetpaging(ri!excelFile,0,a!pagingInfo(2,10)), local!gridDataType: 'type!{urn:com:appian:SD}SD_Student_Data'(), a!formLayout( label: "Student Details", contents: { a!sectionLayout( contents: { a!gridLayout( label: "Editable Grid", labelPosition: "ABOVE", headerCells: { /*a!gridLayoutHeaderCell(label: "ID"),*/ a!gridLayoutHeaderCell(label: "First Name"), a!gridLayoutHeaderCell(label: "Last Name"), a!gridLayoutHeaderCell(label: "Em

Hi Team, I have a csv in which I am receiving "11 May 2021 07:08:12 GMT" as text in one of the columns, Is there anyway to cast  to Appian datetime type Regards Bihitak

I have a dropdown on an Create record action interface that utilizes a related table for its values. On the Update record action interface I need to have the same dropdown in case it needs to be updated, however I need it to retain the selection that was made when the record was added. I am struggling to setup that connection on the Update interface.

we recently implemented a process to read emails from an outlook inbox using the MSGraph email poller detailed here: https://community.appian.com/b/appmarket/posts/msgraph-email-poller after implementing we're seeing severe performance issues where the poller is only able to process one email per minute. the emails have a 1mb attachment, and per the documentation, we are expecting 30-50 emails per minutes at the very least. does anyone have any insights they can share to get around this performance issue?  thanks!

Buenos días. Mi pregunta es: ¿Durante el examen de certificación es posible traducir con google translate? Gracias.

Hi, We are trying to generate a CSV file from CDT and the first heading on the file starts with @ symbol. Now when I open the file in a text editor Appian/plugin adds some extra characters to it. How do I get around this? Example --  the file generated in Appian -  "'@ENB"NE ID,NE Type,NE Version,Release Version,Network,NE Name,Local Time Offset,EAIU,FW Auto Fusing,Site ID213208,macro,22.B.0,r_0130,TELUS,LTSAB0213208,0,not-equip,off,0 The output we are expecting - @ENBNE ID,NE Type,NE Version,Release Version,Network,NE Name,Local Time Offset,EAIU,FW Auto Fusing,Site ID213208,macro,22.B.0,r_0130,TELUS,LTSAB0213208,0,not-equip,off,0 Also, we don't want any space in front.

Where can we find the slide decks and other content from Appian world 2023? I attended Charle's Tsui's UX session and would like to reference those slides. 

Hi all,  I have this issue: i want to select somehow a specified row in a!griedfield component, like ID 24 in the picture below, then start a process with some value taken from that row, with a submit buttom or something similar that can appear when the specified row is selected. Is it possible to achieve this goal? This is a screenshot of my site in which the element of the only read grid are taken from a recordtype, so this is why the ID is coloured in blue.  Thank you in advance for the responces. 

Hi All, I am new to Appian, during one of my solution development I have found that I have deleted the rows from the oracle table and when I am trying to test the expression rule where I used Query Generator to get the data from that table , it's stil returning the old data. So can you please help me to know that how can I clear some cache or sync it with my tables ? I am using query generator to generate that expression rule.

Hi, how to read mails from gmail using Appian BPM using smart services?

I am working on "Interfaces 103" in the lowcode4all curriculum. I made a mistake and deleted the PF_Goals Record Actions - Delete Goals and Update Goals. Now I am unable to generate any record actions. Please advise me on what to do next in order to continue building the interface.

Hey, I am trying to configure a Picker Custom Field but am getting the following error: "Interface Definition: Expression evaluation error at function a!pickerFieldCustom [line 290]: The function 'suggestfunction' is unavailable." Here is my code: a!pickerFieldCustom(  label: "User Picker",  placeholder: "--- Select Borrowers ---",  labelPosition: "ABOVE",   suggestFunction: a!dataSubset(    startIndex: 1,    batchSize: -1,    data: if(      local!view = "Borrower",      index(local!borrowers,"borrower",{}),      index(local!lenders,"lender",{})  )  ),  value: if(    local!view = "Borrower",    local!selectedBorrowers,    local!selectedLenders  ),  selectedLabels: if(    local!view = "Borrower",    local!selectedBorro

Hi All, Kindly help me I want to use Email in the process model . Like example I am using any smart service (like write to data store entity) then this nodes fails . if the node fails than I want to send email through using email service in the process rather than the group alert or any name mention in alert. And How to configure it? Thanks 

Hi, I have been using the Deprecated Export SQL to Excel Smart Service for a document download functionality. When the process model is initiated back to back like twice, or randomly out of nowhere with even the first try, the smart service gives this error and the process model fails: "The following error was raised by the Export to Excel function: ORA-01843: not a valid month".  I did an analysis on the SQL code, it works on the database and I believe it should be fine. In the SQL code, I have to_date function and I am comparing two dates with different formats such as MM/DD/yyyy and yyyyMMdd. I am wondering if anyone else is facing a similar issue and what would be the possible solution?

Hi Is there a way to sync all records within an application? Thanks

I am getting the error some time page is opening it is getting reloaded after 3-4 sec and showing this error.

Home Page displayed with following error message  An Error Has OccurredCould not find "store" in either the context or props of "Connect(XrayConnectedComponent(Pure(Interactive(XrayComponentSelectionManager))))". Either wrap the root component in a <Provider>, or explicitly pass "store" as a prop to "Connect(XrayConnectedComponent(Pure(Interactive(XrayComponentSelectionManager))))". Expected:Application Should free from expression errors

HI team, iam using Zoom connected system community.appian.com/.../zoom-connected-system How we get the recordings by giving Meeting id for locally saved? i have recorded a meeting and save it into local folder.so i know that cannot fetch the local files. but to get the recordings where should i save the recordings can anyone help me to get recordings. Thanks & Regards, J Vinay

I'm updating my database table using the "Write to Data Store Entity" I have an array of uploadId's that are my primary key. When writing to the DSE, I'm passing additional information like the current time now() and some other text values.  In the error (see image below) you can clearly see that the first uploadId (10473) is passed with the additional information. However on the 2nd iteration (uploadId 10474) all of the additional values are null. How do I pass multiple values using this smart service?   Thanks!