General

HI All, Example -- I am forty-five years old. from above text i need to get 45 in integer form. How to achieve this? Thanks, Ganesh. 

I am currently reviewing the Appian pricing structure and plans, and I’m a bit confused about the difference between "Platform User" and "Application User". Could someone please clarify the difference between these two types of users in terms of access and entitlements?

There is a requirement to trigger a scheduler at 2 PM , 10 PM and 6 AM. When scheduler will trigger, it will invoke an API by passing the last execution time to fetch set of data between last execution time to current time. Say for an example, if scheduler runs at 2 PM, then it will pass 6AM as parameter to the API so API can return data between  6AM to current time (i.e. 2PM )interval. any suggestion how to implement this following the OOB configuration? TIA

We work with several clients. Some want their environments in spanish or portuguese, so most of our envs are in english for our dev team and the client's requested language.A LOT of time is spent with naming our process nodes twice: once in english when we develop, and the other in whatever other lenguage the client wants. The only reason we do this is because Appian won't let us deploy packages if even one node in a process does not have the other language node name.This really hinders the devexp for something no one will see. Is there any configuration to allow for English to be a fallback language for the process? Lets say the process has no "Spanish (MX)" names attached to the nodes. In that case, appian would automatically fall back to whatever other name the developer added to the node (in my case "English") 

Hi Community,   I am working on a POC where a third-party system interacts with my Appian Web API. The setup involves the following: 1. The third-party system is configured to call my API endpoint: https ://appianCloud.com/suite/webapi/endpoint1 for a GET operation to retrieve data using query parameters. 2. In subsequent calls, the system appends /action or /response to the same endpoint URL and performs a POST operation to modify the data for the same record.   Given this requirement, I would like to know: • Is it possible to handle this type of scenario within a single Appian Web API object? • If not, are there any known workarounds or best practices to manage such dynamic operation variations?   Looking forward to your insights. Thank you in advance!

We got the above error from production. We are not able to replicate the error in lower environment. Can anyone tell what is the root cause of this issue?

Hello! We are in need of a Slovenian locale/translation for appian and I'm wondering if any of you have any suggestions as to how would we be able to get that specific locale? Is there any way to do a custom translation and import it into appian?  Thanks, Jan

Even i gone through the documentation i cant get the exact difference plz can anyone explain in easy and simple words 

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