mrc logo mrc logo
  • m-Power m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Solutions Solutions
    What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Inventory Management Mobile Apps ERP Enhancements Modernization Spreadsheets to the web MS Access to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs and Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Development Services Training Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • Build Process
  • Field Settings
Back to Manual

Field Settings

Using the Field Settings specification, you can delete, reorder, and edit the appearance of fields you have selected for your application.

field_settings

Deleting a Field

To delete a field from your application, check the box referring the field you want to delete and click accept. Notice that in the screenshot the Customer Number field cannot be deleted. This is because the field is a sequence key. Any field that is linked to a sequence, external object, calculation, SmartLink, or record selection cannot be deleted. Hovering over the delete icon will provide information detailing where the field is linked. You must remove these dependencies before the field can be deleted.

Re-Ordering a Field

Initially, fields will be listed in the order they were added.  To re-order fields, click "Re-Order". You will be brought to the following screen.

reorder_fields

Click and drag a field to re-order it.  Field order is listed from top-to-bottom.  The field at the top will  appear first in the finished application, and the field at the bottom will appear last.

Editing Field Appearance

While you cannot use Field Settings to change values or fields in the database, you can change their appearances in the application. Therefore, note that editing in field settings is not global, rather only application specific.

Field Description- This appears in the final application, and inherits its value from its global definition at the dictionary level. Set an appropriate description so that the end-users can understand the field.

Display- Set "Yes" if you want the field to appear in the application. Setting "No" will allow your application to use the field as necessary (such as in calculations), but not display the field to the end-user.

Length- Set the length of the field. The length includes the decimal places, such that 25.325 has a length of 5.

Decimals- Set the desired amount of decimal places. A blank in this column indicated your field is character based.

Number Format Code- Select the format used to display your data. For information on creating your own date or time format, click here.

(User Def- This option has been deprecated.)

Created: July 18, 2013 | Modified: June 12, 2017

Search


Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

DB2 Advanced Build Process Reports mrc-Productivity Series Retrieval Tomcat Performance App Properties Maintainer Maintainers Database Graphing Retrievals Video Calculations Email Summaries Form Validation Compiling Parameters Popular Getting Started Excel Dates Data Dictionary Freemarker Report Java m-Painter Administration Production Record Selections SQL Prompt Screens External Objects Bar Graphs Application Properties Graph Properties Dropdowns Graphs RPG Admin Security Bootstrap Templates

See all tags »

michaels, ross & cole, ltd. (mrc)

Privacy Policy Cookie Policy Cookie Settings Notice at Collection Do Not Sell or Share My Personal Information

mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566


© 2024 mrc. All rights reserved.