General

Hi, I have data in record type.  I need to implement search field to get result from record type. By using a!queryRecordType it's matching exact content. For example: If we search " How to create record type ". we will get related data like below It is possible to implement similar functionality in Appian 

Hi team, I have requirement such that user can edit single rows and multiple rows as well and while using pm I'm able to edit single and multiple rows as well but there is another requirement such that while editing user  can only edit 2 columns name as: "Electrical Tilt" and "Comment" but while editing electrical tilt on single or multiple row user has to make sure if combination of these 3 columns: "Shared Antenna", "Transmitter", "Antenna PAFX"  are exactly same on any row then electrical tilt of those rows will automatically gets updated  I have mentioned the code of edit UI, please let me know what could be the best approach to follow a!localVariables( local!isShowtoSite, local!siteDetails: rule!SLS_QRY_getSiteSummaryDetails(siteName: ri!siteId), local!data: ri!transmitterDetails, local!updatedData: difference(local!data, ri!transmitterDetails), { a!columnsLayout( columns: { a!c

I found an error in recordtype sync in tomcat log, but what is this error indicating? I'm not sure this is related to my recordtype sync error, in recordtype it only said 'Unable to sync due to a system failure' 2024-11-28 03:00:07,537 [RecordSyncScheduler_Worker-1] ERROR com.appiancorp.record.data.recordloaders.ads.RecordTypeAdsLoadService - Error creating join index for relationship with uuid: com.appian.data.client.AdsUserInputException: APNX-3-1000-06D: Invalid parameter specified to the createJoinIndex function. Attrs must reference valid attributes. Invalid attr ref(s): [e88c8e26-426e-400f-b196-58dad303f85c::318d243c-ab51-430b-8048-872019cb75f9] at jdk.internal.reflect.GeneratedConstructorAccessor521.newInstance(Unknown Source) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500) at java.base/java.lang.reflect.Con

Hi Team, I want to remove Process HQ site option on navigation menu, to my application users. But I see that this Process HQ group is used by all the applications in an env. So what if i want to remove access to users specific to an application? In the membership rule i couldn't restrict the users based on the group they belong. Do we have any alternative to make this work?

Hi Team I want to show case the percentage of data in the Y axis of the column chart field. Eg: If the X axis is have 4 values: A,B,C,D and Y axis is having values for each 1 for A, 2 for B, 3 for C, 4 for D. But other than showing these values is it also possible to showcase the percentage of these values as well? Thanks Harikrishnan

Our team is interested in developing applications using the appian platform and exploring options to publish them on the Appian App Market. Could anyone provide with more information on the partner plan available that align with our requirements? Specifically, we are looking for option that allows us to: 1) Build applications on the Appian platform using its low-code/no-code capabilities.2) To publish applications on the Appian App Market. Any information or guidance will be great help. Thank you in advance!

Hi All, Through Integration I am fetching the data from external system and storing it into my system. But it also stores duplicate records which already exists into my system. How should I prevent this, if I compare each row with existing data it would be time consuming. Please suggest.

Hi , How to remove unwanted characters from text ?  I get data from excel where its having char(9), char(160) sometimes different char(x) which none can expect example: \tHello ( In Appian value : fn!char(9)Hello ) I want only Hello from the value. To use stripwith, char(160), char(10) etc.. would come in value which I can't expect How can I achieve only wanted text or How can I remove those unwanted characters ?

Hi everyone, Please help check whether I'm doing anything wrong in below code. I'm having an editable grid with data source is a data subset local variable. In gridRowLayout I already provided the id for identifying, and save the selected ID into a blank local variable. But when I select each row, it's value is not stored into my local variable. I also tried with fv!index but that did not work either.  Below is the data subset local variable. I indexed into it's data.fileId field. 

