General

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?

Hi Everyone, I am saving value of loggedinuser() function into cloud mysql db, but everytime it saves the "Administrator" instead of the my username. I test this function in expression rule where it gives my username. Can anyone please help me out?

If isReachable throws an IOException in Java, what is the right step to do and why? The application, I believe, should halt the process and output the system message: the host is not accessible. Because isReachable throws an IOException, the host cannot be reached. But I'm not sure what the solution is. I would be grateful if you could assist me. Thank you very much

Hello Appian People, Do you have any idea how to to implement this case: So for example variable arr must be the same length value of variable value: local!arr:{1,2,3} local!value: {"a","b","c"} But if incase of variable arr is not equal value size of variable value. It needs to add null value on the local!arr  , example: local!arr:{1} local!value: {"a","b","c"} local arr expected ouput must be : local!arr{1,null,null} another case example: local!arr:{1,2} local!value: {"a","b","c","d"} local arr expected ouput must be : local!arr{1,2,null,null}

Hi All, I have to generate PDF document for record summary data which contains mutiple grids and sections. I haven't done this before.So could anyone please help me. Thanks in Advance.

hii all, i have a requriment of placing a NOTIFY button  in interface , once a new request is entered into a approval interface he has to take an action , once he took an action he needs to notify the remaining users by sending a mail by clicking a NOTIFY BUTTON , based on the request status we should sent an email by clicking NOTIFY USER BUTTON with request id , its like a push notification by sending a mail, based on request status we will sent different mails. thanks in advance 

Hi all.. New to Appian here. I've got a general question regarding applications in Appian. What is the use of an application apart from its ability to group related design objects? Also I'm able to refer rules from a different application in current application. What are the boundaries and best practices of an application? Can there be circular references between applications and What are it's impacts?

Hello Appian people, local!arr:{1,2,null,3,null} loca!val:{1,2,3,4,5} I have a function that gets null indexes in an array local!arr then used that indexes to remove the value from the local!val array. and also remove the value found in the local!arr.  /*Get null indices */ local!getNullIndices: a!forEach( items: local!arr, expression: if(isnull(fv!item), fv!index, null()) ), local!removeNullIndices: remove( local!getNullIndices, where( a!forEach( items: local!getNullIndices, expression: if(a!isNullOrEmpty(fv!item), true, false) ) ) ), /* Removed found null in data item array */ local!data: remove( local!arr, where( a!forEach( items: local!arr, expression: if(a!isNullOrEmpty(fv!item), true, false) ) ) ), local!updatedVal:remove( loca!val, removeNullIndices ) expected value for updatedVal is: {1,2,4} Do you have any ideas to optimize this implementation? Thank you

I have a document generated by plugin called DOCX From Dynamic Template that I used a list of images in it, it works very good but when I try to convert it to PDF using pdf from docx it works only if there's only 2  images, when there's 3 images the document generates 2 pages instead of 1 page, the plugin won't convert it to pdf. [View:/cfs-file/__key/communityserver-discussions-components-files/11/new-doc-_2800_11_2900_.docx:320:240] Attached file of the document.

Hi Team, When i open my application Record Type "AX Vehicle", clicking on View record list. Till here everything is going fine. But in View record list when i am clicking on any Vehcile Vin to view vehcile details like Summary getting below error. Error Evaluating UI ExpressionExpression evaluation error [evaluation ID = UKXX9] at function rule!AX_VehicleSummary [line 7]: Could not cast from RecordType to AX Vehicle. Details: CastInvalid (APNX-1-4198-000) Note: News and Related action is fine, only In Summery error is coming. Could anyone please help.I am just beginner here. 

As part of my organisation the exam fee should be 100$, but it is reflecting as 200$.  Can someone help me with this. I have logged in with the company Id. Profile is also updated with partner network.

I have a requirement where I have to process, filter and Validate 35-40 MB  data in excel with 100+ columns and if validation is successful then Import the data into Landing table. What could be the best way to design this. We don't have any control on excel to create multiple excel files and upload. It has to be done with all. We are already managing 2K rows with process & validate but Customer wants Appian to do filtering and then process. But After filtering we need to do validation on resultant data after filter and inform user via popup or message in UI.

Hi, Is there a way to show the "user login history" on the interface screen  used by end-users?  I do know that system admin can monitor the "Current User Activity" from [Appian Administration Console > MONITORING > Current User Activity]. But, the needed function is to show the "history of user login". Thank you

Hello Team, Please, can you confirm if the service_manager.conf file generated in one server will be copied across other server nodes in a load balance setup as highlighted here --> https://docs.appian.com/suite/help/22.3/High_Availability_and_Distributed_Installations.html. The documentation states : As part of a distributed installation, it is a requirement to copy the service_manager.conf file located in /services/conf/ across all machines in the distributed environment, for it is necessary to enable authorized connections to the service manager and the engines across machines. Since running the password script will generate unique password for each server; will a service_manager.conf file generated on one server work for other servers in the load balance setup? Also, will I run the password script on all servers in the load balance setup? Your prompt response will be highly appreciated. Thanks

It's a new year, and your last chance to take the Appian Developer Productivity Survey! Please consider taking 5 minutes to tell Appian product managers which feature are speeding you up, which areas of the platform are still tripping you up, and more! 

I am creating a bar chart with two measures: GST and TotalBill. If I use normal stacking both the values get on top of each other. like if GST = 20 and TotalBill = 100  then the bar length will be 120 as shown in the attached image. But I want the bar length to be 100 and GST measure inside that.