Discussion Categories

What is the possible issue with the below code. I'm trying to make a selectable editable grid, I have given identifiers as well and converted raw data into datasubset but still the selection I do is selecting all rows whenever I click on any one. Note: Checkbox is not ootb grid selection. The problem is with ootb grid row highlight selection. { /* This is a lighter style of tabs that works well when you are on a page with record views or some other */ /* set of buttons right next to your custom tabs. */ a!localVariables( local!selectedTab: 1, local!customerId, local!selectedDetails, { a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!richTextItem( text: "Life", link: if( local!selectedTab = 1, null, a!dynamicLink(saveInto: a!save(local!selectedTab, 1)) ), linkSty

Hi All, One of our requirement is to merge the data from two applications into one. Both of the applications are created in same Appian instance and database is Appian cloud.  One of the application uses default Appian schema whereas other one has it's own schema under Appian cloud. This schema is already added to Admin console. Now we need a way to connect this two schemas to be able to merge the application, is there any way to do that?

Hi People,   I have input task USD 12345789. I want to put comma between the amount based on currency and I want output like USD 1,23,456.89. I tried several logics but not worked and output is USD1234,567.89. Can anyone help me? Thanks in advance. 

I am working on a process model where I use an integration to call an API. The API contains about 82,000 records, but it returns only 100 records per request. To retrieve all the data, I use a loop. After each API call, I save the 100 records using a record type. Does this slow down the environment if I delete the instance after every successful run?

Hello All, We have requirement where we would like to trigger a process Model after receiving an Email. We have looked into 2 scenarios, Email Poller approach and Receive message Event via Email. We have a few questions regarding the Receive Message Event. 1) When the users use the processmodel<uuid>@subdomain.appian.com as the email, we would like to change the Alias of the email to the one we would like them to see. We work on Appian cloud. How do we make this change? 2) Once the Alias is changed, can we use the Alias as From email to use in the Send Email Smart service? 3) For the Email Poller Approach, apart from the Mailbox and the MsGraph Smart service plug in, do we need to configure any other settings in Appian for it to work? Thank you for your help.

Hi I need to validate if the correct excel is uploaded by validating its content . I have different excel upload for different activity. If the user uploaded wrong Excel and do the submit it should display that excel is not for this activity .  Is there any way to do that. Can anyone suggest a way and how to implement it.

Hi all, I'm a bit new with custom record fields, so I'm probably doing something wrong. I have header and detail records (with a one-to-many relationship connected with a detail reference to the header key), and that data flows throughout the system just fine.  But I added a real-time aggregation / sum custom field (for totaling amounts in the detail record for presentation) and am having trouble getting data into the new fields. When pressing the 'Test' button in the Edit Custom Record Field screen, I see data grouped and summed as needed which is great! After saving the new custom field, the 'Data Preview' test button does NOT return any data in the new field, and that is also the case with an interface that references this. I've done resync on both records.  The new custom field exists on the detail side of the relationship and when defining the field, I use the format: headerRec.detailRec.amountToBeSummed. I've a

Hi team,I need help regarding to the Fetching the DB table names into Appian INV, using the table name,Example: i have table name called Students in DB if i select that name in Appian Interface I need to display that Students table details in InterfaceIs it possible or not if it's possible could anyone help me with it how we can do it

We have an oauth2 authorisation with client Id , client Secret  & scope to connect to an api. We already have a connected system configured for this . This is working fine & we are getting expected response from api. Traditionally in our organisation we have a process model per application  which runs every 60 mins which generates the token  & writes to the token table. This token from db is accessed and set in the the header of the request as Authorization: Bearer ******. But it seems our code is working even if that Authorization header is deleted from the integration. It seems the connected system is adding the Authorization header to the integration request and the process model to token generation is not required at all. Does this a ring a bell ?

Hello, We need to export data from a database based on user-selected filters into an Excel sheet for reporting. Currently, our process queries data in batches of 500 rows and uses the deprecated "Export CDT to Excel" function to generate the report, as we need to export 80 columns. Since we are running in batches, we cannot keep the smart service into separate start process as we are appending the generated document with new values and incrementing the start index.  However, as the data volume has increased, users are exporting data upto 50,000 rows, leading to memory heap issues causing Appian server to go down. The latest export functions have a limitation of 50 columns, which does not meet our requirements. We made process variables as hidden but still memory is hitting upto 6k AMU. We are using mySQL as database which is hosted on AWS RDS. Currently we are using a!executeStoredProcedureForQuery() to query the data from database. Before we wer

