Foundation

Hi, I need to find out if a given date is in the last week of the month.  For example 27th of March 2023 is in the last week of the March month.  How can I achieve this?  Please give me the suggestions. Thanks and Regards, Brinda Sateesh

Hello everyone,We are trying to make sure SAML users, if idle, logout after 60 minutes. But for some reason the timeout is set to 20  minutes. After going through the documentation I have seen Admin console> Appian >session time out is suppose to fix it but it doesn't seem to work in my case. Any idea where to start?

Hi, I have a process model where I am using writeToDataStoreEntity smart service to save the data into a database. I am using an interface in the start node.  If I hit a submit button, system is flashing "Action Completed" message automatically. Whereas when I implement same functionality in the SaveInto and a!writeToDataStoreEntity , system is not returning any such message after hitting a "Submit" button even though data getting saved. Can someone advise me how to show such a message "Action Completed" after submit button clicked.

I have a scenerio.The below mentioned example rule should repat based on the local variable local!a each input. localvariablesa( local!a: {"A","B","C"}, local!b : {"X","Y","Z"}, a!forEach(items: local!b, expression : rule!getTestData(input1 : ri!employee, input2 : local!a[1])[fvIndex], rule!getTestData(input1 : ri!employee, input2 : local!a[2])[fvIndex], . . . . rule!getTestData(input1 : ri!employee, input2 : local!a[n])[fvIndex], ) )

In the main interface we have a toggle icon, We the default value for this is null. When user clicked on that we are setting a local variable value as true. Below this toggle icon we have a link, When user clicked on that link it will initiate a process model using a!startprocesslink smart service. That process model has interface rule in the startform, when user perform some action on that screen and submit the form he will again land on the main interface rule. Now again this toggle value going back to the default value null. But, the requirement is to have that toggle value as true after user submit the form. Please suggest your thoughts on how to achieve this. Any help is greatly appreciated. I have attached screenshots, please refer them for more information. [View:/cfs-file/__key/communityserver-discussions-components-files/13/Issue_5F00_details.docx:320:240]

Hi, I have a scheduled process that executes multiple SQL scripts.The final of these scripts recreates triggers dropped in the first script. Since triggers can't be created in a Stored Procedure; I am unable to use the Execute Stored Procedure smart service and, due to the scripts complexity, use the Query Database smart service. Is there another way this can be executed from the process model? Thanks

I'm trying to  extract  a  big amount of question from a  PDF file that has around 1000 pages  and the section  where we find all those questions. The program is doing it  we can run  the process an everiything is fine but suddenly  the appian server  shows the 503  error   even though we are not running the process i split the pdf  in  batches of 30 pages  every time a 30 page batch   is evalueated and the  questions are extracted we save the   questions found in this  variables and this sub process die and  go  to the main process  and do the same  thing till  we get to  have all the questions and sections   the  time for this process is about 10 minutes in doing all of this operations. how can we minimize the high load of the site ?  the Appian team told us that the aplication server was killed by their automation. After

In a pipeline : as an input I have a parquet file I'd like to do row by row of the parquet file (foreach ?): make a call to a soap xml api according to result call : = if ok store the result (xml file) in a blob container. = if not ok store the result in an azure storage table. I've already done such a thing with an azure webjob would it be makable (rather simply) with azure synapse analytics ?

I have an expense CDT . It has fields like base charges, fuel charges, taxes. I have a pie chart and on each slice of a pie i need to display the sum of base charges, fuel charges and taxes for a vehicle . I am unable to use secondary grouping. Kindly please help.

We have a n export scheduled to ran daily for billing , when Microsoft has outages and task fail we do not get any alert for the failed export job and we cannot even see event logs. How can we create alert for any failed export or job not received in the billing export container We haven't tried anything as yet , since MIcrosoft Engineers couldn't help us .

Hello Community, Does anyone knows how to read data from a docx file in the same way we can do for PDF files? I read that is possible to convert docx files to pdf and maybe accomplish this, but not sure. Please let me know if you have some ideas how to accomplish this. Thank you

I'm facing two issues:1. Warning is coming in process instance - Some referenced items could not be found. Please check the model and correct any problems.2. Action Complete banner flashes out..

