Log In

Log In



Not registered yet?


Reset password Activation link
Forums
Tag "records"

Extracting, filtering and removing records using the REST API

Publication date: August 20, 2018

Hello – I would like to an SSIS C# script component to extract form data, on a daily basis using the JSON REST API. How would you suggest retrieving only the new new records added since the previous extract? Is there a way to filter the records? How can I remove the records retrieved in bulk? Do you have any code examples?

Thank you!

Davie

Received 401 Unauthorized response with REST request

Publication date: August 8, 2018

I am trying to fetch all form records using the documented pattern ‘/apps/APP_ID/dtypes/entity/ENTITY_ID.json’ in Java 8, with Retrofit2, and Gson to handle JSON stuff, but I received 401 response no matter how I try.
The complete URL can produce valid response in Chrome browser, but receives only brackets([]) in Safari.
I tried to set an API key in the body, but the Retrofit framework complained that body is not acceptable in a GET method. That seems to violate the specifications of HTTP 1.1.
Then I tried to use POST method instead, got the same 401 response.
I have no idea. Is there any operational sample written in Java?

Forms

Publication date: August 8, 2018

Dear SIr/Mdm,

I had created a form bulider, however, how could i limit that the search on the form builder must totally match to our records data-base in order to show the database record?

Thank you.

How to have Action triggers once, but not on all Record Edits?

Publication date: August 8, 2018

Hello,

Anyway to prevent “Actions” to run only once and from re-triggering after a record has been edited? I have trigger for when a File field is “not empty.” Anytime that record is edited, the Action gets runs again if a file has already been uploaded.

Is there a way or Condition that only triggers if “on change” or something like that? I also tried an extra validation field in the Action conditions (yes/no) but since its value is saved it is only useful for the initial edit.

1) Anyway to run Actions once per-record or prevent from running
2) Anyway to reset a form field to a value – regardless of what was saved in the record?

Workflow to help: Person X submits initial form → Person Y receives notice from Allow End-User Edits Notification, and uploads a file to that record via Edit Records → Action is triggered by the file being uploaded to the record and email sent to Person Z

Record URL in after SUBMIT

Publication date: August 8, 2018

Hello,

Is there anyway to supply the record URL to the Submit Notification after data has been saved?
|More| , |Unique id| and |Database_record_id| with no results.

Goal: Once a form is submitted, Notification details sent and ideally the recipient has an easy Link to go directly to the record to make changes. In our case, to attach a file to that record.

Thank you

Portals

Publication date: August 8, 2018

Hello,
When I enter into a Form from my Portal Suscriptores always go to Add a new record ¿How I can go to Search a record?
Thank you

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?

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.

Moved form - lost data

Publication date: August 8, 2018

Hey, I moved a form from one project to another and seem to have lost all my records in the process. The form appears blank!

The form was a list of philanthropic donors who have given to our charity. The data is incredibly valuable. I do hope this hasn’t been lost!

A screen shot suggests that the information is still in the system somehow, but it’s appearing blank.

Help??!

Multiple Record

Publication date: August 8, 2018

how to add one record.
whenever i add a record, the application save multiple records.
need some guidance

Functionality

Publication date: August 8, 2018

When a widget/form is published on a website and a record is submitted, does that record populate in the main database?

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!

Search from Portal View

Publication date: August 9, 2018

Hi,
When I search the Portal on all of my data (whole table) and it returns results, all the data in the records found is editable. Is there a way to turn that off?

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.

I'd created a form, but need to query the data from a website.

Publication date: August 10, 2018

I am a new user needing to know where to go in setup to create a form (with embedded code) for a website to enter data into a single field and return the results of this query showing all results. It’s probably simple, but couldn’t figure it out. Thanks. Hopefully, this could be helpful to new subscribers.

'Add' link on relationship fields

Publication date: August 15, 2018

Is there a way to remove/hide/disable the ‘Add’ link underneath a relationship field if you want to prevent users from creating new target records from within the base record? For example, if I wanted to ensure that Players are only created through the Player form and not through the Team record, is that possible?

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.

Email newsletters

Publication date: August 10, 2018

Is there a way to link sent emails to records? For example, if I have a Contact form with an email address and send a newsletter to 50 of my contacts, is there a way to see all sent newsletter history in each Contact’s record?

