Foundation

Hello , Is there a possibility to select a specific Cell in a grid and not the whole line ?

Hi Experts, I'm extracting some data by doing some comparisons via process model and when whole data is extracted(just before the process going to end node), I finally dump the data in excel using Export CDT to excel. But the problem is, in this process a variable of type CDT contains whole data for long (till dumping it to excel) which increase its chances of failure if a large amount of data will extract. I want ---> If in total there are 6000 rows which need to be extract, So I want to extract first 1000 rows and dump them in excel and repeat this process for all the 6000 rows which extract in 6 times. Main problem ---> I want all the data in same excel, same sheet, next 1000 rows append after the first 1000 rows Don't want different excel , different sheet. Suggest some possible solutions thoroughly  Thanks in advance

Hello Appian Community so from last 2-3 days I don't know  why I am not able to access my cloud database , whenever I am trying to open it so new tab is opened but there is blank page I don't know what's wrong so someone can help me out regarding this. ?

We have a process model that inserts records into a table and then we call a stored procedure that will execute and perform an update action on the newly inserted records while running it the process model is executing successfully and records are getting inserted but it seems the execute stored procedure node is not executing. also, the node is not giving any errors, yet it is taking some time to process but the update is not done. Can anyone help on what might be the probable reason? Is it going out of scope? Screenshot of the PM where the node has been added:

"I am working with dependent tables, and it's already functioning in the interface. However, when starting debugging in the process model, it throws the following error: I believe this might be due to the variable in the 'Group' field, which comes from the interface as an integer variable but is presented as text in the user form. Could you guide me on how to handle the configuration of the node or the properties of the Process Model M to fix this error?" This is what I have in my node configuration These are the variables on my Process Model´s properties and this is my rule inputs on the interface Appreciate your comments. Regards,

Hi, I am trying to show data on piechart, the field make has different data.  I want to segregate the data into let's Ford and non Ford. How can I do that?{ a!pieChartField( data: 'recordType!{aa4ce38f-1a9d-4827-af51-e2ccb80a2c8b}AS Vehicle', config: a!pieChartConfig( primaryGrouping: a!grouping( field: 'recordType!{aa4ce38f-1a9d-4827-af51-e2ccb80a2c8b}AS Vehicle.fields.{7aa3dcda-863a-4271-9034-85821a2bd453}make', alias: "vehicleMake_primaryGrouping" ), measures: { a!measure( function: "COUNT", field: 'recordType!{aa4ce38f-1a9d-4827-af51-e2ccb80a2c8b}AS Vehicle.fields.{595da20e-a849-4c36-a57e-d569453c622f}vehicleID', alias: "vehicleId_count_measure1" ) }, sort: { a!sortInfo( field: "vehicleId_count_measure1", ascending: false ) }, dataLimit: 100 ), label: "Vehicles by Make", labelPosition: "ABOVE", showDataLabels

Hi, I have an interface from which I am passing documents from an attachment field from an interface to a process model. That process model simply writes the doc id to the database. I am getting a problem thet the rule inputs are holding the values but it is not passed to my process model. Can anyone please help on this.

Hi Everyone !!!,I know this is very common question i know it but for clerification can anyone let me know that  We can directly save the data into the database througth interface but which is better from process model or interface??

 Requirement During the new record creation if user fill Details  and doesn't click on save draft button and didn't submit the form and no actions are performed on it within 24 hours, the task should be automatically deleted. If user Clicks on save Draft  button then task shouldn't be deleted for 30 days Thanks in advance!

Hi All, I have to display the data shown in below screenshot. Is there any grid pattern available to display like that?

Hello, We have a CDT in our application to match an Excel file that is being uploaded. If the Excel template changes (ie. column headers are renamed and rearranged), what is the best practice for getting the CDT to match the new Excel file being imported? If I edit the XSD of the CDT to match the new Excel template, will all dependencies automatically update under the CDT?

In part of my requirements for this project I am working on in Appian is to allow admins of the application be able to dynamically add fields and forms from the backoffice interface for users to access and submit their responses to the dynamically generated forms. I have looked everywhere online for the answer but have found little to no information on the topic. All I found was a plugin, however I am precluded from utilizing plugins in this specific project, and as such, must be developed entirely on Appian without plugins. Can this be achieved?

Here in this model, you can see currently instance sits in Confirmation Screen user input task, but from user screen, this wasn't opened and process got closed showing "Action Completed" banner. I've activity chaining all the way till this node. What could be the possible reason for it? Please advise. Also, for this node, there are two instances at the same time, though the assignee is pp!initiator.

