Foundation

a!localVariables( local!startDate: date(ri!year,ri!month,1), local!daysInMonth: daysinmonth(ri!month,ri!year), local!startDateDay: weekday(local!startDate), local!endDateDay: weekday(eomonth(local!startDate,0)), local!days: {"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"}, local!dates: a!forEach( items: enumerate(local!daysInMonth) + 1, expression: local!startDate + fv!item - 1 ), local!datesWithDays: a!forEach( local!dates, { day: local!days[weekday(fv!item)], date: fv!item } ), { a!gridField( label: "Calendar", labelPosition: "ABOVE", data: local!datesWithDays, columns: { a!gridColumn( label: "Sunday", sortField: "sunday", value: if(fv!row.day="Sunday",fv!row.date,"") ), a!gridColumn( label: "Monday", sortField: "monday", value: if(fv!row.day="Monday",fv!row.date,"") ), a!gridColumn( label: &

I am performing a loop process in which I obtain process information using script task `有効なプロセスを取得` and cancel each process one by one using cancel process `プロセスを強制キャンセル`. If the number of script tasks processed exceeds 1000, a process error will occur. What should I do to avoid this error?

Hello everyone,We have a client requirement where we need to export Client and Employee data recieved from document extraction in a PM to an Excel template provided by the client, where client data should be inserted in their respective positions in sheet 1 and the multiple employee data should be inserted accordingly in its desginated cells in sheet 2. Attached are pictures of the Excel template formats for both sheets, as well as the format of the data we are receiving. We tried using the Export Data Store Entity to Excel smart service in the process model, but the results were unsatisfactory. We also used Appian RPA Excel operations, which provided a solution, but it took 25 minutes, which is not viable in all conditions. We are looking for a more efficient solution to export data into Excel. Any tips or assistance would be greatly appreciated.

Hi, I could not find any docs satisfying my requirement .Can anyone help me in designing a grid as below. Name textbox1 textbox2 textbox3 PersonA 10 1 100 PersonB 20 2 100 TOTAL 30 3 200 User will enter values in rows for textbox1, textbox2 and textbox3. Last row should display the total of the values entered in above rows. 

I want to create new entity category and entity types in Case Management Studio. With "Create Entity" action I am able to create entity of type "Submitter" of category "Person", there no option available to create entity of other types. I did not find any feature in Case Management Studio that allows to create new Entity Category and Entity Types.Is there any way to create new Entity Category and Entity Types.

Hi Team, I have a requirement to execute an expression rule by retrieving the rule name from the database. To provide a background on the ask: We have a landing page where tasks from various other applications/line of business is displayed. So every application designer would have to create an expression rule to return their tasks and then plugin to our common or parent expression rule. The parent rule consolidates all the tasks data from various applications and then display it in the grid. But the problem here is, one application might be in DEV phase, one in QA and another in UAT, so during the deployment there is always a problem due to the missing precedents and we have to comment out that rule that's not present in higher env and then uncomment it back. So in order to resolve this the business wanted to save all the rule names pertaining to each application in the DB and dynamically retrieve the rule name from DB and execute it. I understand that we can pass the rule referenc

Hello, I have the following error from web browser interface (NOT MOBILE): "Start process link not displayed because the system is in a degraded (stateless) status" , when a user press on a  a!linkField( links: {a!startProcessLink(.... I saw that there are some problems with it explained here: https://community.appian.com/support/w/kb/1338/kb-1867-start-process-link-not-displayed-because-the-system-is-in-a-degraded-stateless-status-error-when-starting-processes-in-the-appian-for-mobile-devices-app but I don't have a mobile interface is a simple interface exposed as a report in sites. (ps: appian version  used 18.3) Can someone give a clue what can I do?  kind regards, ana

Hi, I am trying to experiment on Video Field and I would like to upload my videos to appian and play them in UI. As I am implementing this, I got stuck as a!webVideo taking URL as source but how can I implement this?

Hi  I have one local variable and it has array of data in that i want one specific column data from each index and need to add those column data for example: local!test: 1. testid=1,testname="qwerty",testtime=9,testcomments="testtest" 2. testid=1,testname="qwerty",testtime=6,testcomments="testtest" 3.testid=1,testname="rest",testtime=1,testcomments="testtest" Now from first index testtime ,secondindex testtime and third index testtime needs to be added and output should be 16 i tried foreach with using index but it didn't worked could you please suggest on this

I have a document download URL from Anaplan system which gives me the document once I hit the URL. There are documents like that which are hosted on that platform. Now, I will be getting those URLs through Integrations.  I want to first copy that document to Amazon S3 bucket and also capture the document related data in Appian DB and then pull the document from Amazon S3 and related data from Appian database and then show in grid. We need to first host the documents from Anaplan to Amazon S3 and then show in Appian from Amazon S3. What are the best possible ways to achieve this. Please explain in detail as I'm completely new to this scenario. Thanks in advance

Hi Champ, I have a OR gateway where we have two conditions . Although both are true, the token is only follwing one path and skipping the other. If I tried to exceute again a script task just before the OR gateway, that time it is follwing the other path. Not sure why this kind of behaviour.

Hi,  How can i configure this can anyone suggest ?

Dear Appian Community, I hope this message finds you well. We are currently facing an issue during the initialization of our context in our Appian environment, and we would greatly appreciate your assistance in resolving it. The error message we are encountering is as follows: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'smartServiceBridgeRegistry' defined in class path resource [com/appiancorp/expr/server/reaction/ReactionSpringConfig.class]: Unsatisfied dependency expressed through method 'smartServiceBridgeRegistry' parameter 1; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'reactionFunctionProvider' defined in class path resource [com/appiancorp/expr/server/reaction/ReactionSpringConfig.class]: Unsatisfied dependency expressed through method 'reactionFunctionProvider' parameter 0; nested exception is org.springframework.beans.fa

Hi, Can someone tell is there any issue with my code here.. Im getting null value when I index as below. I get output of local!orionData as a dictionary(List of Variant). a!localVariables( local!orionData: a!forEach( items: index( { 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country'( 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{6c137b66-e39e-49a8-b443-3728d8ccd6a4}id': 20817, 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{d38471f1-b8d4-4a37-8bee-0f24c7dd7508}country': "Australia", 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{6ebd94a9-cdde-4846-b29c-4c833d6e80c3}requestId': 7757 ), 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country'( 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{6c1

Hi All, I have a situation where I work on cases based on process model approach i.e. Assignment in PM itself. Each case goes through 3 levels of approval from associate to manager, to senior manager. I have a master process which triggers when a associate "Smith" starts working on a case, this particular associate will be the assignee for the associate task. Once Smith submits this case it goes to all the managers queue and once they accept the task and submit the case it goes to senior managers queue and once they accept the task and submit the case it comes back to Smith who will close the case finally. Now let's say we want to change the associate Smith to Alex (Not through reassignment but through another process model). We have to check active process instance for this case and get the process variable that holds the associate name and change that process variable value to Alex. Is it even possible to modify the process variable of a active process instance through

How to check whether Process model archived or Unarchived.

In a grid we using a related action field with the list of related action in MENU style, so the label for the menu is "ACTION" by default it is not configurable. when the user change the language to Espanol it becomes "ACCIONS" is there anyways to prevent this.

Hi community members, So the requirement is: When business user using the site, one of the interface has the two column layout, left sub-interface showing the uploaded document, right sub-interface is some summary info. The user want to able to adjust the size for the two sub interfaces. For example, there should a line between left sub-interface and right sub-interface, when user drag the line to right, the left sub-interface occupies more area of the screen and the right sub-interface occupies less area. I have did some research and it seems Appian doesn't support this feature. Please give some advice if I missed some thing. Thanks.

Hi, Is there any to get any cdt's reference by its name like we have getrulereferencebyname function? eval() function does the trick but as its internal function and not recommended, i will avoid it. Thanks

Hello everyone, I am getting this error.  The connected system data source does not exist or you have insufficient permissions to perform the requested operation. I have already followed below steps: 1. Tested connection system - working fine. 2. Executed stored procedure - Working fine Please suggest. Thanks

hi I would like to ask a question. What is the disadvantages of query database smart servie.Which point is better than record type? Is there anything better than record type? Thanks

Hi, Sometimes on UI getting the below error:Expression evaluation error [evaluation ID = 19742:9c777] in rule 'Test_Rule' at function a!dropdownField [line 314]: An error occurred while executing a save: java.lang.ClassCastException: com.appiancorp.core.expr.portable.Value cannot be cast to com.appiancorp.core.data.Variant Please provide some guidance on the above error to fix. Regards,Sandeep

Hi,  How can I achieve the below user experience. Like layouts, fields ..etc. Font color can be blank. Thank you in advance.

Here after the last XOR gate i have a condition like if the condition is true then go to the third node from left which is a UIT.  Here also I am doing the assignment of the UIT to the process initator so that the form will open immediately also doing the enabling the activity chaining ,but it is not happening as expected it is getting stuck here only like the image below. Can anyone tell me what I am missing here ? Thanks In Advance !

we have to databases 1. IRM - in this we have two tables 2. CRP - to this database we are replicated those tables  but when i try to create cdt for those synonym tables in CRP it's not showing in the suggestion  how can we create cdt in CRP