Thanks!

Editing from Records page

Publication date: August 10, 2018

Hi,

Is it possible to edit records from the records page, or do I have to open an individual record to edit it?

I particularly want to edit drop down lists in particular fields, with all records on view.

Thanks,
Ben

"Back" button and other issue

Publication date: August 13, 2018

Hello MTH,

One persistent bug that I have encountered is with the “back” button. To recreate the issue, go to our database and enter the search term “Florida.” The second entry (at least in this moment) is Yoanly Savon. Click on the #2 on the far left. After going to the page, then click “back.” The page that you return to is the original home page, not the “Florida” search results. Is it possible to rectify this?

The other issue is more straight forward. When I enter a search term like “Florida,” I’d like to be able to hit “enter” and see the results, but the program necessitates hitting the “Search!” button. Can this feature be added?

Thank you for all of your help.

Regards,
S.Matt Read
GREY2K USA

Display more in table

Publication date: August 13, 2018

Is it possible to display more than 10 records in a table on one page?

record filtering by user

Publication date: August 13, 2018

Is there a way to filter records by user. I have a database with records initiated by a single person but assigned to suppliers. When suppliers login, I only want them to see the records of their company. Can I do this?

Access rights

Publication date: August 13, 2018

Hi,
I’m experimenting a little to see what I could do with MTH.
I haven’t manage to find how to set user-specific rights to see certain rows or columns other than defining that a user can see only his/her own records or all records.
We have projects where we define in the beginning of the project which of our employees and our customer contacts should be able to see the status, comments, details and files of the project, regardless of which team member has added the comments, details or files. Then it would be good if we could design the view presented to employees to look a little different than the views presented to the clients (The clients should not see all columns/fields).
Can this be done in MTH?
Best regards,
Björn

RE: Duplicate entries in database

Publication date: August 13, 2018

Dear Sir or Madam:

I am finding duplicate entries in my database after entering a search term. To recreate the issue, set your search for “ALL” “like” “drugs” in the three search lines. Hit enter. You should see 657 rulings.

I transcribed all of the rulings into an excel file and have been finding dozens of duplicates. What I’m noticing is that anything above 500 tends to be a duplicate. I have confirmed that I have not accidentally entered the information twice (though I’m sure this is still a possibility, generally speaking). The database itself is reporting duplicates after a search.

For example, ruling #39 (of 657) and ruling #514 (of 657) are the same. I’ve confirmed that this ruling is listed a single time in the database, but it shows up twice in the list when I enter the above search terms.

Can you help me out with this?

Thank you,
S.Matt Read
GREY2K USA

Reports of specific records can't seem to be used as data sources for charts

Publication date: August 13, 2018

Hi,

I’m attempting to use a report of a database that was through specific search, meaning I only have a few of the total entries that are in the full database actually in the report. When I attempt to use the report as the data source in a chart, however, I get no bars in the bar graphs, also no lines in the line graphs above 0, either. Still, when I use the entire database for that same specific form as the data source, it will show the graphs correctly each time.

Any thoughts on this issue I’m having?

~David

Form date submission

Publication date: August 13, 2018

Hi Igor,

Under Forms > Fields > Advanced Options, I enabled “Created At” and “Added by” to be shown in the Records, however I don’t see those fields after checking them (attached screenshot).

Is the option to automatically add the date of the form submitted working? Couldn’t find “Added by” either.

Thanks!

End user to be able to update just some records

Publication date: August 13, 2018

I need a end user to be able to update just some records, and not all of them.
The rest of the records must remain unseen for the user.
Is it possible to manage that?

Read and Write Team members and Create Database button

Publication date: August 13, 2018

A quick question — why is the green Create Database button visible when team members with only read and write permission log in? It distracts the user from the records they are intended to use.

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

Lookup & Filtering

Publication date: August 15, 2018

Team records can be filtered by a user. For instance students added by each user can only be seen by that user (and the administrator in records). But if records are accessed in a relationship drop-down those records are not and cannot be filtered so that the logged in user can only select from their “added by” students. Is this correct?

Added by filter

Publication date: August 13, 2018

Would it be difficult to enable the added-by filter to recognize and filter records added by the Administrator, also? Or is there a workaround I’m not seeing?

