Discussion Categories

How to add commas for large numeric digit(125000) in bar axis for column chart field?

Hi, I am trying to connect a 3rd party system which uses OAuth 2.0 Password Grant Type authentication, as it is not supported by Appian connected System. I have created a separate integration object to get the access code where I am passing below fields in request body. "client_id": {client id} , "client_secret": {client secret}, "username": {username}, "password": {password}, "grant_type": "password" Getting this error  "error":"invalid_request","error_description":"The grant type was not specified in the request". I tried creating token using POSTMAN and there it was working fine. Attaching screenshot for both. POSTMAN Response: Appian Integration Response:  

Hi! I have three questions regarding the Excel Tools plugin. Sadly the documentation is not very precise.1. How can we read headers with spaces (Example: a column with a header "User Name")? I found this question in two different threads but they are almost 10 years old, which have links to appian sites that are no longer accessible. 2. One of our clients provides us an excel that is automatically generated, and has +10 columns. I'm only interested in 3 of those columns. Is there a way we can pick and choose which info from the excel we are interested in? I'm using the Import Excel to Database smart service. I'm pretty sure that the "Excel Header Names" and "Database Field Names" parameters might be useful for this case, but I don't understand how to use them properly, and the documentation does not say a lot about them.3. The same excel that I mentioned in my 2nd question starts at row number 3. Row number 1 & 2 have som

I have an editable grid with an addRowLink, when I clicked the add row link, the grid somehow changed, like first column became wider and last column was narrowed, anyone knows why The only think I did in addRowLink is append a new item to current list

I am using a!recordsChatField(). When asking a question, I receive a response like "I apologize, but I am not able to provide information about changing a payroll vendor, as that is not related to the data provided for the RH Project Ref entity. As an AI assistant trained on this specific data, I can only respond to questions regarding the fields and information presented for this entity."  I'm assuming the reason for this response is because I need to aggregate the data in the record. Within Process HQ I can aggregate all the data in the record with the click of a button.  When using Copilot in Process HQ on the same record, I receive a proper response to the same question since the data is aggregated.  Can someone provide an example of how I can aggregate the record data within the  a!recordsChatField() component? Here's what I have so far: a!recordsChatField( label: "Chat", instructions: "Type in a question", suggestedQue

I am facing an issue with the a!fileUploadField() component in Appian. The validation logic is supposed to restrict uploads to only PDF files, but it is not throwing an error when an XLSX file is uploaded. Below is my implementation:a!fileUploadField( label: "File Upload", labelPosition: "ABOVE", target: cons!W500_KnowledgeCenter, maxSelections: 5, value: ri!File, saveInto: ri!File, validations: { if(fv!files.extension="PDF", "Error", "") } )

Hi,  The requirement is to export data to an excel file and add filters on all columns in a row, so that the user can manually select the filter manually. Export is successful using "Export DSE to Excel", but how to add the filters on all columns.

Can any one explain how to generate PDF from reports with grid data.

Hey, does anyone know how to use this? I tried something like this, but when I selected text on the document, nothing happened. I know it's wrong, but the descriptions from  [mention:d980071ec4a04401afc047d67fdc6548:f7d226abd59f475c9d224a79e3f0ec07]   weren’t very clear to me. If someone could guide me on how to use this instead of the smart service, I’d really appreciate it!

We are trying to find out the current utilization of LIMS so wanted to know if you have any monitoring tools to check the current active users

Hi Team,I'm facing a issue with write records smart service. And my database mysql. I'm unable to find the root cause. I have a script task before the write it outputs the data correctly.

Hi Friends, I have a requirement for an interface that consists of a column chart and a filter with top 1 and top 2 values. I am using a record field for grouping, so it is giving 10 columns in the chart. However, when I select top 1 in the filter, I want the graph to display only 1 column. If I select top 2, I want the graph to display only the top 2 columns. Refer below pics Normal Pic :  when I select top1 I want to show only inventory management in entire graph,. When I select top2 I want to show only inventory management and Quality control columns in chart.

I have a simple PM to write single record using a Write to record smart service. It has been working fine in our lower env's Dev and SIT. First ran into the below error after promoting this Pm to UAT.  Error: Unable to write to or delete from the source due to system error.Error Details: Invalid argument(s) in call I am pretty sure the cause for this is not configure the sequence in the Record Type(couldn't test/push changes to UAT yet) . Do you guys agree this will solve the problem? if not please share your thoughts.  if this is indeed the root cause of the issue, it raises a different question. How did this NOT cause a issue in our dev or SIT env's ?? Pm is working fine writing new records into DB with out sequence being configured in the record type in both the env's. Kindly shed some wisdom on this.  Note: 1.Exact same table and sequence structure used across ENV's. 2. Only non nullable column in the table is primary key. Thank

I'm not sure why a!save doesn't work and throws error:Any suggestions where I'm going wrong?

Hi All, I hope everyone is doing well. I have 2 records - 1) Employee's Details   2) Task   3) Upload. When i raise a request and submit , the details get save in Employee record . and a task is created . For the employee's  they upload few documents like 1) kyc, 2) pan, 3) aadhaar. They have an option to select the document they are  going to upload. The catch here is for all employees all the uploads are not mandatory , they can upload any 2 or 1 or all three of them.  Here in the grid , we gave a start link so that the process model of upload document starts automatically and based on the document upload for a request the link should be disabled , so that for same request id we cannot upload any other extra document. Can anyone please help me with the right approach. Thank you in advance.

