JS in Data Entry Application

"JS in Data Entry Application" Doc in this DirectoryThere are 63 docs under this directory.Create a Doc in this Directory
JS to refresh the current page
Author:ayuan0625      Create Time:01-19 17:21      Tag:      Edit:13 Times    |   View:883 Times

Summary:I.Overview1. Expected effect1) Example 1: Data entry and refresh successfully2) Example 2: Data verif[Full Text:]

JS realizes data entry linkage and generate default value
Author:ayuan0625      Create Time:03-03 17:51      Tag:      Edit:17 Times    |   View:527 Times

Summary:I. Overview1. Problem descriptionWe hope to realize that based on the data entry linkage, after selec[Full Text:]

JS sheet Switch Sheets via Radio Button Group Widgets
Author:ayuan0625      Create Time:02-17 20:29      Tag:      Edit:14 Times    |   View:397 Times

Summary:I. Overview1.1 RequirementIn multi-sheet switch, users may feel difficult to select labels accurately[Full Text:]

JS Disable the Delete Row Button When Only One Row is Left
Author:ayuan0625      Create Time:09-14 15:28      Tag:      Edit:10 Times    |   View:537 Times

Summary:I. Overview1.1 Expected effectIn a form, if only one row of data is left, that row of data cannot be[Full Text:]

JS Check the Checkboxes on All Pages in Data Entry Mode
Author:ayuan0625      Create Time:03-13 00:13      Tag:      Edit:14 Times    |   View:456 Times

Summary:I. Overview1.1 RequirementIn Data Entry mode, data will be displayed in several pages if there are hu[Full Text:]

JS Sound Alert for Data Entry
Author:ayuan0625      Create Time:05-16 15:12      Tag:      Edit:22 Times    |   View:420 Times

Summary:I. Overview1.1 Problem descriptionWhen filling the form, if the content being entered does not match[Full Text:]

JS Summarize the Data of Checked Checkboxes and Make Judgement
Author:ayuan0625      Create Time:03-01 09:28      Tag:      Edit:11 Times    |   View:414 Times

Summary:I. OverviewWhen using checkboxes, sometimes you may have to add a limit on the number of selected che[Full Text:]

JS Get the Last Edited Value
Author:ayuan0625      Create Time:11-17 17:18      Tag:      Edit:13 Times    |   View:387 Times

Summary:I. Overview1.1 Problem descriptionSometimes report users want to get the last edited value for verifi[Full Text:]

JS Remove the Prompt Box of Data Validation
Author:ayuan0625      Create Time:02-24 09:58      Tag:      Edit:12 Times    |   View:438 Times

Summary:I. Overview1.1 Problem descriptionWhen data verification is performed on the form, a verification err[Full Text:]

JS Display Specific Sheet in Multi-sheet Report
Author:ayuan0625      Create Time:05-15 09:08      Tag:      Edit:14 Times    |   View:387 Times

Summary:I. OverviewIf there are multiple sheets in a report, the first sheet is displayed by default after pr[Full Text:]

JS Create a Progress Bar for Importing Excel
Author:ayuan0625      Create Time:02-24 11:05      Tag:      Edit:13 Times    |   View:450 Times

Summary:I. Desired EffectWhen using Excel to import data, the progress bar is required to be displayed, as sh[Full Text:]

JS Limit the Number of Checked Options in Checkbox Group
Author:ayuan0625      Create Time:11-17 17:12      Tag:      Edit:16 Times    |   View:546 Times

Summary:I. Overview1.1 Problem descriptionWhen making a form, sometimes it is required to limit the maximum n[Full Text:]

JS Adjust Column Width During the Preview
Author:ayuan0625      Create Time:02-24 17:33      Tag:      Edit:15 Times    |   View:850 Times

Summary:I. Overview1.1 Problem descriptionBy default, when the report is previewed, the column width cannot b[Full Text:]

JS Scroll to the Bottom or Right of the Browser Automatically
Author:ayuan0625      Create Time:02-28 21:54      Tag:      Edit:13 Times    |   View:379 Times

Summary:I. Overview1.1 Expected effectIf the template adopts Data Analysis Preview or Data Entry Preview, bec[Full Text:]

Change the Background of a Cell in the Row Where the Checkbox is Located
Author:ayuan0625      Create Time:02-21 10:24      Tag:      Edit:12 Times    |   View:504 Times

Summary:I. Overview1.1 Problem descriptionWhen filling a form, after checking the checkbox, change the backgr[Full Text:]

