Discussion Categories

Hi everyone, I hope this is okay to post here! I'm a certified Appian Developer currently looking for new job opportunities and not getting much traction yet. A bit about me: Appian Developer Certified Currently preparing for Senior Developer Certification [3 years] experience with Appian Open to full-time, contract, or remote roles If anyone knows of openings, is hiring, or can refer me to the right people, I would really appreciate it! Feel free to comment or send me a direct message. Thank you in advance

Example -  Validation: Filename cannot contain special characters (for example, / \ ; : " | ? ' < > * ).  Expression evaluation error: Syntax error. Details: Expression evaluation error : Invalid character found in expression: | 

We are using Rich Text plugin(Vuram) in our application and facing multiple issues some of them are - Copy the data in specific format and paste that in the editor. This does not maintain the formatting but disturbs the copied formatting - Generating some extra metadata within HTML tags causing failure in the document generation - Nested list items is not maintained too What are the options we have available to avoid such issues as the data formatting while copy paste or manual is prime requirement with the proper HTML generated by the plugin.

Hi, we are using the function a!sapInvoke to integrate with SAP throught RFC. Weeks ago, the integration worked  and we received the results expected. For development requirements, external system add some parameters and change the lenght of some text fields (from 20 to 25). After those changes, we receive errors on specific fields, but the return message gives a value that doesn't match the one sent. So, we check with external system and the problem is on all fields. For example, if we pass the parameter of the below images, external system receive as key1 the value "ABC/AAA/456789001/20ABC". It seems it takes the first 20th char and then take the others from key2. ICould you help us to understand the nature of the problem, please? Thanks in advance. Regards

I am building POC using a grid plus component, i need help solving below two issues 1. when i try to add custom validations like preparerDueDate<RevieweDueDate it does not validate properly. Even if one row has the validation to true, the message shows on all row for that field. 2. I have a column that cannot be edited when once added, when creating a new record i need the column to be editable. how can i achieve this functionality? Thanks in Advance.

Issue with Dynamic Identifiers in Materialized View Causing Sync Failures We are consuming data from an external view that only returns records where: BPM_PROCESSING_STATUS IS NULL BPM_CASEID IS NULL This external view is built on top of a base table that contains all records. Current Implementation When a case is created in Appian, we update the base table using a Query Database Smart Service, populating: BPM_CASEID BPM_PROCESSING_STATUS (e.g., PENDINGFORAPPROVAL, REFERREDBACK, PROCESSED) Since we do not have access to define a primary key on the source table/view (due to grant restrictions), we: Created a Materialized View on top of the external view Added a synthetic identifier column: SQL 1 ROW_NUMBER() OVER (ORDER BY UNIQUE_ID) AS ID Show more lines Built an Appian Record Type using this materialized view (to leverage record filters, etc.) Created a stored procedure to refresh the materialized view Used: Execute Stored Procedure Smart

Hi, i´m facing a refreshvariable problem, this code call a rule caled rule!slc_obtenerPolizas(idSiniestro: ri!siniestro.idSiniestro) local!refrescarPolizas: false, /*REGLA QUE OBTIENE LAS POLIZAS*/ /*Y COBERTURAS*/ local!polizas: a!refreshVariable( value: rule!SLC_obtenerPolizas(idSiniestro: ri!siniestro.idSiniestro), refreshOnVarChange: local!refrescarPolizas ), rule expression is this:  a!localVariables( local!polizas: rule!SLC_GetObtenerPolizasByDeclaracionID(idSolicitud: ri!idSiniestro).data, local!ramos: a!forEach( items: local!polizas, expression: a!update( fv!item, "ramos", rule!SLC_GetObtenerCoberturaByPolizaID(idPoliza: fv!item.idSiniestroPoliza).data ) ), local!ramos ) which call a two api, we cast json into CDT.  a!localVariables( /* 1. First, configure the integration object to return successfully */ local!integrationResponse: a!refreshVariable( value: rule!CT_SLC_getCoberturaConsultarxPolizaID(

I am building POC using a grid plus component, i need help solving below two issues 1. when i try to add custom validations like preparerDueDate<RevieweDueDate it does not validate properly. Even if one row has the validation to true, the message shows on all row for that field. 2. I have a column that cannot be edited when once added, when creating a new record i need the column to be editable. how can i achieve this functionality? Thanks in Advance.

Hi Team, We have a requirement of querying all processes with an error in our application and send recurring reminder emails to fix that problem (every 5 minutes). Process Report seems to not have such feature. Can anyone please guide on a potential solution here? Thanks!

Hi  In Ui there was user picker field if i choose more than one (max selection is 3 ) and submit request after that in read only the selected users we are showing in summary dashboard there user want first name and last name to be displayed instead user name  Below is the logic i am using to display selected user details in text field a!textField( label: "Requested On Behalf:", labelPosition: "ADJACENT", value: a!forEach( items: a!defaultValue(ri!MDSRequest.requestedonBehalf, {}), expression: if( a!isNullOrEmpty(fv!item), {}, if( a!isNullOrEmpty(touser(fv!item)), {}, user(touser(fv!item), "firstName") & " " & user(touser(fv!item), "lastName") ) ) ), readOnly: true, showWhen: a!isNotNullOrEmpty(ri!MDSRequest.requestedonBehalf) ) } ), If i select two means more than one i am getting below error i selected valid users only still getting this error also before upgrade logic worked after version upgrade i am seeing this c

We have an external supplier portal in Appian where we need to implement MFA to hide sensitive sections on interface until verification is completed within the session. Preference is to avoid app-based authenticators as some suppliers are hesitant to install anything. Has anyone implemented something similar? Looking for suggestions on: Step-up MFA approach for external Appian portal users Conditionally showing/hiding sections based on completed verification App-free options like email OTP or SMS OTP that work well in Appian

We have a requirement for comparison of same record type data and get the difference of the data & columns. We are aware of "CDT Diff Utilities" which does the same operation and gives the expected output. However we are looking for similar way of plugin availability or workaround to achieve the desired functionality. Note: We are not looking for manual comparison of the record fields and the data, as we need to perform the comparison across all record types in the application and it will be become very tedious process to achieve by manual comparison.

I am looking for some guidance on generating large PDF documents in Appian.We have an existing site page that displays more than 13,000 records. As part of an export feature, we retrieve the data, generate XML content, generate a word document and then convert it to PDF (using Advanced Document Templating plugin). Currently, the export process retrieves around 3,000 records. Each record contains several large text fields (around 5 - 6 columns) so the overall amount of content is quite large. The word document is generated successfully and is about 768 KB in size and has approximately 5 million characters. The issue occurs during the word to PDF conversion. The conversion starts, but it appears to consume significant resources and causes the environment to become unavailable.  My questions are: 1. Are there any known character limits for Word to PDF conversion plugin?2. Are there any alternative plugins or approaches that are better suited for large documents? I understand

Hello, I have built a chatbot in appian. I have two objects in my interface. First is a text box, which takes user question. And, the second is a button user clicks to send question to AI bot and get response. Currently, when text box loses focus, a local variable called isProcessing is turned to true(So the user can be shown that processing is occurring). And, when the button-press returns with AI response, the isProcessing is turned to false, and the AI response is shown to user. I want to have it so that when the text box loses focus, the local variable isProcessing is turned to true, as well as data being sent to AI bot. And, then when AI bot returns, the isProcessing is turned to false, and result shown. Is this possible? Thanks for your time.

I am currently preparing for the Appian ACD101 exam and came across a question that I am not completely sure about.Questions: How do you refer to the metadata of a process model object within the process model expressions? For example: the creator, name, or description.A- Process Properties, referred to in process model expressions using the pp! domain. B- Process Variables, referred to in process model expressions using the pv! domain. C- Process Model Properties, referred to in process model expressions using the pm! domain.Which option is correct, and how would you explain the reasoning behind it? I would appreciate any insights from those who have studied this topic or have recently taken the ADC101 exam.

Hi, Is there any way to integrate with Microsoft authenticator app from Appian to get the current One-time password code? Thanks, Sudip

Hi , I am facing an issue in pdf generation. that sometimes  frech and spanish letters getting eliminated from the document generated , letters like à, é. ó. I am using clean fucntion before passing the sentences to do document template.  If I don't use clean the generated document dont even getting saved in the process output even for english templates. Below is smart services I use to get the pdf generated.  This is how it appear in the grid  This is how it looks when printed, Is there any way to fix this.

Hi community, I'm using Advanced Document Templating plugin for a document generation where i have multiple chapters, and in each chapter i have have a conditional statement that if in the passed list are values then show a table else show a text "No data". This a similar structure to the one that i'm using The way that i'm implementing it is like the following in the document.xml Chapter 1

Hi, while querying data using query record type in one specific field (which is an integer type, mostly the values will be 1, 2 or 3) is returning null even the value is present in the database. While using query entity value is returning and in record data preview value is displaying but in the query record type alone it is returning null one time and returning value on clicking test value again. It's a sync record type and there is no sync failure, and no changes were made in database table structure and in CDT. By syncing the record manually this issue is resolved but I want to understand the root cause.Thanks.

Has anyone tried the plugin EML to PDF converter ? How does it work? From my process model it is saying completed by I can not see the completed/ converted file anywhere in the designer 

I am using Community Edition and  following the Appian Developer path. In for Step-By-Step # 5 I encounter a problem with selecting the database for the "Vehicle" Record Type. I followed all the steps1-4 and facing above change in Step 5. Appreciate any help/suggestions 

Hi Everyone, I’m facing an issue while generating a PDF from a dynamically generated Word document. Requirement: Capture multi-line text from an Appian UI Paragraph Field Populate it into a DOCX template using DOCX From Dynamic Template Convert the generated DOCX to PDF using PDF From DOCX Both smart services are from the Advanced Document Templating plugin Issue: The DOCX file is generated correctly and preserves all line breaks as expected. However, when converting the DOCX to PDF, the line breaks are not rendered in the PDF output. What I’ve tried so far: Replacing char(10) with the XML equivalent 
 Tested multiple variations, but the issue still persists Implemented solutions suggested in the references below (Links referenced below) Link 1: https://community.appian.com/discussions/f/plug-ins/28870/line-break-docx-from-dynamic-template Link 2: https://community.appian.com/discussions/f/plug-ins/28812/next-line-not-working-when-converting-from-do

Hi Champs, I am using docx from dynamic template smart service to create dynamic document. It's working with simple table. Now I want to try with if else condition in my template. I am not sure the syntax to use to work with it.Can someone please guide how to do it if we have if/else condition . Regards, Shyam

Hi all, I've started the new developer learning path which launched 2 days ago. When I attempt to navigate the ACME SPORT EQUIPMENT RENTAL SOLUTION application I get the following error: "Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator"I have gone in and checked this record type specifically and others related to it and they all have the same issue. The sync history shows a failure and I am unable to run a manual FULL SYNC. Attempting to change the data source on the record type I get the following error: "The data source cannot be reached or its configuration is invalid. Please contact your system administrator."I have reached out to communityedition@appian.com and am awaiting a response. Please let me know if anyone has any ideas or if I find a solution I'll come back here to post my progress in case it helps anyone in the future. 

So i have 3 fields in a record table namely A,B,C and also 3 groups namely A,B,C. So my doubt here is, is it possible to set security to the fields separately. For example if i place a user in group A, then i should see only the A field and the other B and C fields should not be visible to me. If it is possible, can anyone guide me how i can achieve it.