Hi, I'm new in Appian and I have the next error: Error Evaluating UI Expression Expression evaluation error [evaluation ID = 44U5D] in rule 'w2756aa_grd_maintenancerequestsgrid' (called by rule 'w2756aa_dash_vehiclesummaryview') at function a!gridField_24r3 [line 5]: An error occurred while retrieving the data for "W2756AA Maintenance Status". Details: 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. (APNX-1-4198-000) When I try to follow these instructions (just when I click on "VIN" on any vehicle): Can you help me, please?Thank you

Hey everyone! In my project, I need to create a PDF with fields that users can fill in. To achieve this, I've opted for the Fill PDF plugin. This plugin includes an input called "Documents" where I must upload the PDF form that contains the fields to be filled in by users. How can I generate this PDF since I can't use Adobe Acrobat in my case?

a!localVariables( local!text, local!docIds, local!expPDF, { richTextEditorField( label: "Advanced Rich Text Editor ", labelPosition: "ABOVE", validations: {}, height: "AUTO", richTextValue: local!text, richTextSaveInto: local!text, isReadOnly: null, showMenubar: null, includeHTMLlength: null, maxSize: 200000000, placeholder: null, enableSpellChecker: null, showUsageBar: null, enableFullpageOutput: null, allowImageUpload: true(), imageStorageConnectedSystem: cons!TAAA_RICH_TEXT_CONNECTED_SYS, uploadedImagesDocIds: local!docIds, exportedPdfId: local!expPDF, enableExportPdf: true(), hideBorderInReadOnly: null ) } ) Connected system:

Hi All,We currently have 3 servers in our production environment hosted in appian cloud. Server 1 is having memory used % of 69%, server 2 is having around 59% and server 3 is having around 60%. Any reason why the memory usage is not symmetrical, I mean why they are not much closer to each other(server 2 and 3 are close but 1 is little high). Any idea how these are handled? Any suggestions would be helpful.

Hi All, I am trying to display the table header on repeat when there is page break inside a table when using the plugin html to pdf. I have tried most of the options, has someone faced trouble with this or implemented the same? Attaching the html code   body{ font-size:14px; } img { max-width: 100% !important; max-height: 100% !important; } thead { display: table-header-group } tfoot { display: table-row-group } tr { page-break-inside: avoid } One One Row 1 Column 1 Row 1 Column 2 Row 2 Column 1 Row 2 Column 2 Row 3 Column 1 Row 3 Column 2 Row 4 Column 1 Row 4 Column 2 Row 5 Column 1 Row 5 Column 2 The generated pdf is as follows: 

Hello,We are trying to create an Appian RPA bot which creates and configures a process model in an appian application. We are able create one, but facing issues while configuring the process model. As the bot needs to drag the smart services from the palette and drop between start node and end node, we are unable to find the X co-ordinate and Y co-ordinate in the Drag RPA service. Also the bot is unable to identify the selectors such as XPath, CSS, or ID in the Interact with Element RPA Service.So is there any alternate way to achieve this. Suggestions would be helpful.Thanks In advanceRohith

=a!formLayout(   label: "Hiring Request Form",   contents: {          /* Section: Request Information */     a!sectionLayout(       label: "Request Information",       contents: {         a!radioButtonField(           label: "Are you making this hiring request on behalf of yourself or someone else?",           choiceLabels: {"Myself", "For Someone Else"},           choiceValues: {"Myself", "For Someone Else"},           value: ri!requestFor,           saveInto: ri!requestFor         ),         a!radioButtonField(           label: "What type of hire do you need?",           choiceLabels: {"Non-Emplo

Hi Team, I was using the below rule and trying to fetch the data with the condition that selecting one ID from a grid should get one CaseID: 50324 and if selecting more than one ID should get CaseID: Multiple ID. can anyone please help me on this  a!localVariables( local!data: a!queryEntity( entity: cons!BEMS_ENTITY_PAYABLE_CASE_VIEW, query: a!query( /*selection: a!querySelection(a!queryColumn(field: "clientName")),*/ aggregation: a!queryAggregation( a!queryAggregationColumn(field: "clientName", isGrouping: true) ), filter: a!queryFilter( field: "caseId", operator: "in", value: a!flatten({ ri!caseIds }) ), pagingInfo: rule!TCO_defaultPagingInfo() ) ), { if( local!data.totalCount > 0, if( local!data.totalCount = 1, left( "Standard Template - " & proper( joinarray(local!data.data.clientName, " & ") ) & " - " & "CaseId:" & joinarray(ri!caseIds, ", "), 80 ), if( local!data

Hello, I have added a security expression in record-level security to handle complex filter criteria that include the logged-in user as one of the filters. I am exporting the record information using related actions and a scheduled job. Export from the related action is fetching the expected output; however, export using the scheduled job is not returning the correct results because the record-level security condition is failing due to the logged-in user check. To get the correct results, do I need to explicitly pass the filters defined in record-level security when querying the record from the scheduled job? Or is there a better way to achieve the same results? Please advise. 

Hi Team, I was unable to get the data with the below condition that passing one ID should get CaseID: 1234 and passing more than one than one ID should get CaseID: Multiple ID a!localVariables( local!data: a!queryEntity( entity: cons!BEMS_ENTITY_PAYABLE_CASE_VIEW, query: a!query( aggregation: a!queryAggregation( a!queryAggregationColumn(field: "clientName", isGrouping: true) ), filter: a!queryFilter( field: "caseId", operator: "in", value: a!flatten({ ri!caseIds }) ), pagingInfo: rule!TCO_defaultPagingInfo() ) ), { if( local!data.totalCount > 0, if( local!data.totalCount = 1, left( "Standard Template - " & proper( joinarray(local!data.data.clientName, " & ") ) & " - " & "CaseId:" & joinarray(ri!caseIds, ", "), 80 ), if( local!data.totalCount >= 2, left( "Standard Template - " & proper( joinarray(local!data.data.clientName, " & ") ) & " - "