Discussion Categories

Hi, I have an interface with a read-only grid. I am loading the data into read-only grid using RECORD TYPE and also I have used selectable, selectionValue, selectionSaveInto properties. I would like to implement delete functionality, where I need to allow multiple rows to be selected and click on "DELETE" button so that those selected rows of data should be deleted from the database table.

Hi All, I need to pass a  Safe URI to source parameter of webContentField component and that URI is generated using web API. Problem here is when I am using the URI generated from web API it throws below error: "Interface Definition: Expression evaluation error at function a!webContentField: A web content field [label=""] has an invalid value for "source". Source may not be an internal Appian source. Received: mydev.appiancloud.com/.../YoU0wA." How can we pass the URI that is Internal to webContentField?   Thanks in advance Regards, Trunal Jain

My Appian Timezone is set to Pacific time Below functions are returning correct time now()  -   2/20/2023 5:40 AM PST datetime(year(now()),month(now()),day(now()),hour(now()),minute(now()))   -  2/20/2023 5:40 AM PST However, when I try to create datetime where I want to change the date and time acc to my preference, the timezone offset gets added.  datetime(year(now()),month(now()),day(now()),0,0) – 2/19/2023 4:00 PM PST   I want the output as - 2/20/2023 12:00 AM PST       Requirement for which I want to create datetime in specific timezone. Now I want to create a datetime so that I can use it to filter the datetime column stored in DB I need to fetch all rows from DB where the createdDate is say 2/20/2023 so for that I thought of creating a query filter as Date between (2/20/2023 12:0AM PST and 2/20/2023 11:59 PM PST). However I am unable to create datetime in particular time zone  

Hi all. I'd like to know if Appian can be integrated with a versioning software like CVS. The goal is to store each Appian component version with the ability of identify who modified a component, what changes are made and recover old version. Thanks in advance.

I am trying to Execute a SP from Query database Smart Service in Process model and getting a Timeout Error.I wish to Handle the Process flow and not let the Process stop immediately and continue the Exception path. Note : i cannot use Execute Store Procedure Smart Service as my SP is taking longer than 10 min.

Hi, I have 2 groups one is parent and child. Parent grp having test users and second grp having SSO users. How do i show users from both groups in user picker. I can’t merge or delete groups. Client having thier own way of handling these grps. Thanks

Out of curiosity - has anyone implemented Search capabilities in Appian for Homophones?E. g. searching for a user in a database field for names, typing in 'Fill', Appian will search also for 'Phil'. Thanks

Hi all, The title basically describes it. I'd like to be able to apply filters on a list of maps on their key values. For example in the code snippet below, to be able to set filter("name","=",bill) or filter("name", "not null"). Similar to a!queryEntity but for a collection of map instead of a Entity   a!localVariables( local!mapCollection: { a!map(name: "bill"), a!map(name: "bob"), a!map(name: "Jim"), a!map(name: null) } ) Also be able to apply operands like and and or if there are multiple key values in the map collection

Hi, As per my requirement I had to make use of the plug-in called "Twilio" for sending SMS to the users to authenticate them. I also created an account in Console Twilio in order to get the tokens to establish the connection. And I managed to get the URLs of first 4 fields like the Account SID, Authentication Token, API Key SID, API Key Secret.  But I am unable to get the path for the remaining 3 fields which are TwiML App SID, Workspace SID, Chat Service SID. Can anyone help me out how to configure the remaining and from where can I get the URLs of those particular fields. Thanks in advance, Gousi.

Dear community, within our project we have the requirement of full traceability from a work-item in azure devops to the actual code changes. Are there best practices to do that within the Appian environment or possibilies which would allow us for example to force the user to enter a description before he can save an object, automatically export the objects from Appian via a Rest-Api and then commit them in git ?  Thanks, Patrick

Hi Champs, I have a use case where I don't need to show the related action in a record related action tab ; but I need to call that related action of a separate interface. the reason for doing this is I have to call an interface in a popup/dialog ; which can only possible in related action.  Is it feasible to do so ?

Hi Everyone,  I am calling the expression rule from the interface through button widget using startprocess and the process model calling the rule in the script task. But the rule is not executing. Can anyone please help me how to achieve this? Thanks in advance!