JS Execute Query using Widgets for Data Entry
Author:ayuan0625      Create Time:02-28 14:48      Tag:      Edit:17 Times    |   View:551 Times

Summary:I. Overview1.1 RequirementWhen designing a report, how to execute a query using widgets for data entr[Full Text:]

JS Highlight selected sheet
Author:ayuan0625      Create Time:02-17 10:45      Tag:      Edit:17 Times    |   View:367 Times

Summary:I. Overview1.1 ProblemWhen we have a report of multiple sheets, the selected sheet label is not obvio[Full Text:]

JS Radio button group middle and center aligned in cell
Author:ayuan0625      Create Time:02-23 16:26      Tag:      Edit:10 Times    |   View:367 Times

Summary:I. Overview1.1 ProblemWhen the cell is large, the radio button group widget will not be centered hori[Full Text:]

JS instances of data entry report
Author:ayuan0625      Create Time:11-17 16:35      Tag:      Edit:23 Times    |   View:646 Times

Summary:I. OverviewWhen in data entry, it is often necessary to use JavaScript for secondary development of s[Full Text:]

JS Change font color when editing
Author:ayuan0625      Create Time:11-23 19:09      Tag:      Edit:5 Times    |   View:529 Times

Summary:I. Overview1.1 ProblemMany report designs use dark colors as the background. Although the font can be[Full Text:]

JS Hide or Display the Parameter Panel
Author:ayuan0625      Create Time:03-04 15:25      Tag:      Edit:13 Times    |   View:411 Times

Summary:I. Overview1.1 RequirementHow to display the parameter pane when switching to the first sheet and hid[Full Text:]

JS Get the Returned Value of Data Entry
Author:ayuan0625      Create Time:11-17 17:22      Tag:      Edit:20 Times    |   View:620 Times

Summary:I. Overview1.1 RequirementWhen performing data entry in a report, we often wish to know whether or no[Full Text:]

JS Return Custom Error Message after Submitting Data
Author:ayuan0625      Create Time:11-17 17:21      Tag:      Edit:22 Times    |   View:611 Times

Summary:I. Overview1.1 RequirementHow to pop up the error information and accordingly decide what to do next,[Full Text:]

JS Keep title centered when scrolling
Author:ayuan0625      Create Time:03-09 08:21      Tag:      Edit:9 Times    |   View:376 Times

Summary:I. Overview1.1 ProblemWhen the report scrolls horizontally, sometimes we want the title to be always[Full Text:]

JS Display image according to the item hovered by mouse
Author:ayuan0625      Create Time:11-17 17:19      Tag:      Edit:23 Times    |   View:472 Times

Summary:I. Overview1.1 ProblemWhen in data entry, sometimes user hopes that when item is hovered in the drop-[Full Text:]

JS Get the Values of Certain Cells in Rows with Checked Box
Author:ayuan0625      Create Time:11-17 17:16      Tag:      Edit:18 Times    |   View:914 Times

Summary:I. Overview1.1 RequirementHow to get the values of certain cells in rows with checked checkboxes in a[Full Text:]

JS Click Radio Button Pop Up a Dialog Box to Enter Value
Author:ayuan0625      Create Time:11-17 17:11      Tag:      Edit:15 Times    |   View:1139 Times

Summary:I. Overview1.1 RequirementIn making a report template similar to a questionnaire, there may be a coup[Full Text:]

JS Set Values for Expanded Cells
Author:ayuan0625      Create Time:11-17 17:09      Tag:      Edit:15 Times    |   View:841 Times

Summary:I. Overview1.1 RequirementUsually, we use setCellValue("cell", null, value) to se[Full Text:]

JS Assign Values to Report Widgets
Author:ayuan0625      Create Time:11-17 17:08      Tag:      Edit:14 Times    |   View:443 Times

Summary:I. Overview1.1 RequirementWhen the value of a certain widget has been edited, dynamically assign valu[Full Text:]

JS Confirm Before Delete Row
Author:ayuan0625      Create Time:11-10 14:47      Tag:      Edit:22 Times    |   View:653 Times

Summary:I. Overview1.1 RequirementWhen users perform row-based data entry, FineReport will provide users with[Full Text:]

JS Get the Row Number of Cell Currently being Edited
Author:ayuan0625      Create Time:11-17 17:14      Tag:      Edit:14 Times    |   View:566 Times

Summary:I. Overview1.1 RequirementShow the row number on the top when editing any cell in the row.1.2 Solutio[Full Text:]

