Foundation

Hi All, I am currently using Export from Datastore entity to Excel Smart service.  There are a total of 100 columns in the table and I am splitting approximately 30 columns into each sheet, making upto 3 sheets of data in same excel file. Uses 3 smart services for exporting data into 3 sheets of same excel. In first two sheets, column header is in plain format, But in third sheet column header is showing up as bold. I am unable to find out why one sheet is showing bold header. Can anyone help me how to make the column headers in all 3 sheets into same styling format (Either plain or Bold). NOTE: I am not using any predefined template to update, the new document generated by 1st Export from Datastore entity to Excel Smart service is used to update in the next smart service. The data gets updated in the another sheet, not in the sheet which already has the data. Thanks

I have taken one radiobuttonfield in my interface after clicking on update button in interface it should convert it into textfield. if anyone knows about this please help me out of this

Actually is this for me or somebody also facing this 403 error? 

Hi, Can someone help me here. Line1 code in the below attached image is giving proper expected output (Email). Where as Line2 is returning an error. Any idea what went wrong.

How can we save calculated value in rule input without user interaction in field ??

So, i have a date that cannot be > than today(), so i have a validation field. But when I enter a wrong date, the validation field triggers but it saves the save value into my rule input. It is possible to don´t save the value if the validation field triggers?

The interface for my grid field has all it's data queried before losing connection and stored in a local variable. Then for the grid field's data parameter, it's getting it from the local variable. I have this interface as a start form in a process model, so I may make it an Action on a site. When I test this out on mobile and disconnect myself it stops working. I followed the guide in Appian documentation not sure what I'm doing wrong? Is it because it's not a form, I even gave it a cancel button. 

Hi Team, I have 2 interface one is parent and another is child interface. From child interface i am submitting the form and found that value is not passing from child to parent. I am using same rule input for both parent and child. help me on this to get the solution. Thanks,

I want to write an expression rule to compare values of a rule input and value from a db table field.If the values are same ,then one of the fields(column) of my db table must be set to inactive or 0.

Hi , saveInto is not working for the below code a!paragraphField( label: "Comment", value: ri!comments, instructions: "(" & 255 - len(ri!comments) & ")", saveInto: a!save(ri!comments, save!value), refreshAfter: "KEYPRESS", validations: rule!PDR_validateTextOnSize(enteredText: ri!comments, size: 255), required: true(), readOnly: false() ) when I write anything in paragraph field the value is not save.

Hi guys,  I think I am close to the solution, but I've been stuck with this for a while and figured asking cannot hurt. I am creating an interface which is supposed to show the user data from another User Input Task and have them confirm it has been input correctly. For this I use a read-only grid which I configured according to the Appian tutorial. However, it displays the data in only one row, albeit separated in the pre-defined columns (so e.g. it will say for Underlying "Underlying1; Underlying 2" in one cell). The data is pulled from a CDT as a rule input. It contains "flat" data like single booleans, but also arrays. For this exercise, only arrays are concerned. Do I have to manipulate the data beforehand or am I missing something major? My code: a!gridField(  label: "Fixing Levels",  labelPosition: "JUSTIFIED",  data: ri!product_cdt,  columns: {    a!gridColumn(      label: &q

Hi, Is there a way to use local variables in a rule that is used in reduce function When called from UI? When Using from UI it says that I need to configure  refreahalways for the local variable ..... Thaks in advance, Gil

Good morning, We need to have a webApi that receives a document and a json input with other data in the body. I have been reviewing the document upload template of the webApi and in the body it only lets you add the document.Does anyone know if what I need to do is possible? Greetings and thank you

Hi I am working on Appian version 21.3. I have created an extraction process referring to the below link: https://docs.appian.com/suite/help/21.3/create-doc-extraction-process.html The process looks like this in my case: The CDT is: My concern is, out of all the values only 2 values are extracted and 1 value is semi extracted. The PDF file I have created manually. Want to understand why all values are not extracted despite not much values are there in the PDF. PFB the Appian Reconcile form that pops up as a task for me: Thanks in advance!!

Hello, I have a use case where we need to store the email directly on a service like S3, without parsing. I'm trying to come up with a solution for this and I was wondering if the Receive Message Event allows capturing the .msg file to store it. Our use case will imply some kind of parsing (e.g, body, from, etc.) but we also need to come up with something that allows us to store the raw data. I already explored some options in AppMarket but couldn't come up with a clear solution for this. The event only seems to allow some kind of manipulation with the data and that's OK for us, but we also need the raw information. What can we use to achieve this solution? Kind regards

i am trying loop through the each row in the excel but foreach is not working .

Hi Team, We need to show four tabs in our site's homepage and all the tabs are different interfaces which are interlinked. The first tab/page is a action whose context is a process model with a startform. How should i configure it in the 1st tab page. Below is my code for tabs UI: So here I am trying to call the process model for first page with a!startProcessLink but i is not working. Can anyone please suggest what should be done here? Thanks.

hello, I'm currently on Appian version 21.3 and i want to upgrade to 21.4 can you please help me, I don't have any experience in upgrading appian version 

Hi, I am trying to populate a filter using FitNesse for Appian. The filter seems to be inside a frame, I am able to verify that the user filter is present but when I add script to populate record type user filter, it returns error that it could not find the filter.

We recently noticed a issue in production that the excel is populated with random duplicates for any record intermittently. User is filtering out the data on SAIL and clicks on EXPORT button. We can see the filtered data in the excel but few records are duplicated in excel which does not exist in view or SAIL. We ran the query entity explicitly to determine the data and it is correctly retrieved as per the filters applied. So there is no pattern as such to figure out why this issue is occurring. And this is only observed in Production and not in lower environments. As we are not manipulating the data anywhere, I am guessing the issue must be with the view, especially with primary key. We are currently guessing that the issue might be with the way smart service is sorting out the data based on filters applied in excel report. We are using Export DSE to Excel smart service. We are using a view with SELECT ROWNUM ID and mapping this ID as Primary Key with @ID annotation on CDT. But we are

Does Appian have an out-of-the-box JSON formatter which I can use to format JSON in a User Interface for our support team? Something like https://jsonformatter.org/ offers. 

We are using the helpToolTip parameter with some of our interface questions. Is it possible to change the styling of this (i.e. color, size, icon)?

How can i create 3 column grid on interface with the button at bottom. On the click of submit button new section get open with 3 box having same column as grid columns.

I have a requirement where I have to update a particular field of all the rows of an existing table(Master Table). An API will be called with the PK of the table and the based on the response, data will be stored in the field. And this will be a scheduler which will run daily. How can I achieve this? Thanks in advance.

Hello All, I am not able to complete a task that is created for any attended node by using the a!completeTask smart service from a web api. I am able to successfully complete any user input tasks but not any attended task for any other process nodes. I can complete the same task successfully from Tempo. Also I have used the same assignment group for the user input task and the attended node. Did anybody else face this issue in 21.4? Or is there any other workaround.