Log In

Log In



Not registered yet?


Reset password Activation link
Forums
Tag "table"

new window

Publication date: August 8, 2018

What is the meaning of this function in a report/table

Field Names in Table View

Publication date: August 8, 2018

Is there any way to have the field names stay on the screen (or freeze like in Excel) so that I can see the field names as I step down through the records?

Enable in-place editing in Table for all fields

Publication date: August 8, 2018

Question: I have this enabled but edits I make in Table mode do not save. What am I doing wrong?

LOOKUP

Publication date: August 15, 2018

IS THERE A LOOK UP FUNCTIONALITY TO ASSOCIATE FIELDS FROM OTHER TABLES?

Controlled Access

Publication date: August 9, 2018

HI.

I now have tried your customer portal access model. One question:

Is it possible that data within one table can be linked to / protected for a single user for input, maintenance and visibility?

E.g. a projects holds tables with data which should be visible to all users and data that should for a single user only.

Thanks
Michael

Multiple data from linked table

Publication date: August 15, 2018

Hi.

I am currently in trial mode testing your solution.

One questiion: when linking 2 tables I’d like to mark multiple opportunities for one kind of data.

For example:

Table 1: Names (Peter, James, Paul)
Table 2: Destinations (US, China, Germany)
Table 3: Travel History:
Name=Peter (from table 1)
has been to the follwowing Destinations = (China & US) from Table 2

I did this by using the advanced field type = “Relationship”, but user can only pick one destination from table 2 and not multiple
How to achieve this?
Thanks a lot,
Michael

Record view opening in new tab

Publication date: August 9, 2018

When clicking on a table entry to view all the data it’s opening in a new tab, can I turn that off and if so where is that located?

Thanks!

Send information from one form to different record tables depending on selection

Publication date: August 15, 2018

I have a form for creating student results and when filing out that form I would like the record to be sent to different forms depending on the selection from one of the fields in the original form. For example, we have students in year 10, 11 and 12. We have learning outcomes (student results) for year 10, 11 and 12 but we would like to be able to have each entered result split into different forms. So when filling out the form, If select year 10, the record will then be sent to the year 10 form etc.

e-mail notification problem 2

Publication date: August 9, 2018

Hi Igor,

I am using some reports, I allow data to be changed with a table widget.
the table widget redirects to form widget.
in the form widget I have e-mail field.

I would like the person changing the data, and leaving his e-mail address, to receive a notification of his changes.

I can’t find how.

only the normal notification is working. see attachment.

thanks in advance

Robrecht

How can I make it so all administrator-level users are able to edit charts?

Publication date: August 10, 2018

Just wondering if there’s a way I can have all the users I have registered as Administrators be able to create and edit charts as they can do with reports. Right now, when under their login and editing a chart, only the integration tab is visible, not the settings tab.

how to link two tables

Publication date: August 13, 2018

Hi please let me know how to link 2 tables.

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



Download feature

Publication date: August 13, 2018

Great application. Everything I need. However, it would be great to have a download as pdf or excel feature on the table, instead of export.

table widget

Publication date: August 13, 2018

HI,
is there a way to allow filtering on 2 topics in a report widget.
example in my pipeline database.
2 customer names, or a customer name and an account manager’s name?
now I can only filter or sort.
Thanks
Robrecht

Text inherit

Publication date: August 13, 2018

Hi Igor,

I created a new form and under Widgets > Table, I noticed the field text does not inherit the format of the field label (attached screencap). Is there something I’m missing?
Thanks.

Field editing

Publication date: August 13, 2018

I would like a “comments” field to display in a table where only that particular field is editable and not the entire record. Ideally, I’d like people to be able from the web to be able to add and not subtract information from that field. Is that possible?

Formatting Inquiries

Publication date: August 13, 2018

Hello Igor and team,

Thank you for your previous help… much appreciated.

I have a couple of questions if you don’t mind.

