Foundation

I created two records using two related CDTs which share one to one relationship. But when I am trying to fetch related record into one record. I am getting some other values. Can someone please help?

I am getting the below error when I click view record list on AX Vehicles record list. The Requested Record Type Is Not Available Expression evaluation error [evaluation ID = 6ETIO] at function a!recordList: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!documentImage [line 56]: Could not cast from Rule or Function Reference to Document. Details: CastInvalidCould not cast from Rule or Function Reference to Document. Details: CastInvalid (APNX-1-4198-000)

In sync record smart service ,How can we sync more than 1000 identifiers list of primary key values?

I have a process model that generates a PDF. Is it possible to create a button in an interface that runs the process and then downloads the PDF to the user in one click?

Hi Everyone I have a grid field in which 3 columns are populated by the same DB column and I also want to set same sort Field value for them.Is there any way to set so because when I try it throws an error that Sort Field value must be unique. 

Hi, Whenever I'm trying to enter 271.64 or 2**.65 where (** can be any number) it's getting converted to 2**.64 I'm using below expression for this: a!floatingPointField( label: "Test Decimal Value", value: todecimal(fixed(trunc(ri!value, 2))), saveInto: ri!value) Not sure, if this is an issue from Appian. Can anyone confirm this. Thanks in advance.

I want to use richTextBulletedList with Foreach on CDT type item, but Appian is giving incorrect result. Below is the code & image attached. a!richTextDisplayField( label:"Attachment", value: a!richTextBulletedList( items: if( rule!CMN_PLATTS_CheckNullOrEmpty( ri!attachments ), cons!CMN_PLATTS_TXT_NOT_AVAILABLE, a!forEach( items: ri!attachments, expression: { a!richTextItem( text: " " & index(fv!item, "documentName", null), link: rule!CMN_PLATTS_SEC_AWS_GetDocumentLink( filePath: index(fv!item, "attachment", null), documentDetails: fv!item ), linkStyle: "STANDALONE" )

i need to convert encryptedTextField Value to TEXT values, "I am entering the data in encryptedTextField" while entering value the data is should be encryptedText but in DB it should be in TEXT format so i need to convert the encryptedTextField value to TEXT values, I used type! but it's not working if anyone know about any function can you please help me with it.

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