I was trying out this plugin called "Timer Component". It basically provides us with a stopwatch functionality. We can also stop it automatically at some given time interval. I just tried to create a functionality where this plugin can be used to refresh a variable automatically in custom time intervals ( also less than 30 sec). Is it a good way to do it? a!localVariables( local!total: 50, local!bool: false, local!refreshAfter: 5, { stopWatchField( /*label: "Stopwatch Timer",*/ labelPosition: "ABOVE", validations: {}, height: "AUTO", action: "START", size: null, align: null, expiredMessage: null, color: "#FFF", style: null, timerDirection: null, enableReverseTimer: null, reverseTimerColor: null, secondsValue: local!total, secondsSaveInto: { a!save( local!bool, not(local!bool) ), a!save( local!total, local!total-l

Hi, I would like to send error details to an email DL when there is an issue with process model functionality. The below option is allowing me to create a reference to an Appian group and specify at this place. But, I would like to provide an email DL so that all the people who are the part of the email DL should receive the email with error details.

Hi, I have a big user interface form where I am using multiple controls. Now when I try to submit a form data by clicking "Submit" button it is taking few seconds to complete the submission and it between it is allowing use to click on different form elements and it is creating an issue. So, when the user clicks on the "Submit" button, I would like to show a rotate/progress bar so that user can't click on any other elements of the form. Is this possible in Appian 22.4? Can someone advise please. Thanks in advance.

Hi, is it possible to receive multiple messages on one Receive Message Event? I need to use Receive Message Event to stop the process flow until all the fields of multiple entities are populated, so I have a Send Message Event on each asynch subprocess that sends a message to my main one that the fields have been populated. There is also an Expression Condition on Receive Message Event that checks if all entities have populated values. If it's possible to receive multiple messages, does the condition get validated each time it receives a message? Thanks!

Hi, I have text field in an interface and I need to trim the Leading and trailing spaces for the value if there any. So I have used trim() as in below code. I tested by giving some sample text with leading and trailing spaces, trim() has removed all the trailing and leading spaces in the interface. But when I checked the CDT to see how it stored, the spaces are still there and it is carrying forward the same value to next screens also. Can anyone please help me in resolving this.    a!textField( label: "Bundled Submission Description", labelPosition: "ADJACENT", value: trim(ri!bundle.submissionDesc_txt), saveInto: ri!bundle.submissionDesc_txt, required: true, validations: rule!RGRACSLBL_FN_getTextLengthValidationMessage( input_txt: index( ri!bundle, "submissionDesc_txt", {

Hello: I am trying to learn interfaces to create a single-page application.  I am using the Navigation (subsection) as the starting component (first image).  However, I would like to customize the interface so that when the cursor is hovering over an option, the text and background color changes.  As per the current configuration, the option (when a cursor is hovering) has a border but the text color is blue (option: Expenses in image one).  I would like to make it seem like the user-interface used in the Appian documentation page (second image).  Cursor is hovering on MODEL RECORD DATA.  I assume the collapsible feature is implemented using a!section.  Two questions: 1.  Is there an attribute or function that controls the color of the text/background when a cursor hovers?  2.  Is a!cardLayout (other than header/billboardlayout) the only component that provides ability to control the background - noticed that a!

How to set date-time format into : "jul 8 , 2021 9:35 AM" from using Date-time 

i have few doubts can someone clear me the doubts? i want to write the exam for L1 so which exam i have to take? here i found these, but not sure which is exam is for which level if i want to write L1 and L2 exams at a time then, which exams i have to register for and take?

We are searching with a text (example: "xyz pqr") and this input is passed to the integration to call API but API call fails because of the space in the input text/string.Expected outcome: want to encode the input like "xyz%20pqr".Note: Input may have any special characters including or other than spaces.

We are using a cardLayouts as a stack of buttons for actions the user must take before submitting the form.  The cardLayout has a label informing the user the type of action to perform and a status indicator to show the user visually whether the task is complete.  When you click the cardLayout, it displays a subpanel of information is displayed for the user to perform the needed task. Ultimately, we may have 7 – 10 of these cardLayouts stacked on the page.  This design allows users to see only what they want to see when they want to see it.  It also, helps them know when all steps are completed.  We feel that this is a very appealing UI design.   We are facing a challenge meeting WCAG requirements for this design.  Specifically, Criterion 4.1.2 which requires the following: 4.1.2 Name, Role, Value: For all user interface components (including but not limited to: form elements, links and components generated by scripts), the

I need to convert an excel document to the PDF, does anyone know how to do that ? Thanks in advance. 

Hi, We are having a editable grid where the columns are relation, soeid, geid, firstname, lastname. Relation is a dropdown field with the values {employee, contractor, client}. Soeid is a user picker field and the remaining columns are text fields. If user select employee or contractor in the dropdown and he should select soeid then the remaining columns will autopopulate related to the soeid. If user select client then the soeid and geid get disabled(grayed out) and he needs to fill all the other columns. My task is here 1. when the user first select employee and enter a soeid then the other columns will populate. 2. if the user select client again in the dropdown the soeid, geid, firstname, lastname which was already populated  should become blank. How to achieve the above functionality Thanks in advance.

First Create Function To Calculate Sum called : Calculate_Sum a!localVariables( if( ri!monthName null, sum( todecimal(index(ri!months, { ri!monthName }, 0)) ), sum( todecimal(ri!months.jan, 0), todecimal(ri!months.feb, 0), todecimal(ri!months.mar, 0), todecimal(ri!months.apr, 0), todecimal(ri!months.may, 0), todecimal(ri!months.june, 0), todecimal(ri!months.july, 0), todecimal(ri!months.aug, 0), todecimal(ri!months.sep, 0), todecimal(ri!months.oct, 0), todecimal(ri!months.nov, 0), todecimal(ri!months.dec, 0) ) ) ) Now Create Form in Grid to calculate and call the sum function: a!localVariables( local!invalidIncome: ("Please insert valid income value."), local!DuplicateIncome: ( "Duplicate value. Please check and delete if duplicated" ), local!CurrentRow: 0, local!TotalRow: 0, local!monthDetail: a!map( jan: null, feb: null, ma