0I am new to javascript goes without saying. I am developing a form in Adobe Experience Manager. My problem is I need to compare the date from a field in Table1 (Item.eff_date) to a field in a table called index (m_date) to get the value of a field (m_index_fuel) and place it in Table1 in the field monthly_index. The tables are both dynamic and have a field called num that is incremented by the script adjust.fuel_adjust.Table1._Item.addInstance(1);m_index_fuel is always the first day of the mont...

My form tracks contract dollars paid and change orders added. both change orders and payment tables are dynamic flowed subforms. When I add more lines to one or the other that exceeds the page limit the following happens: the left table pushes the right table to the next page when the left table exceeds the limit. Also if the right table overwrites the left table when it exceeds the page limit. Each is in its' own subform and each is Flowed, Western Text, Allow Page Breaks within Content and use...

I have an Excel sheet with lookup tables that I need to convert to a fillable PDF. I am currently using AEM 6.4 to develop the form. I cannot use an external database, the form has to be portable for use by field personnel. I am not new to scripting, but I am not a programmer, this is out of my wheelhouse. Any help is greatly appreciated.My form consists of the following:A user facing page that allows the user to enter values in an expandable table called adj_table. The column I need to use as t...

I currently use a spreadsheet to do calculations for payment. In this spreadsheet I have set up a table with pipe sizes descriptions, etc. and I use vlookup to access this data. I am now converting the spreadsheets to forms using livecycle and need to understand how I can set up the same in LiveCycle. the data have 2 variables, size and type. Once the pipe size and type are selected (pipesize is a direct entry, pipetype is a dropdown list) I want to be able to access pipedesc, pipepayitem, and p...

I am reposting this one, as I am still trying to figure this one out. I am trying to set up a form where the numeric format of one field is based on units of measure in another field. The fields are: units1 and iq1. What I want to do is have the iq1 field format for percent with two decimal places when units1 is LS or ls or L.S. or l.s. otherwise the field should be formatted for a number with the format nnn,nnn,nnn.nn. Any help for this newbie is appreciated.

I am reposting this one, as I am still trying to figure this one out. I am trying to set up a form where the numeric format of one field is based on units of measure in another field. The fields are: units1 and iq1. What I want to do is have the iq1 field format for percent with two decimal places when units1 is LS or ls or L.S. or l.s. otherwise the field should be formatted for a number with the format nnn,nnn,nnn.nn. Any help for this newbie is appreciated.

I am trying to set up a form where the numeric format of one field is based on units of measure in another field. The fields are: units1 and iq1. What I want to do is have the iq1 field format for percent with two decimal places when units1 is LS or ls or L.S. or l.s. otherwise the field should be formatted for a number with the format nnn,nnn,nnn.nn. Any help for this newbie is appreciated.

I have a form that has a date field (DateTimeField1) that I want to make a series of 7 checkboxes (named Sun, Mon, Tu, Wed, Thu, Fri, Sat) dependent on. The checkboxes are on top of a series of letters representing the days of the week (ie: S M T W T F S). What I'd like to do is take the user selected date in DateTimeField1 and have the appropriate checkbox display an 'X' to indicate the day of the week. I have searched the forums and cannot find a solution or even a starting point. I am not a p...