Search Form

Publication date: August 14, 2018

I want to make a form that I would integrate into a web page that would ask for a last name and then list records showing that last name in my dataset.

I can see how to make a search report that has the specific terms I set for a search, but I want one that allows the user to fill in a search item.

Ned Benton

field enters field name instead of content

Publication date: August 14, 2018

HI,

for some reason , when people enter data, the system returns the field name as data.

I made a survey, made a copy in several languages. the problem appears in all languages.

see example. question 7D, 7E, 9 …

Thanks

Robrecht

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

New user, first form

Publication date: August 14, 2018

Hi,

Tried to populate new form with a .csv file.

Upon completion got a prompt “No Forms found, Add One!”

I have no idea where to go or what to do… Oh, I tried this twice with the same result… HELP!

I hope the attached screen shots will give you a clue as to where I made my error(s)

Thank you, I really am looking forward to using your software.

Harold Clements
haroldclements@gmail.com
1-415-532-6055

Fetch report records REST API

Publication date: August 14, 2018

I tried to fetch the report records using the documented API URL and query parameters, but the MTH server seems to reply the whole table every time, instead of the report which filters out some of the records.
I’ve checked the log of my program and the formulated HTTP GET request is:
https://mytaskhelper.com/apps/search/dtypes/entity/search.json?rest_api_key=[my_api_key]&database_name=[my_db_name]&form_name=[my_form_name]&view=[my_view_name]
Some of the parameter values have been replaced with bracketed holders in order to protect sensitive information.

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.

Formatting of Forms

Publication date: August 15, 2018

Just started using the program and enjoy it a lot.

I’m wondering if it is possible to format forms with dropdown, radio, and check buttons horizontally instead of vertically tosave room?

Also in the Form Records Viw is it possible to increase the font size of the data to make it easier toread.

Thanks for any help.

Testing newsletter + import procedure

Publication date: August 20, 2018

Dear support :-)

I’ve tried sending out a test-newsletter but it did not arrive. Am I cleared to be able to send such a newsletter or is there still something I’m supposed to do before I can do this?

Secondly, I also have troubles importing CSV-files. All info of the record is put into one field per record.
When importing, I am also used to seeing the ability to link certain category names from one file to categories of the other.
Obviously, I don’t understand you’re approach to this and look forward to learning more about this.

Many thanks,

Garsett
Belgium

Records updated email

Publication date: August 15, 2018

Dear MTH team,

Yesterday we made a change to the format of the subject line for the email notification on record create. This change worked great but when records are updated the email that is sent is still sending with the old format. I believe this is due to only the subject line being changed and the standard email sent on updates does not use the same format. Is there a way for us to customize the email subject for records that are updated?

RENEWAL

Publication date: August 15, 2018

Dear Sir or Madam:

My name is S.Matt Read, and I’m the Research Director at GREY2K USA. We currently use My Task Helper to store public records in an online database.

Our last contract just ran out, so I’d like to renew. However, none of the options match what was on our last billing invoice. If you could help me decipher which option will simply be a renewal of our last contract, I’d appreciate it.

Our username is danielle@grey2kusa.org. My email is matt@grey2kusa.org.

Once I know which payment option to choose, I’ll log in and pay.

Thank you,
S.Matt Read
GREY2K USA

Bug between my records

Publication date: August 15, 2018

I am cleaning the data that I imported and I have discovered that several of the records are connected to each other and when I choose “select theater” for one, it changes the other. This is all in the Production Form. One of the entries for 16th Street Theatre is linked to one of the entries for Cabrini Repertory Theater. Another 16th Street is linked to Cafe de la Gare. There are two Cherry Lane Theatre entries that are linked, one to the Cleveland Public, another to Company One.

Please tell me how I can unlink these.

Thanks,
Elana

URL is limiting

Publication date: August 15, 2018

The field of URL is limiting. I have the correct website for the organization I am working with and I have added the http:// in front but it is still not accepting it.

This is the website: ActorsForChildrenTheatre.weebly.com

Please advise how I can record it accurately.

Elana

My Form

Publication date: August 15, 2018

Just checking on what I need to do for my form. Am I still in the free even though it is past 1 month? I think I can have up to 1000 records?
Thanks Deetta

