Discussion Categories

HI, I have a requirement to display Week Calendar with Meeting conflicts., Used event time line with details pattern and managed to design below calendar  Calendar timeline divided into 30 min sections as meeting possibility 1 or 1.30hr etc.  the issue here is meeting one starts at 11 am and end at 11.30 , it should show meeting tag starts from 11 am and end at 11.30 but it showing two different tags for meeting1, one at 11 am and another at 11.30.  if there is another  meeting same time meeting2, it should show beside to that, and both should be in red. since i have divided timeline into 30 min blocks , i am not sure how to combine two meeting tags if meeting falls for more than 30 min?  Below is the code: a!columnLayout( contents: { a!forEach( items: local!CalenderTime, expression: a!columnsLayout( columns: { a!columnLayout( contents: { a!richTextDisplayField( labelPosition: "COLLAPSED", value: fv!item.updatedTime, align: "CEN

Please let me know how to add the highlighted icon

Hi,I had a requirement, has to provide a link for the box layout header, 

Hi, We have a use case whereby we are looking to do some integration to DevOps and deploy certain packages as needed.  Currently using an four on-prem, azure environments (Dev/Test/PreProd/Prod). What we are looking for is some sort of UI (which we can design and build) where we can select from a list of packages and send this to devops or network location which would then initiate a pipeline release in DevOops and any automated testing that is required. I've had a look and from what I can see, the information relating to packages i.e. names, objects within etc, is not something I can find.  Is this because the information is within the Appian system database or is there a plugin or functions available that I can use to gather this information? UI would consist of a drop down with all packages on that environment. Option to group 1 or more into a bigger package, perform 4-eye review on it and then send to devops.  I know this will need to be built etc but need to fig

Background: customer wants more fields to be shown in their record so that the Excel download would include them. One of those fields is 'country', which the CDT saves as an integer value which is matched with a country list in the cloud database (i.e. a value of 1 would be Afghanistan). To display the country properly in the record, I use one of our rules that fetches a datasubset containing the countries and then matches the country Id with the datasubset. It returns a text containing the country name in the user language and display correctly in the Record. However, what's odd is that when I download the Excel, for every record entry that has a value for country it will only display the name of the 1st Id that was matched. That means if the 1st entry is Germany, all subsequent entries will also be Germany although showing correctly in the online record. Has anyone experienced this before? What's the best approach to fix this? Thanks in advance for any help!

In 22.3 the "global search bar" has been centralized somewhat and pinned to the top bar of /Design, with added functionality, which is neat. However the "floating" bar invoked by pressing CTRL-Space is no longer "floating", meaning the CTRL-Space hotkey no longer works at all in a very important (to me, at least) use case: during pop-up dialogs (eg the deployment pop-up, missing precedents, etc). The way it worked before: even if I have a missing precedent checker or deployment window open, but still want to search for and/or open some object, I could just hit CTRL-Space and search:(from 22.2) Meanwhile, after upgrading to 22.3, we can see the "search objects" bar hanging out in the background but being completely useless even if I spam the CTRL-Space hotkey: I can't speak for others here, but I estimate that I personally used this functionality very often to look up and/or open objects I need even when in the middle of a pop-up dialog I don&

can anyone please give suggestion how to resolve this error ?

My requirement is to fetch the correct option for the respective question which is there in the database. So what condition i need to apply in choiceLabels() as am getting questions in the correct order only but only the option from the first row is getting repeated for all the questions. so i want first 4 data to go for 1st checkboxField() , next 4 to second checkboxField() & so on. local!data:rule!MWJ_qe_forQuestions(), local!option:split(rule!MWJ_qe_fetchQuizOptions(),";"), local!choose:{1,2,3,4}, contents: { a!forEach( items:split(local!data,";"), expression: a!checkboxField( label:fv!item, labelPosition: "ABOVE", choiceLabels:{ a!forEach( items:index(split(local!option,","),{local!choose},0), expression:fv!item,)}, choiceValues: { a!forEach( items:index(split(local!option,","),{local!choose},0), expression:fv!item, )},

Hi Array has 460 items which needs to be displayed in grid but only the first record was displaying among all 460 When calling this interface in the parent interface it is providing only the first records in the grid

Hi, I am working on the Mobile Pocket Library App and I am trying to modify the Book_Summary Interface. I get the following error when I add the ShowBookDetails rule with my record rule input as its book parameter. Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!cardLayout [line 12]: A card layout has an invalid value for "contents". The contents contain a component that is not supported in the card layout. Received: FormLayout I use the following expression just as the Appian tutorial specifies:  rule!ISBN_ShowBookDetails( book: ri!record ) Any assistance with fixing this issue would be extremely appreciated. Thanks so much!

Is there a way to configure the user filter in record for the field for which we are not storing the data in db

here am selecting different rows but it is displaying latest selection data for all selected rows, 

Hi All, Is  there any way to know how many users have logged into APPIAN in a point in time from the Appian cloud database(MariaDB). Regards, Arun Kondi

Hi I Have a requirement as to show the array of images in row with enable of scrolling.  How can i provide scrolling for this case?

An error occurred while trying to write to the entity "StudentEducationDetails" [id=d95007c3-ee01-472a-b90c-0dbf8570a6e0@5696, type=StudentEducationDetails (id=4074)] (data store: StudentBasicInformation). Details: javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: could not execute statement: org.hibernate.exception.JDBCConnectionException: could not execute statement: java.sql.SQLTransientConnectionException: (conn=468975) Data truncated for column 'StartYear' at row 1: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Data truncated for column 'StartYear' at row 1: java.sql.SQLException: Data truncated for column 'StartYear' at row 1 Data: TypedValue[it=4074,v={<null>,<null>,Jabar,B.tech,2017-11-01,2021-12-07,90,1,2022-11-28 04:30:00.0,NRT}]

anyone can you please help me for this qustions?

How can we compare now() with the date for example dueDate if its ON TRACK or OVERDUE?

Hi there, Is there a way in Appian of searching all the application objects for the objects which contain certain function or string? just like search/find function of those code editor. it will return the files/or even the location in the file. Best regards, Lin 

i have a requirement to generate the PDF through XSL-FO In table i have a text like 2000 characters in table cell without spaces i need to wrap that text  XSL Code: PDF:

Hi Everyone, I am trying to execute this Stored Procedure in Appian Maria DB  and unable to check how to declare variable in Maria DB. Please let me know if any thoughts, BEGIN  DECLARE COUNT1 VARCHAR(1) DEFAULT 'S'; DECLARE CUR2 ROW TYPE OF SDP_TEST;  DECLARE cur1 CURSOR FOR SELECT * FROM SDP_TEST;   OPEN cur1;        LOOP            FETCH cur1 INTO CUR2;            IF CUR2.id = 6            then          UPDATE SDP_TEST SET id=8,name='Peter',address ='USA',job='Analyst';         SET COUNT1 ='Y';            END IF;   &nbs

 Hi All, I have designed service back records and having some related actions added on it. Having this, i am using new component record action(a!recordActionField) on form to perform some actions.   E.g: Record A           Record B    My design :                                               1. I have interface designed and called on records summary on 'Record A'.     2. In Interface one of the section, i am calling actions of 'Record B' with record action component(a!recordActionField).     3. Now, problem Statement- every time i refresh summary tab/view, call goes to source integration of 'Record B' by record actions added.     It does seems standard behavior of ser

Hi, We are looking for a way to split a large document into small documents of size we want. Is there a way we can achieve this in Appian, please share if any Thank You

Hello guys, in my database ICH_Contracts i have information about my master contract saved in several attributes. In my process model this is saved as a porcess variable: contracts = [startYear=2023, startMonth=1, noOfOccurences=5, isCancelled=N, frequency=FRQ1, active=Y, createdOn=12/1/2022 4:15 PM, createdBy=jmaricl@jci.com, lastUpdateDate=12/1/2022 4:16 PM, lastUpdateBy=jlopeza7, contractType=CTYPE2, contractId=175, contractNumber=FY2300000176] I have a process variable which stores information about the child contract numbers: childcontractsnumber = FY2300000176_1; FY2300000176_2; FY2300000176_3; FY2300000176_4; FY2300000176_5 What i need to achieve is to add these child contract numbers to the contracts DB as new rows, where the contractNumber will be the values from pv!childcontractsnumber and the rest of the attributes will be just copied. So basically extend the contracts pv with these 5 new values. Can you please help me out with this? THanks

for certification exam, does it have exam fee?  what and all we need to prepare for exam. because we will be working on some concepts some concepts, we have not touched while working 

I have created a RPA process to log into a software on our internal network and take screenshots of a machines status and then sends those screenshots to a user outside of the network.  The bot is running unattended on a Virtual Machine.  When I have the remote desktop open, the screenshots take the image of the entire screen.  However, when I allow the bot to run unattended the screen resolution is too small to capture the whole screen (see attached images as examples).  The virtual machine is managed via VMware. Does anyone know how to increase the screen resolution of the bot on the unattended Virtual Machine?