Q1 (attached screenshot) – when trying to export PDF in the Record table that I made in Arabic, I get the letters all scrambled up. I tried using the Language icon in the records builder to switch the language to Arabic, but no luck. The Excel seems fine and so does the Print option. Only extorting to PDF seems to not work.

Q2 (attached screenshot) – when reviewing the Record table with a picture inserted, the picture doesn’t take a bigger size. Clicking on it opens the original size, but I’m trying to have a single records sheet printed with the picture bigger and more visible. I edited the image size in Forms > Upload > Advanced Options, but no matter the size I set, it only affects the Embedded Table Preview, not the Record that I created. Is there a way to make the pictures bigger in the Records table?

Thank you so much for your help.
Tamer

Login in an update form

Publication date: August 13, 2018

Hello,

I reach out to you once again to see if you could help me with an issue. I’m trying to validate a user before he could update a record in a form. Let me explain myself I’m creating a sort of workflow in wich users register services request, and vendors place bids for their services. In order to do this I created a table for the Services and one for the Vendors so they registre themselves.

I created a form in a report in wich Vendors can only update a field called Bid (wich is the amount for completign the service) and then the user can accept the service or not. The problem is that I need the vendor information to be registred in this report but this must be validated (probably with a Login form) but I don’t know how to link this to forms.

In a simple way, I want to make a user Log In before they can update a record form another table, and also in this table to keep registred who updated it last.

I’m having a hard time trying to explain what I need so if you have further question in this case, please contact me.

Regards,

Javier Aquique

Filtering drop-down menu by user

Publication date: August 14, 2018

Is there any way to filter a drop-down menu by user on a form?

I’m building a simple sales management app for a client and would like the users to add companies to a single form and then only be able to select from the companies they have added on a Sales Activity Update Form.

I have accomplished basically the same using the Login Query Engine on an editable table — but would like to add that same type of filtering functionality to a form.

Any help?

Thank you,

Russell

Showing several columns

Publication date: August 14, 2018

Hi,
Thanks for all your help.
Working on my application I run into a problem following the post “How to link forms in MHT
At the end of the note is: “In order to show several column’s data from linked table you can create Formula field and select this field in ‘Select display field’.”
I’m sorry, but how?. I can’t find that Select display field in Formula field.
Thanks again.

Filter on report widget lost

Publication date: August 14, 2018

Hi

when using a table widget in which the user applies a filter…
he can click on a record to update.
when the record is updated and he wants to go back to the table, the filter is gone.
is there a way to keep this filter please?

thanks

Robrecht

Front end integration

Publication date: August 14, 2018

Please, explore Widgets section in order to integrate form, table, login or google map widgets.
You’ll find the codes to share your forms via direct link, iframe, JavaScript or API.

Need Assistance

Publication date: August 14, 2018

Dear Sir/Madam,

i am looking to build a request form of several services which i provide. The Customer is to select the required service via a TABLE.
Therefore, I am looking to make check box which means he select the main service (each service has a cost which means each select box is a value)
then after selecting the main service the customer to add the details of the selected service via a table
he will add a raw for each additional service. which is a drop down box (as each check box is a main service, thus each check box has a drop down button. and each one has a value)
at end he will see how much is the selected service.

i had made a mock sample of required form (used excel) hope this will help you to assist me to my requirement. i don’t know how to do an add button, i only places a “+”
)
Thank you and best regards
Ahmed

Filtered Results Embed Code

Publication date: August 14, 2018

Hello,

I’m a little new to MyTaskHelper so apologies if this is a dumb question! I’m looking to create a job board for my website, of which I want to access embed codes for filtered results.

So for example, I want to have the full job board on the front page of the site, but I will have pages for each individual country for which the jobs are available, so I want them to click on the country page and be able to view the filtered results already. I saw on the forums that this feature seemed to be added in 2011, but I can’t figure out how to do it!

Thanks,
Alyssa Chassman
hello@theidhouse.com

Is it able to search using the system generated updated or created timestamp as criteria?

Publication date: August 14, 2018

