Foundation

Hi All, Is there any way to avoid multiple users triggering same related action if it is having start form? Thanks in Advance!

rule!PRO_qrtGap( isActive: true, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 2000))for now i kept batch size 2000 .Pls let me know how to fetch first 500  , den 501 to 1000 etc... 

Hi Team, I have a requirement of converting time in seconds to days, hours, minutes and seconds. I am using function intervalds() to do the same but I find when I give time (in seconds) for 30 days then the function does not return me the correct value. My required format is ddd:hh:mm:ss Eg : I tried : intervalds(0,0,2592000) and in response I got : -19::17:02:47.296 (Interval (Day to Second)). I am using appian version 22.2. Can someone help me in fixing the above and suggest me if we have any OOTB functions to do the same. Any help is appreciated. Thanks in advance.

I can't access my account,this appears...why? help...!!!

Hi Everyone, I have a requirement of uploading an excel which contains around 50k records. Currently , we are using plugin to extract data from file to DB which is having automatic batch size. But, CPU utilization and heap memory usage is too high which is causing environment to break down sometimes. I came across Read Excel File Paging Function , But even with this function writing to DB had much complexity of mapping and all. Any other way that we can acheive this using other plugins or anything?

Hello team, is there any best practice on how to auto-release a task which was accepted by somebody from a specific group after some time, lets say 1 hour. In my case i have a group called "Processors" which contains approx 50 users. When a task is assigned to this group the users accept a task a work on them. I want to ensure that when somebody from the group accept a task but not complete it in 1 hour it will be autoreleased and reassign back to the whole group so somebody else can take care of it. Thanks

I got 502 Bad Gateway during opening my account How it will be resolved

Hello everyone. I need help. Am working on a process model for a MILESTONE (BAR) PATTERN interface. When I lunch "Start Process for Debugging", the MILESTONE form load for me to input data. After inputting data, I click next and the next step load until I get to the final step, and I click the submit but nothing happens when I click the submit button. The submit button will not submit the form. Thank you for your assistance. a!columnsLayout( columns: { a!columnLayout( contents: { a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Back", value: local!currentMilestoneBarStep - 1, saveInto: local!currentMilestoneBarStep, style: "NORMAL", showWhen: local!currentMilestoneBarStep > 1 ), a!buttonWidget( label: cons!GCO_TEXT_VALUE_CANCEL, style: if( local!currentMilestoneBarStep = 1, "NORMAL", "LINK" ) ) }, align: "START" ) } ), a!columnLayout( contents: { a!buttonArrayLayout( buttons: a!buttonWidget( label: if( local!currentM

Hello there, I have a Upload field where user uploads 50 rows of 2 columns data from/csv onto form. I have to read all those and display the data in editable grid before submission. To achieve this i have used submitUploadedFiles function with empty process model to start on its button click. Even though data displayed on Interface object correctly, throwing error on front end. Please help me if i did something wrong. Added code snippet for upload and button a!columnsLayout( columns: { a!columnLayout( contents: a!fileUploadField( instructions: "NOTE: CSV file size cannot exceed 50 rows and should only include tickers and weights", target: cons!SRT_FOLDER_UPLOAD_CSV, maxSelections: 1, value: ri!document1, saveInto: ri!document1 ) ), a!columnLayout( contents: a!buttonArrayLayout( buttons: a!butt

Hi, me and my friend have an Appian Community Edition site where we both can access the Administration console, Appian Designer, etc.  I wanted to work with my friend on the application that is being built in his Appian Site currently. How do we both get access to the application and collaborate on it together? The goal is for both to work on the same application so as to make changes to it simultaneously from two different devices (Two different Appian accounts in this instance). Any help is appreciated

Hi ,  I have a requirement to generate PDF File and pass some value from outside , when i am using .PDF File as template i am not getting ###value### replace with option how can i resolve this ?

Hi Community, is there a way to display some text other than the default text in the document viewer ? If there isn't, is there any other component or plugin to do the same ? Thanks.

User will complete one task namely task A today and the next task named task B should be created only at 5AM EST the next day. Until 5AM EST, the process has to be in waiting stage. Task A can be completed at any time the previous day. How to achieve this?Thanks in advance

Hi All, I am getting around 2000 ids in one local and then passing that ids to one of column in queryfilter using IN operator. But when i test the rule I get this error as: An error occurred while retrieving the data.  So we split the ids in batches by taking 1000 ids in a set and then pass these id to queryfilter through looping. But still it failed with above error. We have already optimized the view also and same query when we run in DB side it took just 0.170sec to bring the data. But same is not working in Appian queryentity. Can anyone please suggest what could be the reason behind this and what all steps we can try to get this working.  Thanks in Advance..

Code consists of 20 local variable with same rule being called 8 times.

We have validation use case. There's a form contains many input fields, if any field value is missing, when click submit button, the page should scroll to first missing value field, make this field on the top page. Is there any component support such feature? How to do that? Thanks

Hi, I'm trying to read a cell value using function excelreadcellsbyname but i'm getting below error when trying to read a cell value.  can anyone please  help in fixing this issue input : excelreadcellsbyname(640958, { 2 }, { "F9" }), output : Expression evaluation error at function 'excelreadcellsbynumber': The column Value of long (+ve) position doesn't exist in table INVFI

I have to click on a Button "Accept" which is already inside another button (ACTIONS) in a grid. Can u help how to do that. Many thanks

i am getting data from external system which is being displayed on UI(example: 2342;34324;3441), i want to export this data by clicking on button in the form of CSV. please suggest the right steps. Thanks in advance.

Hi everyone, i've created a series of post and get api web into my dev environment application and they're still working. When i've exported the application and inported in the test environment the api key and the same associate service account are still present, but when i change the url in the prompt request to activate the api web it doesn't work, give me the error "autentification fail, check out the credential and try it", but the credential are the same. In the dev environment there's no problem. Why is this happen?  Thank you all

I've configured User Input Task in a process where I've used an Interface in which I'm using StartProcess smart service to invoke a process, Please find the code snippet below: a!buttonWidget( label: "Approve1", saveInto: { a!startProcess( processModel: cons!PA_ProcessConstant(), processParameters: { currentWorkstep: local!currentWorkstep, temp: "Test Param", workCount: local!workstepCount, worksteps: local!worksteps }, onSuccess: a!save( local!outPut, "Process started successfully" ), onError: a!save(local!outPut, "Process failed to start") ) }, submit: true, style: "PRIMARY", showWhen: { if(ri!workstepcount = 0, false, true) } ) The above code is resulting in the error as shown below:  If I will comment the saveInto parameter of buttonWidget from the above code snippet the interface works fine. Please let me know If there is any issue in the code.

Hi everyone, I would like to use the "write to record type" activity in a process model to be able to update the fields of a record. I set up the process as follows with the following variables and settings for the write node, but it always gives me the same error (attached in the figure). How to configure this node correctly? Additional question: If you write to the record like this, do you also update the underlying data model table that the record is based on? Thanks all in advance.

How do you change the dimensions of multiple dropdown field?

Hi all, Does someone has any clue why the "Show Objects" button, located on the bottom right corner, isn't working in some specific page? We've a lot of different interfaces/pages and, on some of them, the button doesn't show the highlighted objects in pink color.

I have a gridField where one of the gridColumn is displaying an icon for its value (icon is displayed as a richTextIcon in a richTextDisplayField). In this column, it can either have the icon or not (null). How would I go about configuring the sortField for these values since they're not necessarily field values. I would like to sort so all rows with the icon are at top (or bottom). Thanks