Foundation

Hi Team, When using import CSV to Database smart service, is there a way to update the data after uploading the document Eg: In my excel file, I have 3 columns id, name, updatedon id and name values will be availble in the csv file, after uploading the file and when writing to DB we need to update the updatedon value with the updatedon time.

I am getting this error while executing PM to generate PDF from docx how can i resolve this ? error : Reference is not allowed in prolog.

I am using a script task to use a expression rule. Saving the value to use further in process model. But getting the error: "There was an error in an expression in encryption at Output Expressions : Neither variable(s) nor rule(s) found: expression". I am facing the error today only, before that it was fine.

Hi, When I'm trying to upload a document by using startprocess , I'm not able to get the name using document() function. It's showing error as document doesn't exist/ has been deleted. But the document is present in target folder and docid is present..Let me know if am missing anything:

Hi all, I have created an Appian web API that insert record on our server using Appian tables, this API is consumed by SAP to insert data.And it saves data ,but when an error occurs, how we can provide information about the specific input field where the error occured and give a customised error  message to the end user.We need help and support from the Appian team to provide a detailed and customized error message for a webapi. Hope anyone can help us on this scenario?

Hi, have a requirement to short a record field which have integer value how can i do that ?

HI Appian team, I need help from you to show custom error message in a web api, i have asked the same question 4 months ago, in that i got a suggestion that to create an expression rule and validate the api using that ,but where i can use expression rule in an API, Please find the code attached to understand webapi code and expression rule i created. How can i call the expression rule within webapi to validate API for errors,Is anyone have done similar requirement ,if yes please post code snippet for us. thanks a!startProcess( processModel: cons!PF_Create_Request_WithChanges, processParameters: a!fromJson( http!request.body) , onSuccess: a!httpResponse( statusCode: 200, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( fv!processInfo ) ), onError: a!httpResponse( statusCode: 500, headers: { a!httpHeader(name: "Content-Type", value: "application/json")

My code appears to be correct, however i receive the following error message when i change to design view. Error:   My code is the following: a!localVariables( local!DatosPedidos: a!queryRecordType( recordType: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos', pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500) ).data, local!DatosPedidosLineasPedidos: a!queryRecordType( recordType: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido', pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500) ).data, local!DatosPedidosRecepFiltro: a!queryRecordType( recordType: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos', filters: a!queryFilter( field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{eeea3ae1-9516-46e3-8caa-327a9154b43d}recepcionado', operator: "=", value: true ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500) ).data

Hi All, The requirement is that we do get a time value with time zone in a CSV in text format (ex: 12:00 CET), which we read and display on UI. When displaying the time on the UI we need to display it in GMT. With the current datetime functions this seems to be difficult to achieve. Other thing in mind is that maintain a table with time zone off set values for different time zones we get and use it to calculate the correct display value. This has its own issue like day light saving adjustments. But before going into that route we need to find if we can still do this easily programmatically.  Any advice is appreciated. Ex: Time value received in CSV : 12:00 CET on UI we need to display 10:00 GMT

here in richtext editor, on click of save values should be null, but after saving the values to DB again can see the values here.  on click of save values should store to DB and on UI it should not show - how can I achieve this?

Hi  Team,I am having use case where we are using IDENTITY feature available in Oracle in substitute of Sequences. and it is working fine from database insertion. But Appian is still expecting sequences.I went through few of the posts regarding  the same but there is no solution available rather than using sequences.I wanted to know if Appian is upgraded with the similar feature ? Anyone has used any strategy to accommodate the IDENTITY change ?Any feedback help is appreciated.

I m getting error in Execution log . Script ran successfully but in execution log getting errro message. pasted below.Thank you in advance.

Trying to save records ID back into the process variable when doing 'Write Records' but it's deleting the data of de process variable and only saving it's IDs. Any input on what I might be doing wrong? Is this normal with the write records node?

Hi! I have created a process model in which a validation is needed depending on the group of the user In this case, if the user is from the group "CPF Proveedores", a validation Interface should appear as a task for the users of the group "CPF_Gestores". In order to fulfill my objective, I configured the User Input tnterface In order to fulfill my objective, I configured the User Input task this way: It works properly, and the task can be shown in "Tempo" for the Gestor1 (OK). But this "forces" the user to go to the tempo site, and I would like to show him that he has a task in a summary view of my site, for example. Which approach would you recommend me as a best practice? Is it possible to create a button to link with tempo? Maybe a link in one field?  Any opinion to define my approach would be useful  Thanks a lot

When designing an interface for a record action, I noticed I am having trouble optimizing the UI for the specific dialog box size, since its width and height are fixed. I think we could benefit from dialog box sizes (large, medium, small) being available options alongside device widths in the preview pane of the expression rule designer.  

Hello,I'm currently utilizing intelligent document processing to extract data from PDFs. However, in line with our client's needs, we are interested in exploring the extraction of text from handwritten PDFs or images. Can anyone confirm if this is achievable through Appian? or any other way.

Hi All, We have developed an application. We have designed UI with front-end technologies and back-end with java,  But UI front-end technologies are not acceptable in Client side, Can we use Appian to design front end interfaces and link with backend java code?

Hi all, I would like to know if one of the process node had configured Exception Flow and then that node fails will it paused by process Exception or will Exception Flow triggers.Can you please give me some technical details regarding this. Best Regards, Divya

Hi! I have created a process model in which a validation is needed depending on the group of the user In this case, if the user is from the group "CPF Proveedores", a validation Interface should appear as a task for the users of the group "CPF_Gestores". In order to fulfill my objective, I configured the User Input t In order to fulfill my objective, I configured the User Input task this way: But the fact is that, when I enter as the user from "CPF_Proveedores", the validation interface appears to me, instead of leaving it as a "pending status" until the user from "CPF Gestores" approves/rejects it. This means that the logic of detecting the user is correct, but the interface is shown to CPF Proveedores too. What am I configuring wrong?  Thanks a lot for your time

can we declare  local variables inside a!foreach() inside expression rule 

I'm trying to do a required field but I only want the option to select or deselect the required field, I know I've seen that done somewhere, do any of you know how to do it? Thanks

Hi Team, I have group - Group1 In the group 1, we have 3 users user1, user2, and user3. Now, I have loggedin with user1 account. In the pickerField now the user1 should not be listed out. Can you please help with the approach.  a!pickerFieldUsers( label: "Users", labelPosition: "JUSTIFIED", maxSelections: 5, groupFilter: cons!Group1, value: local!selectedApprovers, saveInto: local!selectedApprovers, required: true(), validations: {} )

Hi, I am trying to get the next day from today's date. For eg: today is 18/9/2023. I need to get 19/09/2023. I tried using some day function to get the day and add 1 to it. I was testing with different timezones. now() - 9/18/2023 10:50 PM PDT now() + 1 - 9/19/2023 10:50 PM PDTwhen I used day function on now() +1, its giving 20 instead of 19. I am not sure what is the issue or maybe I am missing some timezone offset. This is occuring when I tested for Pacific timezone. Its working fine for IST. Please help me on this. a!localVariables( local!date: now(), local!endDate: now()+1, local!day: day(local!endDate), local!day )

I have a group of sequential tasks (data record, interface, query, script task..) and i want to group them into a subprocess to simplify the process model. How should i do this?

I am using square brackets but this error shows .  what is wrong with my code? a!boxLayout( label: "Box", contents: { a!gridLayout( label: "Document", headerCells: { a!gridLayoutHeaderCell(label: "Document", align: "CENTER"), a!gridLayoutHeaderCell(label: "Name", align: "CENTER"), a!gridLayoutHeaderCell(label: "Classification", align: "CENTER"), a!gridLayoutHeaderCell(label: "Upload By", align: "CENTER"), a!gridLayoutHeaderCell(label: "Upload On", align: "CENTER") }, columnConfigs: { a!gridLayoutColumnConfig(), a!gridLayoutColumnConfig(), a!gridLayoutColumnConfig(), a!gridLayoutColumnConfig(), a!gridLayoutColumnConfig() }, rows: a!forEach( items: if( a!isNotNullOrEmpty( ri!record['recordType!{2206daff-ddbb-4759-a797-1588754c3925}SKJ Deposit Request.fields.{0cfaa083-3ffb-447a-b