Hello Everyone, I have a requirement of showing an editable grid when clicked on a value in a read only grid. Is it possible to do? Or Is it possible to give a search filter and user filters to a editable grid?

Hi!  I read it isn´t possible to create an any type variable in a process. This is my use case, I hope you can help me: I need to pass a process an array of cdt, but it could be different types of cdt, and the process, depending of the cdt type writes on a different table. Any idea is welcomed, thanks!

I cannot select or change the target as I get "Cannot find the main Appian window. Reopen that window and launch the modeler from there." Is there a fix for this bug?

He all, we are able to upload files with extensions(docx,xlsx) to documentum.but we are facing issues, while retrieving from Documentum to Appian, we are not able to get the extension, instead saving as type "file".is anyone facing this issue and let me know the leads. Thanks.

Having two tables one is having 100 records other is having 5 records with same index as in table one ,  I want to update the table with 100 records with the data from table with 5 records using foreach loop in appian? write syntex.I am trying to update records using write to record function. Can anyone explain about this.

Hi Experts I have a problem where I need to generate an excel without storing the data in DB. I'm using Export CDT to excel smart service, But I have nearly 6000 rows to fetch with only 3 columns(Request ID, DOC ID, Doc Name). I want to know what is the maximum amount of data in terms of size(MB or KB) a process variable of type CDT can hold. And if is there any better solution of what I'm doing, please suggest me. Thank you in advance

Hi, I have a case in our application where we consume data from pulsar via Pulsar Message Consumer, but what I noticed is that record type for the table which we are storing the data is not synchronizing automatically and after researching I saw that not all smart services can sync the record automatically.  So, my question is: can I add a Write Records node after Pulsar Message Consumer node so that the record will be synced, and if not what can be the best solution to this as scheduling a full sync is not an option because the process runs every 30 min each day, and we can schedule a full sync once a day. Thank you

when i pass the value to the code am getting below error if( null(ac!convertWord_txt), "zero", convertnumbertoword( trim(split(ac!convertWord_txt, ".").[1]), "" ) ) what might be the issue here

Hi Team,Can anyone explain detailly 1.why we should not use continuous gateways in process model and 2.why we should we need to add a dummy script task in case of looping or in between the continuous gateways with a example scenario for each one of the case?Thanks in advance!

Hi  We have just upgraded the Appian version from 21.4 to 23.3 and we have an issue with the date format exported to excel coming from record types, in the prior version this issue was not happening, does anyone has experienced the same issue? 21.4 version-correct format 23.3 version - incorrect format by looking the format in the excel is taking it as if it was a text but this is the logic behind the date column: if( a!isNullOrEmpty(fv!row['recordType!{92d1b022-5508-4130-83d7-528677bb837e}ACH CASE.fields.{b79811e6-b6ad-4b38-b04d-134b4d22d656}createdOn_dateTime']), todate(null), todate( text( fv!row['recordType!{92d1b022-5508-4130-83d7-528677bb837e}ACH CASE.fields.{b79811e6-b6ad-4b38-b04d-134b4d22d656}createdOn_dateTime'],"mm/dd/yyyy hh:mm AM/PM" ) )) we are just converting the date and time to date and when we do that the format gets reflected as text in the excel which was not happening in version 21.4 

Hi All, Facing "could not cast from list of Map to Dictionary" error while calling a!startprocess in interface, could you please help me in resolving the issue. Created a portal to capture the vehicle details in an apartment, after data entry and after clicking on "Save" facing this error and this is developed for hands-on purpose only. Pasted error and code for your reference. "Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = WBZTQ] : An error occurred while executing a save: Expression evaluation error at function a!startProcess [line 438]: Could not cast from List of Map to Dictionary. Details: CastInvalid" a!localVariables( local!residingOwner: true, local!tempApartmentName: "Dollfine Durga County", local!successMessage: "", a!sectionLayout( label: if( ri!isUpdate, "Update Vehicle Details", "Create Vehicle Details" ), contents: {

Hi, For my requirement, I have multiple rows with radio button field in the grid. The selected radio button values are saved in local variable and that local variable value is stored in the rule input variable {CDT Type] on click of save button. The rule input contains 5 fields, where 4 fields are copied from the local variable and one field is not copied. Could anyone help me on this, Local Variable: Rule Input: a!localVariable( local!listQuestionAnswer: a!forEach( items: (Fetch Data from DB), expression: { id: null, question: fv!item, answer: "No" } ), local!questionResponse: { a!forEach( items: local!listQuestionAnswer, expression: { answerId: null, answer: fv!item.answer, questionCode: fv!item.question.questionCode, jobTYpe: ri!jobType, jobId: ri!jobId } ) }, { a!gridLayout( headerCells: { a!gridLayoutHea