Forms, Users, Records?

Publication date: August 15, 2018

In your pricing it mentions # of forms – is that like an entry app or inquiry app?

It mentions records so I assume that is total number of database detailed records of all types.

And finally, team users. I assume if I am the only tech I have only 1 user?

The internet audience would have complete access to enter data and inquire?

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!

Show records per page

Publication date: August 15, 2018

In order to change the number of records per page go to Records page and find Show per page DropDown. Please, see screenshot below.





Hope it helps!

How to remove all records

Publication date: August 15, 2018

To remove all records from the database go to the Records menu and find the button Delete all records under ‘Actions’ DropDown.
Please, see the screenshot below:


records

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:

Checkbox field creating multiple records

Publication date: August 15, 2018

I have a standard checkbox field on my Project form that is causing some issues when selecting multiple options. The field is titled ‘Associate(s)’ and if you select more than one Associate here, the system creates that many records of the Project form. In other words, if there are 3 associates selected for a given project, once I save, 3 duplicate projects are created. All I want to do is capture more than one associate name on a single project record. Can this be done?

add teammembers to database

Publication date: August 15, 2018

I cant figure out how to add team members to a whole database
the team menu is visible for forms or records -adding a team member only adds for that form
i dont want to have to add them individually
thanks for advice
Matthew

New admin cannot see records

Publication date: August 15, 2018

I just added a new user and made him an admin but he cannot see any of the records I’ve created. How can I fix this?

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.

User login

Publication date: August 16, 2018

How do you set up the database so that users can only edit their records?

Form Field in Email Heading

Publication date: August 16, 2018

I would like to be able to take a field from a record and stick it in the heading of the email that is sent when the record is created. This works in the body.

EDIT: Also, is it possible to place a link back to the new record?

Form Structure Varies

Publication date: August 16, 2018

The image on the left shows what we see when a User logs in to add or edit a record. The image on the right is what we see when someone links from a website.

Note that the fields are not aligned the same. If I change the left one, then the right one is not right.

Also, is there a way that Users can edit records that look like the image on the right?

As always, thanks.

https://mytaskhelper.com/images/data/btxTV1vGHiI4Ckm1CRK4B8/aqWPHDWRfcHOkXgvlcICkg/example.png

Visibility of field

Publication date: August 16, 2018

I have a field in one form linked to another. When I add a new record the field appears and the result shows up in the list of records. When I log in as my test agent, the field is not in the form or in the list.

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

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.

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

Trouble with big databases

Publication date: August 16, 2018

At the moment, there was a problem when adding new entries to the database with many records.
In the case of a long delay, you can perform resorting base (bottom left button under the records).
re-sort base may take some time, but after it all new records appears in the database.

MTH experts are already working on a solution to this problem

Import Function - Mal Function

Publication date: August 16, 2018

When we import a file to to create new rewords is Mal Functions:

Firstly – after importation – it shows all records have been imported, but when we go back to the records and update the view, the view does not show the records that we have updated.

Obviously we tried a few times.

Secondly – We tried to see if the records might be created – so we did a duplicate search, And there were 3 duplicates of each record.

1. Why does the records that were imported not display in the view after importation?

2. Why does create new allow duplicates to be created – does it not check the validation limitations on the system?

Please fix this problem

Sorting and Pagination issues

Publication date: August 16, 2018

1. Widget (Integrated Database) view. While it is possible to set the number of records to be viewed for a widget that is generated as a result of search (saved search) MTH ignores this when displaying records within an iframe and always displays the number of records of the prime database.

2. Sort. When a record is edited or when a new record is added the default sort criteria set by the user for a widget is ignored and the database re-sorts based on the most recently entered record.

Back link missing

Publication date: August 20, 2018

When the “Allow a web user to edit database records” feature is checked and you go to your embedded data base, the “back” button is not there when you click on “More” or actually edit a record and update the information.

1. Click the “Edit” button on any record.
2. Update part of the information.
3. You will get into the “Record Widget”
4. A “Edit” link will appear at the top but there is no way to go back to the data base unless you click the browser’s “Back” button.

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

Sort widget

Publication date: August 16, 2018