JS Hide sheet page
Author:ayuan0625      Create Time:02-15 14:18      Tag:      Edit:10 Times    |   View:662 Times

Summary:I. Overview1.1 ProblemIn view of the fact that there are many sheet pages to be reported, some sheet[Full Text:]

JS Set report/toolbar to be unavailable
Author:ayuan0625      Create Time:02-21 09:26      Tag:      Edit:30 Times    |   View:369 Times

Summary:I. Overview1.1 ProblemIn our report development, in many cases it is necessary to set the report body[Full Text:]

JS Get all values of extended widget
Author:ayuan0625      Create Time:08-04 09:07      Tag:      Edit:13 Times    |   View:416 Times

Summary:I. Overview1.1 ProblemWhen a data entry report is displayed, the reporting widget is extended. A[Full Text:]

JS Hide Columns or Rows by Clicking a Button
Author:ayuan0625      Create Time:02-24 13:40      Tag:      Edit:19 Times    |   View:922 Times

Summary:I. Overview1.1 RequirementWhen performing data entry, how to hide certain rows and columns by using a[Full Text:]

JS Text Control Displays Style After Editing
Author:ayuan0625      Create Time:02-27 12:56      Tag:      Edit:12 Times    |   View:421 Times

Summary:I. Overview1.1 Problem descriptionThe use of conditional formatting allows cells or text widgets to d[Full Text:]

JS realizes dynamic display/hiding of rows
Author:ayuan0625      Create Time:02-26 13:28      Tag:      Edit:10 Times    |   View:340 Times

Summary:I. Overview1.1 RequirementIn making a filling report, how to make optional items invisible when[Full Text:]

JS Dynamically Display Current Time
Author:ayuan0625      Create Time:07-05 09:22      Tag:      Edit:26 Times    |   View:767 Times

Summary:I. Overview1.1 RequirementThe report only display static current time by inputting formula. How to di[Full Text:]

JS Initial Button Color,Change Color After Clicking
Author:ayuan0625      Create Time:02-24 10:46      Tag:      Edit:19 Times    |   View:529 Times

Summary:I. Overview1.1 RequirementWidget CSS and Button CSS can be used to change the CSS style of a certain[Full Text:]

JS Change the Background Color of the Selected Cell
Author:ayuan0625      Create Time:02-26 21:08      Tag:      Edit:13 Times    |   View:474 Times

Summary:I. Overview1.1 RequirementIn report production, sometimes in order to highlight the cell selected, it[Full Text:]

JS Button color change according to mouse hover
Author:ayuan0625      Create Time:02-10 14:56      Tag:      Edit:10 Times    |   View:374 Times

Summary:I. Overview1.1 ProblemWhen the mouse is hovering over the widget for the first time, it changes from[Full Text:]

JS Edit widget on click once
Author:ayuan0625      Create Time:04-06 08:10      Tag:      Edit:11 Times    |   View:432 Times

Summary:I. Overview1.1 ProblemWhen there are many widgets in one report, to enhance performance, sometimes we[Full Text:]

JS Mark the Modified Cells When Data Entry
Author:ayuan0625      Create Time:04-01 11:15      Tag:      Edit:14 Times    |   View:413 Times

Summary:I. Overview1.1 Problem descriptionScene description: In the Data Entry Preview, after editing the cel[Full Text:]

JS Modify a Column Value of Selected Rows at One Click
Author:ayuan0625      Create Time:03-08 23:54      Tag:      Edit:12 Times    |   View:406 Times

Summary:I. Overview1.1 RequirementIn some cases, we need to select a batch of records and then modify values[Full Text:]

JS Refresh the Parent Window after the Child Window is Close
Author:ayuan0625      Create Time:02-17 10:55      Tag:      Edit:16 Times    |   View:1526 Times

Summary:I. Overview1.1 RequirementWhen performing data entry in a particular project, we might have to jump t[Full Text:]

JS Length limit of text in widget
Author:ayuan0625      Create Time:02-26 23:22      Tag:      Edit:11 Times    |   View:343 Times

