Foundation

I want to create a report with bar/pie charts, however whenever I attempt to do so I get an error stating that I have to utilize a synced record type or one that is backed by a datastore, is there no workaround for this issue? Or does my data have to be stored in an external database in order for me to establish reports?

Is there a way to obtain these metadata and others, such as the version of an object in our application, from an expression rule? I cannot use it due to technical limitations of the Content Tools plug-in, but I do have access to the appian primary database. Any help or suggestion on the way forward would be welcome.

Based upon the previous approval and reject status we need to predict and make the process autoapproval. We have three forms which user has to be filled and submit based upon this data the reviewer will approve or reject. Based on the previous data and approval& reject status the flow has to be automated. How do I achieve this..??

Hi, Do anyone know why I am not seeing the number of results instead its showing of results.

Hi Experts I have to delete extra files from request folders. Request folders were created at the time of request creation. Extra files means , when I was trying to migrate the files from legacy environment to cloud, PM fails. So, I Re-migrate the files that's why those request folders have some extra files. Now, before deleting those files I need to take a backup of files and folders, How to do I do this , because when I take backup and reupload backup, the doc id and folder id changes and I don't want IDs to be change. Taking backup is more important because we can't except any important files to be delete.  If any solution is possible please explain step by step. Thank you guys in advance