I seem to have an issue with being able to change the sort order of a widget that has been created as result of a search, standard view of records is fine but those produced by a search and then saved do not allow the sort by another field. Can you check out please.

Formula fields - images and record view mode

Publication date: August 16, 2018

1. I created a formula using an image field + null image (empty) which computes correctly.



2. In widget view this displays correctly and the image location url is correct. All good so far.



3. In record view mode the MTH dynamic link works correctly. It does so by using the img src= syntax followed by an abbreviated url, for example; img src=‘/images/data/dcPmobW7LgW4BcI8o2W7b7/c4W4hdVSjisjfBW7LSgcjZ/agent-pic.png’ – this where the field inserted was |image link|



The above is OK in a limited way.
The problem is that it does not allow the image derived from the formula to be used in any practical way as it can not be opened by the href tag because the syntax img src= is built into the output from MTH into Record View mode.


This strange because as noted above the url location of the Widget view image is correctly output and displayed.


Is it not possible to output the whole url without the img src= prefix into the Record View? This way the user can decide how they will use the url output, for example img src=‘http://www.mytaskhelper.com/images etc etc’ or indeed href= “http://www.mytaskhelper.com/images etc etc” or both together to open an image link.


I have tried using java to unstring the syntax that MTH passes to Record View mode for a dynamic link. No success.


The project I am designing uses 4 MTH relationships where each database contains images of localities and properties. For example, in data entry the user selects a relational database that contains 10 images of a property, these are then passed to the master form using a formula. All works nicely.


But when the MTH dynamic link for the field passed in displayed in Record View it comes in with the the prefix of img src rather than the real url for the image, which is correctly shown in widget view.


This means that I either have to display small images in Record View mode that can not be opened using href and therefore useless or place all images in the master form, which is defeats the object of the design.

Multiple Record Creation

Publication date: August 16, 2018

Hi,
I have a problem with my records posting multiple times. (Same entry 3 or 4 times). I have figured out that it is because of a checkbox field I have. I mailed you the link too so you could look. Please help.

Vertical Adjustment of Record View

Publication date: August 16, 2018

I would like to be able to adjust the vertical height of my record view to allow more records to be displayed without the need for a client to have to scroll down. The record view allows horizontal adjustment but not vertical.

Graphic into a Formula Field

Publication date: August 16, 2018

When a graphic is brought into a formula field it loses the ability to use as a link to the Record View module, which forces me to use a final “more” graphic to achieve the same purpose. A minor irritation but one that novice or new MTH users will find frustrating.

Deleting multiple records slowdown

Publication date: August 16, 2018

We’ve noticed that deleting multiple records can cause some system slowdown.


For big databases we doing this delete operations in background. However, it make take sometime to update all data structures.


So when you trying to delete page by page, it may not be fast enough. And there may be situations when you are trying to delete same records several times.


In order to avoid such situations we’ll show you Records not deleted, because your previous ‘Delete selected’ operation is still in progress. Please, try again an a moment (depending from your database size). message.

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!

chronological order?

Publication date: August 16, 2018

I must be missing something, but I can’t find a way to order my records by ‘date’ column chronologicallly. It just orders the dates alphabetically.

Thanks for the help.

Customizable Record View Not Working

Publication date: August 16, 2018

In the “Customization and Integration” portion of MyTaskHelper there is the customize record view function.

After I type information in and alter the layout of the record view I click “Update”. The preview does not change and when the page is refreshed it is back to the way it was.

Thoughts on why this is occuring?

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

Having problems importing records

Publication date: August 16, 2018

Hi,

I have an existing database structure set up on MTH. I am now trying to import data in csv format into the MTH database. It gives me the message:

“Not improted because you have two columns with the same name. All fields should be with different names.”

I have the same file names, so that the process would know which column to put the data. Please advise what I should do.

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

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

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

Requied Value for "is not empty"

Publication date: August 16, 2018

In the Records area, I tried to do a “search” for ones with a Birthday that is not empty, but, it required me to enter a value (it should not require this).

Records - Page No. - Not Working

Publication date: August 16, 2018

On the Records view, the “Page No.” drop-down shows the correct no., but, since the system allows the User to change it, there’s an assumption that changing to another page no. will navigatge the User to that page – it doesn’t (it just stays on the same page).

Conditional Logic for Non-Attendance