We can configure to show these fields in the table, but in the search panel, we can’t use these fields as search criteria.
More often than not, we want to utilize these timestamps to find out the freshly updated/inserted records, instead of using a date/time input field, which can be wrongly set by the user.

Help please - web page query form + display record

Publication date: August 14, 2018

I have created a simple (test) Orders database using your system.
Now I want to create a form on my website where a customer can enter an order number and order date, then they can view the details of their order on the same web page or a different web page on my site.

Please can you tell me how to do this.

Thank you

Marcia Levinson
marcia@vitalityforbusiness.com

Replace our access database

Publication date: August 14, 2018

Hello

We are trying to replace our access database for our inventory/invoice/purchasing system

We need to have tables/cells that can be edited and sub tables shown on the UX… is this possible?

Sincerely,
Rishi

Drop-down fields and look-up tables

Publication date: August 14, 2018

When using a look-up table with a drop-down field — how do I set the first choice as “Choose One” — Do I have to add that as the first entry in the table?

Caspio, forms, tables, videos

Publication date: August 15, 2018

Hi team,

There are few questions :-

Can I manage my sql tables ??
Can we see our tables in MTH ??
Can I create forms ??
Is it similar to caspio ??
Can you send me your video tutorial ??

I basically wanted a tool from where I can create application without knowing coding.

Thanks
Mohit

Copying existing csv database to MTH and creating a table for my website page

Publication date: August 15, 2018

I have a database that includes PDF files and ZIP files along with other information that I would like to transfer to MTH. I’ve imported them and created a table but it shows up as text. I want those who visit the website to be able to open the files on the website. Do the files need to be saved using a MTH form or can I import them directly to the table so I don’t have to manually populate the table? I am not a programmer and have no programming skills or background. The reason I am looking to change is because of the complexity of the current system that was created by a programmer and my inability to manipulate it.

export to excel from table widget

Publication date: August 15, 2018

How and where do I define e-mail address to which exports are sent? (per report if possible)

filter view of data

Publication date: August 15, 2018

I work with several users, entering their own data in the same table.
How can I set up the users (or table) in such a way that each user only can read and modify the data he/she entered?
(and doens’t see data from other users)
Thanks

Setup a relational database

Publication date: August 15, 2018

I’d like to setup a relational database

Input say a badge number and the detail from another table is pulled into the current form – ( typical relational database).


I’m trying to figure it out.


Thanks

-Pat.

How to change database iframe size and database table size

Publication date: August 15, 2018

Please, see how to change the database table size and database iframe size.



Database table width, database table height

Short instruction:


1) Go to the Customize & Integrate module.

2) Open the Database tab.

3) In the Database design menu find the following options:



Table Width

Table Height

IFrame Height

IFrame Width



4) Enter the values you need and click on Update.


See the screenshot below:


How to change database size


Database iframe size, database table size


Hope it helps!

How to enable the "allow end user edit database records" feature

Publication date: August 15, 2018

Please, see below how to enable the “allow end user edit database records” feature.

1) Go to the Customize & Integrate menu.

2) Open the Database tab.

3) In the Actions menu select the Allow web user to edit database records item.





Hope it helps!

How to truncate long text

Publication date: August 15, 2018

In MTH you can truncate a long text. Go to the Form menu and select the field you need. Click on the link Default and in a pop-up window enter characters amount you need to show in a database table. The other text will be truncated.


Please, see the screenshot:

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!

Is it possible to link tables?

Publication date: August 15, 2018

Igor,

I can see how you can create multiple data tables under one project.

Can you link the tables to one another into a relational database?

Or is this a tool for only dealing with flat files?

Thanks,

Maria Korolov
President, Trombly International

Add a Table to the Form

Publication date: August 15, 2018

How can I add and use the Table control on my form?

Create a separate web form

Publication date: August 15, 2018

I have successfully created a database, and it is great !! Many Thanks. (An old Dabble user).

Question: I see my database as a table just the way I want it.

http://mytaskhelper.com/apps/bhLJkjgUDkC6TksXAHswbc/widgets/cDjuykImfiP4wjU_jV4sHg