Hi I need to display the group name provided in the DB save as groupid for the users & groups but unable to do so DB group value:  Kindly guide in order to rectify it

So, I'm building a record where i have all the items in the store, then i can drill down to 1 item and update ir, but when i click on update item related action i get this error:  An error occurred while applying the context for the AS Items In Store related action [identifier=21]. Details: No process parameter found corresponding to override [name=pv!item]. Non-parameter process variables cannot be overridden. Any help?

I have to build a new application that is similar to another one so I wish to clone the application with another name in the same environment. How can I do it? Thanks

I need to check whether the documents uploaded by the user is not exceeded 10 MB. Apart from using document function which requires the document ID how this can be implemented

Hi i need to fetch the group name provided in the DB as Groupid.

Hi, I'm just getting started with learning Appian. Was trying to create a recordtype from scratch with v25.1 community edition. But, dont see an option to do so Can someone please help?

We have an Appian sandbox server for training on our on-premise Appian servers, and we're facing an issue with component plug-in approval verification failing. When attempting to add a newly developed component, can you advise on how to bypass this process? We are using our on-premise servers and do not plan to upload these components to the Appian Market.

Hello, I'm trying to generate document from XML code. I have already seen many of the community posts, I followed the same pattern to generate doc using xml code, but I'm getting an error, says that syntax error in template. Please let me know what i have done wrong here. ERROR:"Syntax error in template ""fr.opensagres.xdocreport.document.docx.DocxReport@6c1fb8c6!word/document.xml"" in line 4, column 4957:" & fn!char(10) & "Encountered ""name"", but was expecting one of these patterns:" & fn!char(10) & " "".""" & fn!char(10) & " ""..""" & fn!char(10) & " <DOT_DOT_LESS>" & fn!char(10) & " ""..*""" & fn!char(10) & " ""?""" & fn!char(10) & " ""??""" & fn!char(10) & " ""!"&quot

Hi All, I am using gridPlusLayout , i want to know how can we put validation on columnConfigs. 1.Like if want to put validation for null or empty. 2. the second concern is when i am editing a field after made changes it save data into separate variable, but every time when we load grid it by default creates a null empty row and add that row also in save data variable. so when i am saving that record  in record type it thorw error because a null type or row is also adding into save data variable.  It works fine when we manually remove that data from grid but when we don't remove that causes error. So how to handle this situation.

Hi i need to fetch the group name provided in the DB as Groupid.

I have all admin rights. On process modeler if I try to edit any node on "edit process view" I only have the "node properties" option. If I try the same with other user I can edit it with no problem. I tried on incognito mode, clearing cookies, different computer, change to basic and again to admin rights... I can only solve the problem creating a new user... but that would not be the right things. Any suggestions?

<!DOCTYPE html><html lang="en"><head> <meta charset="UTF-8"></head><body> <pre></pre> <script> document.body.insertAdjacentHTML('afterbegin', "Dinesh"); </script></body></html>if i use the script  inside double quotes the script not working

What does memory used % represents in the Appian cloud support site? We have 3 servers in prod and one of them is having around 68% memory used. But in Appian health check report, its showing as 1500MB which we are assuming its pointing to RAM. If only roughly 2gb is occupied by instances, what does the remaining memory is taken up by? We have 75 gb ROM memory for each server and 32gb memory for RAM. Any insights will be helpful

- Use a subprocess. - Call a web API. - Use a!recordActionItem(). - Use a Start Process smart service. - Run a!startProcess() from a script task. Thanks

Hi Experts, Please help me to resolve my issue. I want to convert the following data returned in "Text" format into a list of dictionary/map and afterwards map these fields to a CDT. { "IPAddress": "111.101.1111.11", "StartDate": "2024/06/26", "StartTime": "23:24:49", "StartTimezone": "UTC", "EndDate": "2024/06/28", "EndTime": "17:38:12", "EndTimezone": "UTC" }& { "IPAddress": "111.111.1101.11", "StartDate": "2024/07/02", "StartTime": "02:52:07", "StartTimezone": "UTC" }& { "IPAddress": "111.111.1110.11", "StartDate": "2024/07/07", "StartTime": "18:10:37", "StartTimezone": "UTC", "EndDate": "2024/07/09", "EndTime": "03:50:30", "