Discussion Categories

I've config a summary page in record type, the interface be like rule!BCD_userDetails(userDetails: rv!record). But when I click on record link the summary page has no data populated, seems rv!record has no value in it

Hi Experts,  I have an issue with export data store entity to excel that  without changing any piece of code: Sometimes it is giving exact result in excel as expected Sometimes it is giving few duplicate rows at the bottom of the excel If I download few excel files from the same Page, few excel files seems perfect, few have duplicate rows at bottom I'm failing to fix it. Please help me with some suggestions and if is there any work around. Thank you in advance

Not sure where i went wrong, gets below error, i understand error says i cannot use rule inputs in a!save, any suggestions to fix it:

I have an endpoint which returns data consists of 5 columns (text and date fields). I want to keep an text field and then when I enter values in the text field, I want to filter the data based on the value I entered. It should filter dates if possible

All, I am trying to using Google Drive connected system(https://docs.appian.com/suite/help/21.4/google-drive-connected-system.html) , to create folder, upload and download documents  to and from google drive folders. Then API  operations  (like createFolder, uploadFile, downloadFile, etc) all work perfectly  on a personal folder of an auth user, but   the same operations are not working on a SHARED folder in google drive, Has anybody got that working with a Shared drive?  I checked out some documentation on google drive APIs  at (https://developers.google.com/drive/api/v3/enable-shareddrives?hl=en)  and found out that supportsAllDrives=true  parameter is required to enable these operations on a shared drive. But there is no way in the connected system to pass this information.  Any ideas? Any suggestion?  Thanks Pal

Hi Team, We have a requirement to place a signature in PDF. We created two ways of solutions. Please find the below details, 1.Signature Component and PDF Utilities plugin. 2.Docusign integration As per my organization suggestion, Docusign needs to purchase a license. But here we want a solutions for R&D purpose. Hence we are not able to purchase any third party license. We used signature component and PDF utilities(Image to PDF) to merge the signature into PDF. Question: But we need to send X and Y coordinates to place a signature in right place in PDF. Is there any solution can User picks X and Y coordinates in Appian else share your suggestion too. Thanks, Pradeep Sridharan

How to express this statment in code format: if ri!service is null, just return ri!serviceelse if ri!service ends with a period, don't include period part, otherwise do value for ri!service: "Any days of serious level of working after March,7,2025"

I'm trying to uploading an .sql file which we have blocked in an admin console. It will throw a validation message. Then I'm trying to upload valid file, But the validation message still displays Thank you in advance

I have an interface that stores the data in a record type, which has several fields. Once the interface is submitted, I want it to be saved in the database using a write record. And I get the following error: Unable to write to or delete from the source due to a data integrity violation.Error Details: Field 'Detalles_Trasladado' doesn't have a default value. That Field is not in that interface, but it is in other interface of the process.  How should I write the new record in the record type? Thanks in advance

HI,  I need to download a Ui page in site as a pdf doc, how can i achieve this. Eg:  I have a report in a page like showed above, By a click i need to download this page as a pdf.

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.