But I’d like to create in addition, a “form” that would allow a viewer to submit information – fill out a form, and email it to me. NOT automatic inclusion into the database.

I found your Contact Me example, but when I try the Form Builder, all it does is modify my headings in my database. I want a form totally separate from the database.

Search Issues - Please, enter search keyword.

Publication date: August 15, 2018

HI

When users try to search within a table – they always get the following message! Please, enter search keyword.

Search has been fine up until today? it also works fine for account owner, any ideas please?

Thanks

multiple relationships

Publication date: August 15, 2018

I read there can only be one relationship between tables but does that mean can there be more than one many-many relationship for a table.
I want to have a structure that is like “parent-child- grandchild” where the relationship of the child table is many to many in both directions. When i try to do this the forms are not available from the drop box. Also when looking at the page forms for my database there are no relationships showing – the only way to make these appears to be by making a new field?
it looks different on the screencast.
Thanks
Matthew

email table

Publication date: August 15, 2018

Hi there. the email that is sent after a form is completed is missing info from 1 of the field. See below


Modules being submitted |4. Which Module are you submitting? |

I cant work this out, can someone help me please.
Thank you
Ben

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.

Special Character Display Issue (like '<' or '>')

Publication date: August 16, 2018

The characters within ‘<’ and ‘>’ including these two characters are missing in the table or record view, but when I edited the record, they just reappeared. It seems there’re some issues handling escaped characters in table or record.

Problem with importing CSV file to create a Table/Form

Publication date: August 16, 2018

Hi,

I’m unsure as to what the root of the problem is but when I try to test the DB out by importing some of my CSV files, it won’t import and I would like to find a resolution to my problem.

May it be because the file size or the number of input data is too much?

An example CSV file is attached below for reference. Attached is the most populated of the bunch that didn’t import properly.

Thank you very much

Merge Two Tables to Report?

Publication date: August 16, 2018

Is there a way to merge two different tables to create a report?

Move Created At Field On Table

Publication date: August 16, 2018

The Created At is easy enough to turn on and off. However I am wanting to relocate the created field to the front of the records. This is for consistency with the normal hand written records and the expectation of the Health department in my jurisdiction.

Thanks

Importing records with a relationship field

Publication date: August 16, 2018

I’m having trouble importing CSV records when one of the field headers is “Select XXXX”. That field imports as empty, even when the data matches a record in the linked table.

How can I import tables with relationships?

Thanks

All Linked Fields Are Blank

Publication date: August 16, 2018

Not sure what has happened overnight.

All linked tables fields in our forms are not showing any content.

So we have a drop down to select staff name. This is saved in time card. The time card uses a relationship to link in staff name. Staff names were working fine yesterday. This morning they are all blank. As is every other relationship field in every single form.

This is urgent. I have staff starting in 20 minutes

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..

Pagination and design glitch

Publication date: August 16, 2018

Use the pagination tool to go to Next Page and you will notice that the table background colour is dropped and instead of custom dark row colour this is replaced with white.

Happens with Fire Fox and IE10.

Relationship Issues

Publication date: August 16, 2018

I am having a problem linking tables I have imported from Excel. One relationship works but others do not, despite being created the same way. I have four tables. Table A, B, C and D.
Table A has a one to many relationship with B and C.
Table D has a one-to-many relationship with C.
The one is a unique field.

SMALL PROBLEM (not urgent)

Publication date: August 16, 2018

I have sorted below table by the date field “Next Renewal”:

link hidden

No matter what I do but the record with an “ID” field = 2237 never gets sorted correctly and appears in the wrong place. The “Next Renewal” vale of this field is “05 October 2013”

Can you look at it for me, please ?

Display Database on Mobile Device

Publication date: August 16, 2018

I am looking to imbed a database on a mobile website, but can’t get it to display correctly. I have tried setting the table width to 640px but it doesn’t seem to reflect that.

PDF Export - No "Table" View + Missig Field

Publication date: August 16, 2018