Publication date: August 17, 2018

Say we are due to go to a site every day of the week.

If we don’t record an entry in the day for that site. Can we generate an email as an exception to normal? Or a report? Or…?

In-place editing to speed up data entry and record appends

Publication date: August 17, 2018

Is it possible to create a “quick verify” form where:

MTH “single line” field formats in a record can be entered into and modified without clicking the edit pencil. See image quick_verify.png: Record #2. Change the First Name, Last Name, and phone….

— a hot link is attached to each record (possibly unique ID), that will take a data entry person to the record in the “Add a record” form and then back to the “Quick Verify” records screen. This would make it quick to append check box formatted fields etc…

Same Database - Two Views

Publication date: August 20, 2018

I have been thinking it would be very handy to be able to have more than one view displayed on my sites from the same database.

I would like one where the administration staff can delete a record (for example)on one view, however the user cannot delete a record on another view of the same data.

Is this possible within the existing framework?

Email Newsletter - include related records

Publication date: August 20, 2018

Could it be possible to email a set of related records.

For example, lest say I have a Form called PEOPLE and a related form called THINGS. Let’s say that an PEOPLE record can have many THINGS.

Could it be possible to email a PEOPLE record person a listing of the THINGS records associated with the PEOPLE.

Create full change logging and field history

Publication date: August 20, 2018

Per the Advanced Options it looks like the DB logs changes – at least Create and Update times.

You should also enable “full audit” logging, so that it records value changes and users effecting changes, and with the implement an automatic “History” view of a record or field.

Merge Duplicates

Publication date: August 20, 2018

In the database we uses prior to MTH there was a feature to “merge” duplicate records so that links aren’t broken to other forms. Can we please have the ability to do this in MTH? We have several people adding contacts and sometimes they don’t find the original record and add people again. Thank you!

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!

Images to view in Records

Publication date: August 20, 2018

Hi, I am building a form to collect photo entries for a contest. People will upload their photos in jpeg form onto the form. But in the Records pages, is there a way I can view a thumbnail of the image uploaded? At the moment it is just a linked image file which I have to ‘right click’ to open and save on my computer.

Also, if this is possible, can I attach a thumbnail of the images into the Success email back to the entrant, so they have confirmation that their images are uploaded correctly?

Thank you, Steven
svllee@gmail.com

Save record

Publication date: August 20, 2018

Would it be possible to stay on the same screen after making record changes ?

Printing Records

Publication date: August 20, 2018

Can we have a feature to allow us to search records and then sprint the results.

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.

Create a Default Option to Repeat the last record

Publication date: August 20, 2018

It would be nice if you could create a default value of the last value entered in the data base.

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.

Record - Copy

Publication date: August 20, 2018

Please add a “Copy” function for Records, e.g., I may add another Record that is exactly the same as another, except for 1 Field; so, this function would be veey appreciated.

Import from XLS/CSV File

Publication date: August 20, 2018

Instead of importing from a set of records that have been copied & pasted from a text file, it would much appreciated to be able to just Browse and select a file that’s either an XLS or CSV type of file, with the option of specifying that it has a header row or not.

Auto-Sequence

Publication date: August 20, 2018

Many databases have a Field Type of an automatic sequence no. (better if it allowed a gap, e.g. automatically increment by 10 or 100 – this allows an insertion, which should be allowed, in-between existing records).

Initial Value

Publication date: August 20, 2018

When I define a Field, I’d like to set it to an initial value (this is a very commonn feature for databases), as I don’t really want to have to update ALL the records to do this.

Hide Entries from Database Widgets View

Publication date: August 20, 2018

is it possible to hide entry from the records?rather than to delete the entries for future use…i want to hide some entry from the database widget rows, so that online user cant view it…and manually schedule for them to view after i unhide row entries from records entry.

Allow creation of checkboxes for record search

Publication date: August 20, 2018

When creating a database search, allow the creation of a search form that you can list choices. Such as…
5:00am to 6:00am
6:00am to 7:00 am
7:00 am to 8:00 am

These would match entries in the database

New Records

Publication date: November 13, 2018

When pressing new record button – user is given plain white page and No form?

However when I login as account admin it works?

Had similar problem before with search facility that you quickly fixed.

Many thanks