Summary:I. Overview1.1 ProblemIn our reporting process, when the text length exceeds some specific value (for[Full Text:]

JS Mouse Over Cell(Row) Style Change
Author:ayuan0625      Create Time:03-23 09:26      Tag:      Edit:15 Times    |   View:691 Times

Summary:I. Overview1.1 RequirementIn making a report, in order to highlight the cell the mouse moves over, we[Full Text:]

JS Change the Background Color of the Checkbox Selected Row
Author:ayuan0625      Create Time:02-14 09:13      Tag:      Edit:14 Times    |   View:1507 Times

Summary:I. Overview1.1 Problem descriptionScenario description: When we enter data, sometimes we need to chan[Full Text:]

JS Get the Value of the Widgets in Expanded Cells
Author:ayuan0625      Create Time:02-24 10:21      Tag:      Edit:11 Times    |   View:406 Times

Summary:I. Overview1.1 RequirementWhen conducting data entry preview, how to get the value of the widgets for[Full Text:]

JS Refresh the Parent Page After the Child Window Fills in
Author:ayuan0625      Create Time:03-01 19:48      Tag:      Edit:8 Times    |   View:718 Times

Summary:I. Overview1.1 RequirementWhen using multiple windows for data entry, you may want to make the data t[Full Text:]

JS Title text remains centered
Author:ayuan0625      Create Time:03-18 18:48      Tag:      Edit:13 Times    |   View:325 Times

Summary:I. Overview1.1 ProblemWhen making some wide reports, the width of the report far exceeds the wid[Full Text:]

JS Select All the Checkboxes
Author:ayuan0625      Create Time:10-22 18:57      Tag:      Edit:1 Times    |   View:751 Times

Summary:I. Overview1.1 RequirementWhen using our checkbox widgets, how can we click to check all, so that the[Full Text:]

JS Dynamic star rating
Author:ayuan0625      Create Time:08-07 16:02      Tag:      Edit:5 Times    |   View:316 Times

Summary:I. Overview1.1 ProblemIn the report application, we may use graphics to display the effects such as s[Full Text:]

JS Get the number in the string
Author:ayuan0625      Create Time:03-09 12:42      Tag:      Edit:6 Times    |   View:345 Times

Summary:I. Overview1.1 ProblemWhen making a report, sometimes it is necessary to directly obtain the number i[Full Text:]

JS cpt Refresh a Single Cell or Column
Author:ayuan0625      Create Time:04-28 10:50      Tag:      Edit:17 Times    |   View:608 Times

Summary:I. Overview1.1 RequirementRefresh a cell or a column of cells in real time in the data entry mode. Th[Full Text:]

JS Solves Component Value is not Refreshed on time
Author:ayuan0625      Create Time:03-10 16:49      Tag:      Edit:10 Times    |   View:363 Times

Summary:I. Overview1.1 RequirementIn making a report, button widget is often used to handle values. The curre[Full Text:]

JS Customize the Prompt Text
Author:ayuan0625      Create Time:03-02 21:58      Tag:      Edit:17 Times    |   View:413 Times

Summary:I. Overview1.1 RequirementIn FR reports, prompts indicating whether or not an operation succeeds are[Full Text:]

JS Assign a Value to a Cell by Clicking a Button
Author:ayuan0625      Create Time:02-28 11:42      Tag:      Edit:10 Times    |   View:405 Times

Summary:I. Overview1.1 RequirementHow to assign a value to a cell by clicking a button? 1.2 SolutionAdd[Full Text:]

JS Sets Widget Focus
Author:ayuan0625      Create Time:02-23 13:26      Tag:      Edit:14 Times    |   View:456 Times

Summary:I. Overview1.1 RequirementIn making a report, sometimes the Text widget is disabled by default and ca[Full Text:]

JS Insert Customized Number of Rows
Author:ayuan0625      Create Time:02-21 13:30      Tag:      Edit:9 Times    |   View:442 Times

Summary:I. Overview1.1 RequirementIn many cases, by clicking [Insert Row], only one row will be inserted. How[Full Text:]

JS Assigns Multiple Values to Text Box
Author:ayuan0625      Create Time:11-17 17:10      Tag:      Edit:14 Times    |   View:397 Times

Summary:I. Overview1.1 Problem descriptionFor the Data Entry template, it is hoped that the data of a certain[Full Text:]

JS Get or Modify the Value of a Cell which is Bound with a Widge
Author:ayuan0625      Create Time:11-17 17:07      Tag:      Edit:11 Times    |   View:562 Times

Summary:I. Overview1.1 RequirementHow to get or modify the value of a cell through JavaScript, as shown below[Full Text:]

JS Custom Button Style
Author:ayuan0625      Create Time:07-31 11:36      Tag:      Edit:14 Times    |   View:455 Times

Summary:I. OverviewIn applications, it is often necessary to modify the style of a button. In addition to mod[Full Text:]