I noticed that when using the PDF Export, that if I specify “Table” View, instead of “Individual” View, then, it doesn’t send any email at all, as it does if I just specify “Individual” instead.

Also, with “Individual”, many of the records shown do NOT include the first field “Last Name”.

Sorting database table by date

Publication date: August 16, 2018

The sort (ascending and descending) function does not seem to be working properly with dates. I sort my table either way and get pretty mixed up orders instead of sequential.

Resizing database results table

Publication date: August 16, 2018

Did something happen to the ability to resize the database results table? It seems to not be working.

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

Linking Fields and drop down menu from different form

Publication date: August 16, 2018

Hi, I would like to enable a field, to choose options from a field in another form/table. I thought this could be done through relationships, but it seems not.

Eg, The field Car_colour from Car db, would be chosen come from colours table.

All the colours would appear as records in the colours table.

Then in the Car db, when you arrive at the Car_Colour field, a drop down list would appear with records from the colours table.

Please advise

Relationship Drop-down Function

Publication date: August 16, 2018

I use the relationship function to create drop-down menus that connect different tables, so that one level of user can add data that other users choose from when they fill out a form.

For instance, one of my applications may have a “Department” Form and an “Activity”
Form that will allow the top user to add departments and activities — and the departments and activities that are added are then included in another form where users choose from a (relationship) drop-down the relevant department and activity they are reporting on.

The problem I have is that in each record the chosen department and activity then show up unnecessarily as links to other details. Is there some way I can disable the link and just keep the static data?

Drop-down for Ref. Table not Labeled in Edit

Publication date: August 16, 2018

In the “edit” mode (in contrast to the “View” mode), a record that is linked to a value in a reference table via a drop-down field is shown without a label (it does show a label in “View” mode).

Export not = Backup

Publication date: August 16, 2018

If I exported all the tables in my database, this is not a backup. If for some terrible reason, MTH went out of business, these exports would not help me determine which of the records in a “reference table” should be linked to its associated “main” table, since the “primary keys” and “foreign keys” are transparent.

Drop-down Field in Reference Table

Publication date: August 16, 2018

When I VIEW a Record or set of records which are joined to a table that has a drop-down field in it, the value that has already been set in the drop-down field does NOT show, unless the User clicks the drop-down. This is not acceptable in a VIEW mode, e.g., if I were to show others all or a subset of the ContactInfo Records and scroll to the right to show the “Language” table’s “Name” field, an EMPTY-looking drop-down appears for ALL these Records – if a drop-down for a Record is clicked, then the previously set value will display, but, this should NOT be necessary to do – in the VIEW mode, the previously set values for these drop-down fields should display automatically (if muliple values are set, then, all of these previously set values should display – either on the same line, seperated by a seperator character, or, via multiple lines).

Joins

Publication date: August 16, 2018

The MAIN reason that I chose to use an online database was to be able to JOIN tables, in order to significantly reduce the redundancy of the legacy spreadsheet files.

I’m still having issues with joining tables in MTH for a 1-to-many relationship, and, I need your help for this, before I schedule a class for several others who need to learn how to use MTH.

I have tables that I want to JOIN, as follows (please help me do so ASAP):

1 Contact HAS ONE (or none) Tutoring Driver

1 Tutoring Driver HAS MANY Contacts


1 Contact HAS ONE (or none) Non-LCMS-Church

1 Non-LCMS-Church HAS MANY Contacts


1 Contact HAS MANY (or none, or one) Phone No.

1 Phone No. HAS MANY (or one) Contacts


1 Contact HAS MANY (or one) Languages

1 Language HAS MANY Contacts


Also, it’s important that any of these reference tables (Tutoring Driver, Non-LCMS-Church, Phone No., Language) may have mutliple fields that need to be shown, e.g., the Language Name & the “Native” Indicator, and the Phone No, & Phone Type. I need to add more tables that need to be joined with a 1-to-many and many-to-many relationship.

