General

Hi Everyone, I have an interface where the data is populated from record type and in the interface there is one link field where I am passing the record type field and identifiers. I the record type I have added the summary interface which will get open on click of hyperlink. My issue is how can I pass rule inputs from interface to the record summary interface? Any suggestions are welcome!

Hi All, I have a requirement where I have to export the request to PDF. So to achieve this I am using "DOCX from dynamic template" smart service. Here I am facing 1 challenge, I have a Database table where I have data in below format(like grid), Section Name Clause Text Amendment Number date Sec1 Text1 1 18-01-2023 Sec2 Text2 2 18-01-2023   But in word, I want the above data as separate sections, like below format Sec1 Clause Text Text1 Amendment Number 1 Date 18-01-2023 Sec2 Clause Text Text2 Amendment Number 2 Date 18-01-2023 So please help me how to create dynamic sections based on the number of rows of data in word, I tried below one, but it is not working, throwing the error

I have one array like {1,2,3,4,12,12}, I want a new sub array from 3rd index till end like {3,4,12,12}is there any rule or function?

Has anyone successfully installed Appian on a Mac that uses the M1 Chip (Apple Silicon)? Currently I am having an issue as the Dockerfiile is using centos7 which is created for Intel chips, and its resulting an error because of the M1.  Getting this error when doing a docker-compose build: failed to solve: rpc error: code = Unknown desc = failed to solve with frontend dockerfile.v0: failed to create LLB definition: no match for platform in manifest sha256:691c55aabb3c4e3b89b953dd2f022f7ea845e5443954767d321d5f5fa394e28c: not found Another example of the error: https://stackoverflow.com/questions/67911250/cant-build-docker-compose-on-m1-chipset  I know this is not an Appian issue but anyone that has been through the same thing and managed to find a solution would help a lot!

Hi, How to prevent running of truncate and delete query accidentally on database table. Is there any role and access setup can be done to prevent this considering having "System Admin" access in APPIAN. Regards Bihitak

{1,2,3}, {56,76,54,32}, {12,23,45,54,32,54}, {1,2,3,4,5,6,7}, {8,9,10,11,12,13,14,15} Please suggest how do this using foreach function get output like this,  "length of array 1 is 3" "length of array 2 is 4" "length of array 3 is 6" "length of array 4 is 7" "length of array 5 is 8"

Hi all, we've been confronted to a strange case. For a better understanding we've reproduced the behavior in a expression rule : if({ 1 } = 1, { 2, 3, 4 }, {}) returns 2. Obviously, comparing a list with an integer is the error here. But, then, the result should be either the empty list or null or an error message. For more fun, you can test : if({true, false, true},{2,4,6},{3,5,7}) In our mind, a type error should be returned. Regards.

Hi Everyone, I have a requirement where i can reuse local variable array. For Example a!localvariable( local!iterations:{1,2,3}, local!value, a!foreach( items:local!iterations, expression{ append( local!value, fv!index )})) The output i need is 1st Iteration 1 2nd Iteration 1 2 3rd Iteration 1 2 3 But the output the code is generating is 1st Iteration 1 2nd Iteration 2 3rd Iteration 3. I thought that local variable should be append with the value and  can use for next iteration but it is initializing every time with null value rather than appendvalue. Could you please help me to get the output i need Thanks In Advance!!!

  this is my cdt  i dont know how can i delete a username for the usernames field  in the db.

Hi Everyone, I have two interfaces, interface 1 and Interface 2. The interface 2 is inside interface 1, interface 1 is having a button which is calling exp rule to call web service to update DB. Now when I click on button the interface 2 is not refreshing latest data. Could you please suggest how to achieve this?

Hi, I want to use the API of JavaScript in Appian, but I dont found a lot of information about it. Anyone has use it or have more details about it? This is the link that I found: https://docs.appian.com/suite/help/22.4/reference-js-api.html#api-reference Thanks in advance and regards.

Hi Everyone, I am quering the data from table and stroing it into local variable. On button click I am refreshing the data using refresh varibale parameter refreshonvariablechange , but the variable gets changed and data is not refreshing. Could you please help me out?

Hi All, Is it possible to read the data in the word document or PDF file, and perform some actions based on that data ? Thanks in advance. Warm Regards Vineeth

Unable to login suddenly (not sure why, the user does not seem to be locked).  Click [Forgot Password] sends a reset link, pressing (immediately) the link fails witn  "Your Link Has Expired" message.  Weird!

i Wanted to add few alerts like after submitting form i need custom alerts and after filling some fields i need to display alerts or info messages.

Hi,  in the grid one row need to populate by default is it possible to do? based on the id.. if the id is in db then populate row automatically else no Thanks  

I am very new to Appian. I just wanted to know that is there any otp related out of the box service available to connect with other messaging services?.

Hi Everyone, I have an primary interface page and in that there are different tabs calling other interfaces. In primary interface page there is a button and on the click of that button all the tabs present in primary interface should be disabled. Can any one please help me how to achieve this?

I have nine different category types for any given main process. The requirement is to create an Excel spreadsheet with each category appearing in its own sheet. What should be the best approach to achieving this? Currently, I am creating an excel for the first category and then using that same excel for the subsequent categories in Export DSE to Excel smart service to add a new sheet via sheet number. But this process is sequential and not efficient enough if each category has a huge amount of data. I attempted to generate Excel for each category and use the merge excel document smart service, but it did not work as I thought it would. Basically, it is dumping all category data onto a single sheet.

Hi Everyone, I have a requirement where i need to disable the button for particular user.

Do we need verify each Data Store every time when we change Data Source in Appian?

There a CDT with number of fields, I'm trying to update one field X as Array. In this case when I try to publish my Datastore it creates a separate table with random table naming and fields to store multiple values of field X. Is there a way we can give our own naming for that table being created in the above case. I have tried downloading the DDL script and try editing table name and field, But that doesn't seems working. Can anyone give me an insight why it's taking the random table name or is there any workaround in the above case ? Thanks in Advance

While creating a drillable chart I have the month value stored as an integer. Like :  Jan =1, Feb =2, How do I create a record filer to display records that are from that month only? Here is chart for reference :

Hi Everyone, I am using the script a!groupsForUser(loggedInUser()) to get list of groups assigned to user but it gives the id along with group and I only want group name. Can anyone please suggest?

I have column chart as shown in image and have made it drillable. How do I filter records to show corresponding months records?