a!gridLayout( labelPosition: "COLLAPSED", headerCells: { a!gridLayoutHeaderCell( label: cons!CR_APP_LAB_STAND_VS_NONSTANDARD_FIELDS[2] ), a!gridLayoutHeaderCell( label: cons!CR_APP_LAB_STAND_VS_NONSTANDARD_FIELDS[3], align: "CENTER" ), a!gridLayoutHeaderCell( label: cons!CR_APP_LAB_STAND_VS_NONSTANDARD_FIELDS[4], align: "CENTER" ), a!gridLayoutHeaderCell( label: cons!CR_APP_LAB_STAND_VS_NONSTANDARD_FIELDS[5] ) }, columnConfigs: { a!gridLayoutColumnConfig(weight: 5), a!gridLayoutColumnConfig(weight: "NARROW"), a!gridLayoutColumnConfig(weight: "NARROW"), a!gridLayoutColumnConfig(weight: 8) }, rows: { a!forEach( items: ri!crAppStandVsNonStand_cdt, expression: a!localVariables( local!choiceValue, local!SingleREFStandardVsNonStand_cdt: index( ri!crRefStandVsNonStand_cdt, wherecontains( fv!item.questionId_int, tointeger(

hi Team, How to change the background color of the coding screen into black or dark theme?

I have CDT within the cdt feils name tableDetails(text), Text like [{"column1":"value1","column2":"value1"},{"column1":"value1","column2":"value1"}] how to display in gridlayout. give me the suggetion on this..?

I got this error when none of the interfaces or expression rules mentioned use the load() function, they all use a!localVariables(). Does anyone know why this error could still be appearing? "Interface Definition: Expression evaluation error ... The load() function cannot be used within rules called by looping functions other than a!forEach(). Pass the necessary variables via rule inputs or use a!forEach()."

Hi , I am stuck with some logic here in color code, I need to represent variance column in amber colour ,if the varience is dropped to 50%. than actual value, Now this variance column is calculated with formula (actual-cov.threshold)/actual*100 so getting value is.How would I calculate that?I have used richtextDisplayfield a!richTextDisplayField( value: a!richTextItem( text: fv!item.varience_txt, color: if( fv!item.varience_txt < 0, "NEGATIVE", if( fv!item.varience_txt > 0, "POSITIVE", if( (fv!item.varience_txt) < (fv!item.actualThreshold_txt * 0.5), "#FFBF00", "" ) ) ) ) )&nbsp;&nbsp;

I&#39;m seeing a white space below my footer in the site. Is there a way to remove it?

Hi,&nbsp; So I have a process model that sends an email and that email has a link that should redirect to that particular case summary page. Now, my Site has 4 tabs and in one of the tab we have 3 tabs and one of which has the record list of&nbsp; some XYZ table. In the record list,when clicked on the link of a particular case redirects to the summary view that is an interface created separately which takes the identifier as the input. Now, I am able to get the tempo url but what I need is the site url. Is it possible to get the site url. I tried substituting but didn&#39;t work for me. Let me know any kind of solution. Thanks in advance&nbsp;

So I have this readtextfromfile function available to me through a plugin, but I don&#39;t understand why it&#39;s not working. I have the most basic of the basic interface here just to test its usage in my sandbox, and I&#39;m getting this error:&nbsp; Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function &#39;readtextfromfile&#39; [line 2]: That&#39;s it. I&#39;m not sure what the issue is. Does anyone else have more experience with this function? Thank you! a!localVariables( local!extractedText: readtextfromfile(ri!uploadedDoc, true), { a!sectionLayout( label: "Section", contents: { a!fileUploadField( label: "File Upload", labelPosition: "ABOVE", target: cons!KS_UPLOAD_FILES, value: ri!uploadedDoc, saveInto: ri!uploadedDoc, validations: {} ) } ) } )

Hi Everyone, Requirement: We need to segregate the process model based on the app name in the process task reports. We are creating the process reports based on all task, we need to fetch the app name based on the&nbsp;Process model&nbsp;ID.Any suggestions would be appreciated, Thanks in advance.&nbsp;

I am facing an issue where i am getting expression evaluation error during file upload (line number 688)

Is there a way (or will be) to run a subprocess synchronously, containing a user task , passing pmid as a parameter? We would like to be able to execute a subprocess call in that way, passing the pmid as a parameter to control the flow of the process from, for example a Decision table.

Hello everyone. I am new in Appian and am trying to build a web app &quot;Canteen&quot; as part of my learning path. Couldn&#39;t find anything in other posts as I don&#39;t know how to search it. So my issue is the following... I have a Canteen Menu where each user can select products to add in the cart. On the interface I build a list of product variations (with a tempId in order to update something since I haven&#39;t saved anything on DB). When I press the &quot;Place Order&quot; button, I want to create a new &quot;Order&quot; with some fields and then get the ID of the created record. Then I will use the orderId and create the related &quot;Product Variations&quot; from the selected products list. How can I do this in the process model? &nbsp;&nbsp;

Hi Recently i genereate the health check report in that it showing one finding in perticular interface like (InvalidGroupException) for getdistinctusers function but when go to that perticulat interface there is no error it&#39;s woriking fine but i don&#39;t no why we get this issues, somebody help me why we got this finding in that report

Hello, In user interface we have picker field defined in that if we select one userprofie and later we are calling another subinterface in which we are selecting some products from list and whatever we have selected will be moving to editable grid&nbsp; For example in below screen 1.when we are selecting user we will have an option to selected products and link to editable grid which means selected products will be added under Linked products this details was defined in an other interface which we are calling to the current interface 2.If i am removing the user profile means the values from the Linked products which is defined in other interface also has to be removed but it was not removing Please find&nbsp;the logic available under user profile &nbsp; saveInto: { a!save( ri!record['recordType!{63a0b9c7-fe03-4c99-8667-a1d9a63acf3f}DIL Users.fields.{d05ec5c4-2ec2-45df-813f-59993f59acd5}profile'], t

How we will covert (&quot;INDIA&quot;) TO {&quot;I&quot;,&quot;N&quot;,&quot;D&quot;,&quot;I&quot;,&quot;A&quot;}. How we will write in expression rule?

We are using&nbsp;smart service &#39;export data store entity to excel&#39;. While downloading the excel it has 4036 rows but in table in database it has more than 4036 records. We tried same with different table, limiting number of columns but each time it only generates 4036 rows in excel even if data in table is 4080 or more.&nbsp; Can anyone suggest is there any limit in number of rows being generated through this smart service, or we can find any alternative method to this issue.&nbsp;

Hi , I need some calculation logic in appain that gives difference of ration numbers example shown below in the screenshot. Can someone help me to write the logic for this on priority? Here actual and threshold values are user inputs based on those inputs variance col data to be shown .

Hi, I have a record action which shows &quot;Add Artwork&nbsp;Milestones&quot; and after completing/adding the artwork details the record action should get updated to &quot;Edit Artwork&nbsp;Milestones&quot;. But it is&nbsp;showing to Edit Artwork Milestones Action only after page refresh but not immediately after the action submission.&nbsp; I used a local variable to call the record action with a!refreshvariable() but still it is not getting updated dynamically without refreshing the screen. PFA code and help me resolving this issue.a!localVariables( local!recordAction: a!refreshVariable( value: a!recordActionField( actions: { a!recordActionItem( action: 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.actions.{9cb9fc4e-57ad-4aaf-b21b-6dabf15c4a55}addOrUpdateArtworkDetails', identifier: ri!labelChangeCountry['recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{6c137b66-e39e-49a

Hi everyone, Please help me How we can make the start process synchronosly&nbsp;

Iam trying to add a new row link to the editable grid, The data entered in the new row shoud be saved to Database. anyone give suggestions.&nbsp;