Hi Team, Iam Learning New by picking up Random Task for Devlopment. and while devloping Calendar Iam Facing Issue With the Month Dec and Year 2024.  Could you please help me in understand me and updated the code if i make any mistake. even after 31 Dec i was able to select the card   a!localVariables( local!holidayslist: todate(text("12/25/2024", "mm/dd/yyyy")), local!select: {}, local!monthnames: { "JANUARY", "FEBRUARY", "MARCH", "APRIL", "MAY", "JUNE", "JULY", "AUGUST", "SEPTEMBER", "OCTOBER", "NOVEMBER", "DECEMBER" }, local!month: month(today()), local!year: year(today()), local!week: { "SUN", "MON", "TUE", "WED", "THU", "FRI", "SAT" }, local!blank: a!forEach( items: enumerate( weekday(date(local!year, local!month, 1)) - 1 ), expression: " " ), local!dates: append( local!blank, enumerate(daysinmonth(local!month, local!year)) + 1 ), local!se

a!localVariables( local!holidayslist: todate(text("12/25/2024", "mm/dd/yyyy")), local!select: {}, local!monthnames: { "JANUARY", "FEBRUARY", "MARCH", "APRIL", "MAY", "JUNE", "JULY", "AUGUST", "SEPTEMBER", "OCTOBER", "NOVEMBER", "DECEMBER" }, local!month: month(today()), local!year: year(today()), local!week: { "SUN", "MON", "TUE", "WED", "THU", "FRI", "SAT" }, local!blank: a!forEach( items: enumerate( weekday(date(local!year, local!month, 1)) - 1 ), expression: " " ), local!dates: append( local!blank, enumerate(daysinmonth(local!month, local!year)) + 1 ), local!selectedDate: {}, local!holidays: { if( a!isNullOrEmpty(local!holidayslist), {}, text(local!holidayslist, "DD") ) }, local!currentMonth: { a!forEach( items: local!selectedDate, expression: if( tointeger(text(fv!item, "MM")) = local!month, t

Hi Team, currently working  to display a calendar to select some dates. so all months dates years are working fine but DEC Month is showing extra cards to select. I am providing my Devlopment need Support in understanding and Fixed code. a!localVariables( local!holidayslist: todate(text("12/25/2024", "mm/dd/yyyy")), local!select: {}, local!monthnames: { "JANUARY", "FEBRUARY", "MARCH", "APRIL", "MAY", "JUNE", "JULY", "AUGUST", "SEPTEMBER", "OCTOBER", "NOVEMBER", "DECEMBER" }, local!month: month(today()), local!year: year(today()), local!week: { "SUN", "MON", "TUE", "WED", "THU", "FRI", "SAT" }, local!blank: a!forEach( items: enumerate( weekday(date(local!year, local!month, 1)) - 1 ), expression: " " ), local!dates: append( local!blank, enumerate(daysinmonth(local!month, local!year)) + 1 ), local!selectedDate: {}, local!holidays: { if( a!isNull

Hi team,  New here to Appian and i am trying to develop a calendar to select Multiple dates and it is working fine my problem is the calendar shows the extra cards in DEC 2024 month. the cards are selectable. i want to know the reason where my code fails and need support in fixing this. a!localVariables( local!holidayslist: todate(text("12/25/2024", "mm/dd/yyyy")), local!select: {}, local!monthnames: { "JANUARY", "FEBRUARY", "MARCH", "APRIL", "MAY", "JUNE", "JULY", "AUGUST", "SEPTEMBER", "OCTOBER", "NOVEMBER", "DECEMBER" }, local!month: month(today()), local!year: year(today()), local!week: { "SUN", "MON", "TUE", "WED", "THU", "FRI", "SAT" }, local!blank: a!forEach( items: enumerate( weekday(date(local!year, local!month, 1)) - 1 ), expression: " " ), local!dates: append( local!blank, enumerate(daysinmonth(local!month, local!year)) + 1 ), local!selectedDat

Can somebody tell me if both are the same, if ACD101 is the newest or they are for different levels?  Thanks

I have a variable that contain list of items, items are ;- year , category , value 2024, cap internal , 20 2024, cap external, 60 2024, cap material, 50 2025, exp internal , 20 2025, exp external , 30 2025, exp material , 40 I want to sort this like :-  year , category , value 2024, cap external, 60 2024, cap material, 50 2024, cap internal , 20 2025, exp external , 30 2025, exp material , 40 2025, exp internal , 20

Hi, I am preparing Certified Associate Developer(ACD101) Exam from last month, The materials which is available on the community learning path is sufficient to pass (73%) the exam or I need a hands-on experience which I learned? Also is 1 month of preparation is sufficient to take the test? As I am confused, please suggest your valuable comment on this,   Thanks in advance. Regards, G Udhayan 

How can I update a user attribute with an empty value? The "null" value is being passed from the interface but then those attributes with the null value in the pv do not get updated in the user profile.docs.appian.com/.../Update_User_Profile_Smart_Service.html

There are 300+ Constant in  my application but i need to filter the Env specific Constant . How can i do that 

HI everyone , Is it safe to remove the unnecessary heap dump files from the bin folder without stopping the services? If I delete these files, will it cause any issues? We've resolved the heap memory problem, and the application is functioning properly, but I need to clean up the storage. Thanks, Udhaya

On the Landing Page, I have a Navigation menu on the left and Record List on the right, When I click on the Loan Id hyperlink on one of the Record, it takes me to the Summary Page for that record clicked. Issue I am having is, the Summary page is taking up full page and overwriting the Navigation pane on the left hand. Please see 2 screenshots I have attached. How do I get the Summary page to be restricted to the right side of the Interface section and not go over the Navigation pane on the left?

a!localVariables( local!map1: {    a!map(Id: "Map 1", key1: "A", key2: "C", key3: "C"),    a!map(Id: "Map 2", key1: "C", key2: "A"),    a!map(Id: "Map 3", key1: "C", key2: "B", key3: "C") }, local!map2: a!map(     Key1: "ky1",      Key2: "ky2",    Key3: "ky3" /*This list can be very long e.g. Key4: "ky4", Key5: "ky5" etc.*/ ), /*code here*/ /*desired output starts - swap the keys based on mappings in map2 */ /* {   a!map(Id: "Map 1" , ky1: "A", ky2: "C" , ky3:"C"),   a!map(Id: "Map 2" , ky1: "C", ky2: "A"),   a!map(Id: "Map 3" , ky1: "C", ky2: "B" , ky3:"C"), } */ /*desired output ends*/ /*Is it possible ?*

I have an expression rule will return 2 types of record type - Case - Error depends on if there is any error occur during the expression rule process so when I get the result from the expression rule, I do need to know what type is the returned value, how can I achieve that? I tried to use typeof(), but it does not work. I am wondering if I need to use type!, but I do not know how to write a valid reference using type!

I've got a requirement that needs a expandable readonly grid, I saw Expand/Collapse Rows in a Tree Grid - Appian 24.2 in other post but this is a gridLayout which seems can't be paged But I want the grid to be paged and expandable, the collapsed rows should be just same to the main row that can be selected and has recordactions in every row How can I implement this

  I have an Interface with Cancel and Submit button. This interface also has Rule Inputs defined for Cancel and Submit. I also had defined a process model for this Interface. I have kept the process model screenshot as well to this. When I am testing the Process Model, program always goes to "Import Excel to Database node", this happens even when I hit Cancel button the Interface. I feel the button clicks are not sending/capturing the correct values onto process model. Can you please let me what am I doing wrong here?

My project exists as three environments hosted on three separate URLs with three separate app names (dev, test and production respectively).  I want to make changes to my interfaces that only render in certain environments (mainly dev) so that they don't interfere with the client's UI experience.  I was wondering if there was some sort of metadata or variable that I could use to identify them for conditional logic.  I know pp! variables do something similar for processes.  Also, using string fragments from the unique parts of the URLs might work too, but I wasn't sure what methods are the current gold standard.