Log In

Log In



Not registered yet?


Reset password Activation link
Forums
Tag "column"

First Field in a Table

Publication date: August 8, 2018

Is there anyway I can see the first field (in my case the name) as a scroll across the screen? As I scroll right, I cannot not see whose record I am on. Sorry for so many questions tonight…I’m trying to figure out how to easily edit records without going into each record.

Column header mismatch

Publication date: August 8, 2018

The field “Project Title” in our Project form is listed as “Deal Title” in the Records view. How do I get it to match? When I try to change it from either view (form or records), it shows the correct value (Project Title) and will not update.

forms

Publication date: August 8, 2018

its it possible to make 2 colums in form

Regards

Ron

Records display

Publication date: August 10, 2018

How do I hide and/or re-order the columns that appear on the Records screen for a form?

I have tried modifying the checkbox options in both Form Settings —> Fields and Table Settings —> Columns but none of my changes are reflected anywhere.

As an example, I would like to hide the Salutation field on the Contact form from the Records view for the form (https://mytaskhelper.com/apps/baW6lcImnhfOo8W6FdSrSK/dtypes/entity/chW7ddLmniW7PZsmkrW4m2).

Please advise.

Improvement

Publication date: August 10, 2018

Dear Sir or Madam:

First, I wanted to thank you for making the improvement regarding the search function. Hitting “enter” instead of the search button has made things much easier. Thank you.

Second, I was curious if another improvement could be made. I notice that the search function is pretty much limited to a cell by cell search of the document. If I wanted to search for all “Florida” cases and within that subset look for all “drugs” cases, as far as I know, this is not currently possible. Is it possible to improve the search function to allow for searching two separate columns for key words?

Thank you in advance for any help you might lend me.

Regards,
s.matt

Struggling to find tutorial Videos

Publication date: August 13, 2018

Hi

I cant find many video tutorials on youtube for the new version of MTH and I need a lot of help ;-(
Am I looking in the wrong place?

We are looking to create a database that will do the following

We are calling on prospects to offer them a new heating boiler for their home

We collect the data, then do certain checks. Once the checks are completed and the customer is approved we then send out a surveyor to inspect the property. Once the survey is done then we send it to the installer. Once it is installed then the lead generator is paid

We need for the:-

For agents to add leads to a database (i worked this out :-) )
For agents to view their own leads and status only (not that of others)

I would like to take the 1st 4 characters of their business name and add an incremental number to make this their ID. Can this be automated?

When the agent logs in and adds leads in the lead data entry form I would like to automatically add their agent ID. Or even add from a drop down box if it can’t be added automatically

How do you capitalise the letters automatically?


For admin to go in and allocate the leads to a lead manager ( the lead manager only sees their leads)
for the lead manager to book a date for a surveyor –
For the surveyor to see his booked leads with addresses
For lead manager to then allocate to an installer – Installer only sees installs allocated to them

In the data entry forms is it possible to have Multiple columns?

So for example:
Mr David Testing
rather than
Mr
David
Testing

We would like to have 2 columns for some of the fields like their name. Also telephone and email horizontal rather than vertical

I Cant find out how to link in the source – Agency ID to the lead data sheet



Controlling Column Size

Publication date: August 14, 2018

Is there a way I can control column sizes for an iFrame integrated table? I’m seeing how I can do it within MTH but ideally, I’d like to be able to control tables sizes in the embedded table too.

data import

Publication date: August 14, 2018

keep getting message that I can not import data because 2 fields have the same column name. however, each column name is unique.

Column Data, Fill Down

Publication date: August 15, 2018

Is it possible to select an entire field/column and update all selected fields with the same new value? e.g. changing field “due data” from 12/31/2012 to 12/31/2015.

possible relationship?

Publication date: August 15, 2018

I am struggling to figure this out during my trial. I have business clients that make purchases from multiple vendors. At the end of the year I get a spreadsheet from each of the vendors showing of how much each of my clients spent with each vendor. It basically has the client name and their purchase total. So I want to be able to upload the vendor spreadsheet and in turn the client database show the client’s name and how much they purchased from each vendor based on the data that is in each of the vendor reports. So for example if I have ten clients and each purchase from apple, microsoft, and google…the record would show the following columns…client name, their microsoft purchase amount(from the microsoft uploaded spreadsheet), their apple purchase amoutn(from uploaded apple spreadsheet, their microsoft purchases.. etc.

Column alignment

Publication date: August 15, 2018

Can one left, centre or right justify columns

How to resize columns

Publication date: August 15, 2018

To change the column’s width you need only a mouse.
See below:

Spreadsheet

How to add IP column to the table

Publication date: August 15, 2018

To add an IP column to a table you need to activate this option in the Forms menu. Find the link Advanced options at the bottom of the form and click on it. Select IP.


See the screenshot
IP column

How to enable Created at, Updated at, IP and unique ID columns in your table

Publication date: August 15, 2018

In order to enable ‘created at’ or ‘updated at’ columns just go to Fields menu.
At the bottom of the page you’ll find ‘Advanced options’. Click on it to expand additional options.
And you’ll see the columns you can enable to show on Records page.

You can enable Created at, Updated at, IP and unique ID columns. Please, see how below:

Show Total at the bottom of the column

Publication date: August 15, 2018

Hi!

Please, see below how your table will look if you enable Total for the number or formula fields.



Show Total at the bottom of the column



To enable this option, please, click on the ‘Default’ link for a Number field or ‘Edit Formula’ for a formula field.



Show Total at the bottom of the column



I hope you’ll find it useful!

How to disable columns on integrated database

Publication date: August 15, 2018

Hi!

Please, see below how you can show or hide columns in your integrated database. It may be useful when some of the columns shouldn’t be shared with everyone, i.e. should be disabled.





Hope it helps!

Importing

Publication date: August 15, 2018

I have successfully imported 4 databases with no problems. Now I’m trying to build a 5th one, but I keep getting this error msg: “First line should be column names. After import they will represent field names”. I see that at the top of the Records page all the column headings are there.

I don’t know if I did anything different this time. I can manually add records, but cannot IMPORT. I erase the project and began over again. The same problem. I have tried importing only one line, or 67 and the same problem.

I was also getting an error msg that I had two columns with the same name, but I did not.

I was also getting some very strange things imported before this problem. Text that did not come from me.

IndianaMilitary Project – 28th Division

Lines

Publication date: August 15, 2018

Is there a way to put vertical lines between columns ?

And is there a way to change the default width of a column ?

Great service- Thanks

Reminder based on a date in the past

Publication date: August 15, 2018

Hello,

I’m trying to create new reminder based on a date in the past, for example if I enter today’s date in a column then
I would need to receive an e-mail reminder after two days. I thought of creating new column with a formula which
calculates the date and I used “+” operation but the result is just the date with the number added as text and not
a new date (with today’s date plus 2 days).

Best Regards
Dawoud

File Downloads Are WRONG

Publication date: August 15, 2018

Thanks for changing the way the export works.

However there is a major issue. The linked columns are not being included in the downloads. This makes the data corrupt and not useful.

Changing display column name

Publication date: August 16, 2018

When TABLE SETTINGS DESIGN COLUMNS have been set and a DISPLAY NAME updated the widget view is fine,
however if fields are then edited the DISPLAY NAME reverts to default, requiring each field column to be done again.

Linked column order

Publication date: August 16, 2018

Basically, the drop down box MTH provides for a relational field sorts the data into its own order depending on the content of the link field.
This disregards the sort order of the originating form.

Limit Date Acceptance on a Form

Publication date: August 16, 2018

I have a form for Leave where the blokes fill in their first day off work and their anticipated return to work date. How would I generate a pop up message and stop the form processing if they entered a date between a black out period?

In other words if I want to say in May no leave every year. Regardless of when they apply between 1st of May and 31st of May the form wont process and pops a warning which I can customise to say no leave during this period?

Various Issues All Day - Now cant search

Publication date: August 16, 2018

We have been having numerous issues most of the day. Most are things like not updating, and having to double enter to get records in. Tonight I am trying to do a single criteria search for records I know are there and it is returning no records repeatedly.

Unwanted Empty Column in Form

Publication date: August 16, 2018

I went into Customize/Integrate to resize a form used on a web page. Originally the only “design setting” applied to the form was the standard Grey 3d template. The changes i entered were a Table height & width and iframe height & width. I decided i did not like how this looked and wanted to default back to standard Grey 3d design. I deleted the Table/iframe height/width entries and updated and when i did a new empty column was displayed in the form. I cannot remove this form and the only thing i notice different on this form from another identical form that i didn’t change is that the radio buttons for the Table/iframe height/width are still selected. Help?

Column Sorting Issue

Publication date: August 16, 2018

When I try sorting records in online table by date column it returns a mixture of lines with empty data cells combined with those that have data but not in the correct order. For example: 16 Dec 2014 then 6 Dec 2014 then 15 Dec 2014 and so on. So the feature really loses its sense as I would have to go through all records anyway.
I can attach screenshot but not sure how to do it here..

Widget Font Issue

Publication date: August 16, 2018

The method of font control within MTH css file does not seem to allow a specific column of a widget to have bold font variant of change the font size.

Can't see all columns

Publication date: August 16, 2018

I have one form which has a great number of fields. I am pretty sure when we first started with MTH that I could scroll to the right and see ALL the columns in records. Now I can’t do that anymore.

I can only see some of the columns and then it cuts off on the right side in the middle of a column.

Can this be fixed please? Thanks!

RECORDS IN EDIT VIEW PROBLEMS

Publication date: August 16, 2018

Please see link

https://mytaskhelper.com/images/data/bBkJHXJCrbWBQBbXgAbWaz/csdgG9W6XciykLAGFcGCoE/REPORT%20EDIT.jpg

i can’t see my other columns on my records. please help me to work it well. thanks

How to create a 5 column report?

Publication date: August 16, 2018

I saw something about css, but its not clear how to create a table with just 5 chosen columns.

Please advise.

Regards
Paradigm

No "All Records" link in View mode

Publication date: August 16, 2018

Hello Igor

I noticed that if Edit is enabled in online module, when you click on any number in the View column it shows the records but there will be no “All” link on top to come back to all records (like in Edit disabled mode)

Thank you

Artem

Sortable database relationship column headers

Publication date: August 16, 2018



The relationship column headers are not sortable (a-z, etc). It would help me if in the database results the relationship columns were sortable.

Thank you,
Russell

Manually set widget table's column size

Publication date: August 17, 2018

Hi,

it would be great to be able to manually set column width in table widget.

Ability to Drag Fields

Publication date: August 17, 2018

I understand that we can use the CSS line to create columns in our Forms, but this is a bit tricky during development. It would be easier if we could drag them into columns as we can drag their order now.

Multiple Column Drop Down

Publication date: August 20, 2018

It would be very handy to be able to show more than one column in a drop down box. Perhaps two or three columns as an option would be nice.

So instead of seeing:

Stock Number

We might be able to see:

Stock Number and Stock Description

Or perhaps:

Stock Number, Description and Price


For example

Column Width

Publication date: August 20, 2018

It would be nice to be able to drag column widths to adjust how they appear in the listings.

Hierarchical pick-lists

Publication date: August 20, 2018

Consider a simple use case: We want Sector – > Industry. First question is how to setup tables:

1. A single table with two fields, and for every industry row we list the associated (parent) sector?

2. Two single-column tables, Sector and Industry, with Sector an N:1 connection to Industry?

Given the data, here are standard implementations we would like to see:

A. You select Sector from a pick-list, and then the Industry pick-list is populated with values in that Sector.

B. You get a single tree/hierarchical pick-list where you can expand/collapse a sector. Advantage here is you can multi-select industries and — if implementation is really good — industries and sectors.

(One key feature of a hierarchical pick list is the ability to multi-select. So, for example, if I multi-select two Sectors I want to then see (and potentially be able to select from) all Industries in both Sectors. It’s elegant if done in a tree control; acceptable if done in adjacent multi-select controls.)

Column Totals

Publication date: August 20, 2018

I like the column totals ability, however, I do not like the totals format. I am entering only integers into the fields, but the column totals display as decimals. Is there some way to be able to choose integer or decimal totals?

Column order

Publication date: August 20, 2018

It would be very useful if we could setup column order to be shown on the records page.

Currently the order is determined by the position of the field at the form, but sometimes the information we need to see more often is requested at the middle or end of the form.

It would be easy to change the form arrangement but it turns out that most of the time it’s not the best solution because of the form’s logic.

For example, if you are interested on due date, then you should be able to set due date’s column at the beginning of the records, but you wouldn’t ask for a due date at the form if you don’t have the general information of the task first.

If you need extra information, I’ll be glad to provide it!

Line Colours in Online Database Table

Publication date: August 20, 2018

As we continue using our database and the number of records increases the need for a new feature arose.


Would it be possible to have each line in online database table to be coloured differently depending on a value of a certain field of each particular record ?


This will be useful to anyone working with clients.


Example: The line of a certain record in a database table (online) will show in red if “renewal date” filed value is less than current date; will show green if “renewal date” filed value is more than today’s date.


Example 2: The line of a certain record in a database table (online) will show in red if “status” filed value contains word “pending”; show green if “status” field value contains word “completed” etc.


A combination (“or”/“and”) of just 2-3 conditions could turn it into a very powerful tool that would dramatically increase efficiency of work.

Imagine opening database and seeing at a glance what needs your attention on the fist place…

Accountants will LOVE it !

Sort after Grouping

Publication date: August 20, 2018

Is it possible to sort the columns after grouping on a particular column?
I have various accounts on line and group them according to their name but the records are all over the place instead of being sorted chronologically. I would like to do a reverse sort on the date.

Group and filter by lookup field

Publication date: August 20, 2018

It is currently not possible to Group or Filter by lookup column. It only shows relational column in Search.

Average at the bottom

Publication date: August 20, 2018

Hi!

I’d like to see Average works the same as Total.

I.e. so I can use it in charts, show at the bottom of the column etc.

Thanks!

Update: I need to be able access average and sum in a way such that they show up as continuously updating in charts.

Re-sort all columns

Publication date: August 20, 2018

We need re-sort all columns function. In case user think that records shows in wrong order. This method will re-sort all form columns.

Search for Mulitple Criteria on Same Column

Publication date: August 20, 2018

I need to save a view with a search that excludes two different criteria for the same column. For example: I want to show all the donations we receive for 2011 that are NOT Adoption Donations and are NOT Store. Right now, I can add additional criteria, but only from another column. Thanks!

Show Hide Columns in Saved Views

Publication date: August 20, 2018

We would like to have the ability to show/hide some columns in a saved view. Especially since Andrew was kind enough to explain how to pull a column from another table using a formula. (Thanks Andrew!)

Some tables contain many columns, but we don’t need to see all of that info at all times. Horizontal scrolling can be inconvenient.

Thanks for giving us a way to ask for features. MTH Rocks!

Pagination Options

Publication date: August 20, 2018

Hello Igor

I just realised that Pagination only gives maximum of 200 records per page. Is it possible to add “All Records” option to it.

It it very important especially in line with Total of the column feature. I’ll explain. If I set numeric column to display Total at the bottom and there are more than 200 records in a database, there is no chance for me to display total of all records, since Total feature will only adds up displayed items (20, 40, … or 200 maximum) and not all of them..

So the only way out is to either show all records on one page or ask you to change the way Totaling at the bottom works. First option is easier I believe.

Thank you.

Total of the Column calculation automated

Publication date: August 20, 2018

Dear Andrew and Igor

It is great to discover that you are actually responding to suggestions and trying to do your best to suit customers needs.

One more feature that is missing for me.

You have an option to find out the Total of the numeric columns, which is great. But you have to press it manually (and also total can not be found in Formula column).

What is missing for me is to have the Total added automatically at the BOTTOM of specified column (and ideally with the word “Totals:” at the bottom of the first text type column for example), just like in MS Access.

And if you also add a feature to do at least single calculation between columns as well (say Total column 1 – Total column 2) and placing it below Totals as “Grand Total”, then the system will be outstanding of all other ones for sure.

Best regards,

Artem

Option to hide "View" collumn in online module

Publication date: August 20, 2018

Hello Andrew

One more feature that would be useful.

It would be great to have an option to hide the collumn “Viev” in online module of Database table.

Effectively, if Edit is enabled, pressing Edit link in the last column does the same (or even double the job). The data is not edited until Update is pressed anyway, but having “View” link as well confuses our employees and takes extra width space online.

Also, an option to show column “Last Updated” online would be very useful. (should it be a separate topic though?)

Many thanks.

Artem

Row Heading

Publication date: August 20, 2018

I gave a class today to 7 people from the organization (Christian Friends of New Americans – CFNA) for which this database supports. There were 2 suggestions from then – one follows:

Since there may be many records on a page and there may be many columns per record, when a User scrolls to the right, they may not remember what this record is for (e.g., which “Contact”), so, they have to scroll left to determine this.

Please devise a way to “freeze” the “row” heading (like they can in a spreadsheet) such that, when they scroll right, this row heading always shows. Like a spreadsheet, ideally, they would be able to select which columns to “freeze”, e.g., Last Name, First Name, etc.

Column Heading

Publication date: August 20, 2018

I gave a class today to 7 people from the organization (Christian Friends of New Americans – CFNA) for which this database supports. There were 2 suggestions from then – one follows:

Since there may be many records on a page and there may be many columns per record, when a User scrolls-down a page, they may not remember what a particular column is for, so, they have to scroll back up to determine this.

Please devise a way to “freeze” the column heading (like they can in a spreadsheet) such that, when they scroll-down, this column heading always shows.

Finding Duplicates

Publication date: August 20, 2018

I suggest a function “FIND DUPLICATES”, based upon the user’s choice of column. Example: “FIND DUPLICATE” in column “NAME”, where there are more than one record with identical names.

Thanks

Sorting database search results and some other features

Publication date: August 20, 2018

- A counter which counts the number of hits (after a search action) would be nice

- It ain’t possible to select the same column as the one in the first criterium (add search criteria in the widget) although that should be possible.

- Once you have the search results they can’t be sorted: the sort buttons sort the whole database and not only the search results