Also, when I export the “ContactInfo” Records, IF the “Contact to Phone” or the “Contact to Language” relationships were actaully a 1-to-many type, then how could this data be exported to 1 spreadsheet, e.g., a Contact with multiple Languages or Phones?

Re-Import After Relationship

Publication date: August 16, 2018

After I import a spreadsheet to a table, and, after I relate that table to another one, I’d like to be able to re-import a modified spreadsheet to update the first table, without losing any of the vlaues from the linked table.

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.

Forms to Tables

Publication date: August 17, 2018

One of the features I think would be very handy would be to able to have more than one form for entry of data to the same table. I don’t think this is possible now.

In my specific instance I am thinking of testing we do and testing the client does.

It would be nice to be able to offer the client the ability to input their test result and we already input our test result into the same single table. However, as currently configured I cant do this. The way we enter the information the staff name is recorded being one of our staff, the client staff wouldn’t be in our system therefore they would perhaps enter their initials or something and so on.

SQL Bulk-updates for records

Publication date: August 20, 2018

Right now if we want to make a large update to existing records it appears the most efficient way is to export the table, clear it, apply the update externally, and then reimport the table.

Can SQL be exposed for power users to update existing records?

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.)

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 !

Move Edit/Delete

Publication date: August 20, 2018

When using a table, be able to put the edit and delete buttons onthe left side of the screen instead of the right.

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.

CSS to create table for checkbox section

Publication date: August 20, 2018

Hi,

I created a submission form that is shown on this page:

http://about.seasonwithspice.com/2011/05/submit-your-recipe.html

The last section of the form is a question with 10 checkboxes. Instead of all 10 in one column, I was hoping to spread them out over three columns.

I tried the CSS code example provided on MyTaskHelper, but it doesn’t seem to work for checkboxes.

Thank you for any suggestions you can provide!

Best,

Reese & Mark

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!

Rating System and Comments

Publication date: August 20, 2018

Any plans to add the ability to create a star rating system like maybe Amazon’s? Where, if we created a table for website viewing, a user could rate each item on the table? Thanks!

Add New Record link

Publication date: August 20, 2018

Igor

Is it possible to add an option to have “Add New Record” link on top of the Editable Database table, next to Pagination for example, or before it. Clicking on it would show Add New Record form below the table OR in the same Window as the Whole New page.

The above would eliminate the need to always have both Database and Form links at hand.

Will be extremely handy !

Thank you

Artem

Pagination Link

Publication date: August 20, 2018

Igor

It would be very useful to have Pagination links also at the bottom of the table and not just on top of it.

Then users will not need to scroll all the way up to got to the next page. And it will look more presentable as well.

Thank you

Artem

Label placement property for Edit Mode

Publication date: August 20, 2018

Hi

First of all would like to thank you for the excellent product and trully GREAT customer support.

I have few vital things that are missing for me in Customize and Integrate module however.

Here is one:

Online Form properties have an option to set Label placement (Top aligned, Left aligned, Right aligned), however, Database Edit form (which looks exactly the same) does not have it and when I press Edit in Database Table online (if enabled of course), the same form is shown only in Top Aligned mode on default and there is no way to set it for Left Aligned (which is nicer and more organised).

I would really need this to be configurable as well.

Many thanks,

Artem

In line Entry of Table Data

Publication date: August 20, 2018

Hi

is it possible to allow the table fields to be edited without the popup window appearing – other field types currently allow it.

The pop-up window is not intuitive and consequently we found it difficult to use (I am sure others are smarter than I am, but not everyone :-)

Best regards

John

Ref. Table Drop-downs on Records Page - Show "Not Linked"

Publication date: August 20, 2018

On the “Records” page, there may be drop-downs for a linked Reference table. Currently, if the User would like to know which of the Records in the “main” table are not linked to this Reference table, there is no method for this. Please add some indicator to this to allow the User to request this info.

changing table size in database widget

Publication date: August 20, 2018

how can i change the table size and the font size as well in my database widgets?

I need to fix the table on the iframe i used in my webpage all in 400×400pixel i frame with no scroll bars.