Hello All, We are using 1 PM in which we are using the smart service "Execute Stored Procedure", We are having 10K+ data in the staging table and we are using the batching logic to trigger the stored procedure for 1000 batch. Th stored procedure function is to get that batch start and end index as parameter and fetch that much data from the staging table and run different sql queries , insert data in the different table. The same sub process I am using multiple time but when 1 is ending I am triggering another one, not running all parallel. I am getting wired error in some batch running after 7000 or 8000 data. The error: "An error occurred in executing an Activity Class." Not getting anything in logs as well. Sharing the screenshot of the error aslo. Let me know how to resolve this issue. Thanks in advance.

Hi! I have a process model which creates a XLSX file, which I want to convert 1:1 to CSV. But I have 2 problems: 1. The columns don't get separated and are written to the same column, where attributes are separated by commas. 2. For some reason even having only one row in excel, it continues to read until row 95, so I get 95 rows full of commas. Screen:

Hello, I am trying to randomly sample x amount of rows from a CDT by generating x random numbers in the range 1:length(myCdt). The issue I am getting is that some of these random numbers are repeated.  Is there a way to generate random numbers  in a given interval and have them be unique?  Here is what I have so far: local!randomNumbers:if( length(local!query)>15, 1+ tointeger(rand(15) * length(local!query)), local!query, ),

Dear Team, I am experiencing an issue with synced record types while deploying package from dev to Test environment. Issue: Error validating source for synced record type - APNX-2-4195-000 Possible Root Cause: Data source for record type is different in dev and Test. Alternate Solution: I can able to deploy the package, However i need to open the record type in target environment and change the datasoruce. Comment: Our deployment will not to do above mentioned alternate solution in each higher environment. Please provide any other possible solution. Tried options: I tired modifying the .xml file with target datasource, but when i select the package it says, package is invalid.

What is the best practice for naming a datasource in Appian? In DEV, UAT, PROD can what should be the name of datasource be provided?

How everyone, I have the requirement to merge two or more rown in a grid. An example is shown below: Col A Col B Col C 1 2 ab cd 7 9 yz If the value of col A and col B are same for two rows and Col C value is different then both rows for col A and Col B should be merged. Thank You

Hello everyone, I'm just starting learning to work with Appian, I'm currently doing the Developer's Path. Today I encountered a problem that seems very simple. I just can't add Rule Inputs while creating a connection to an API I tried clicking in edit as an expression, but I'm just getting this Thanls

If there is any expression evaluation error on interface, how can we display that error on UI if want to show to user. Reason for error need to display on UI.

Hello everyone, I need to setup the possibility for user to access through MFA, like username + password and code received on the phone or on an app like google auth. Is there anyway to do that on Appian?I know about SAML but, for me, it isn't clear if it works only with identity provider or with other methods. I work with Appian Cloud Version. Thanks for your attention. I'm looking forward to your reply. Daniele

Hi Champs, I have a requirement where I have to show the record related action in a link format along with the helptooltip/description (whichever is fine). I am using a!recordActionField to achive the same as I have to open the interface in a pop-up. but in the same component there is no helptooltip available. What is the alternative approach for the same. I need something like this I can see in Appian related action it shows in this format. Not sure how they have  done this.

Hi Team, just got this Requirement So when i click the Collaspe all button The box layout which is below should get Collapsed. Any one can help me with this I made like after clicking this button a local variable is changed to true and after that i wrote that in iscollapsible condition but not working

Well the problem I have is like this, the first is that I do not have access to the database, and the main problem is, I get from this database, data, it turns out that when I get a column with values, they do not respect the numerical order, for example; 1,11,132,145,186,2,22,234,257,3,4. that is an example, it only respects the first digit to the left. Another thing I noticed is that in the db, they use varchars instead of an integer, my question is, if I can not access the database, is it possible to change by means of a filter, or by means of some expression the format? I already tried to call my recordtype, with a cast, but it sends me an error when I do it from my recordlist for filters. for example tointeger(recordtypebdd.fields.values) and I get an error... I hope you can help me.

I have contact recordtype and experience record type with 1 contact to multiple experiences, linked through contact.id = experience.contactId. I have a form which saves contact details and a editable grid to capture multiple experiences. When I save I run a process model to first write to the contact DB and then I am writing in experience data entity. In the wirte to DSE for experience, I have mapped the input of data note in second process with contact.id generated automatically from DB in contact table.This works fine with 1 experience entry, but if I add 2 entries then the process error out as for 2nd experience entry the contatId is null and due to which unable to write the data in experience table. Can someone help?