Hi, James

Thank you for your patience and posted feature request.
You can find how to use with screenshots on yoru feature request page here

Thanks!

Hi, James

Please, see new option to find duplicates on this screenshot:

And here is the result of scanning your database:

Thanks for your suggestion

We will implement it as soon as possible.

Hi, James

Yes, Find Duplicate option is what we really need.
While trying to reproduce your issue we couldn’t find it even in Excel.
So it would be really great to have it in MTH.
Please, if you can add such feature request we will be happy to implement this for you ASAP.

Thank you!

One of my databases has some 30,000 records. The unique column is NAME. I have no idea how to find duplicates without searching and reviewing every individual record. That would take an eternity.

If there was a FIND DUPLICATE function based upon user’s choice of column, that would certainly make it a lot easier.

And when I attempt to update, I am adding dozens of new records, or trying to change dozens of existing records. It doesn’t seem to make sense to do it one record at a time.

I may be missing something. I would like to remove the duplicates but don’t know how to find them without looking at each record individually.

Hi, James

This is the way it works now.
Yes, when you working with one record it’s confusing and you expecting another result.
But think it if you have 500 duplicates and importing 300 another records. it’s a pain and I can’t imagine how to handle it.
Updating by unique column is common solution and you can find just the same in another systems like MTH.

However, we always ready to change system, add another option or feature. Especially if you will describe how it should be, but not only for your single case, but for another users too.
Because, like I said, most users will update many records in time.
For updating records they just use Search, found some record – click Edit – hit Update, and there is no need to use Import → Update – copy from Excel etc.

Thank you and I look forward to hear more thoughts and ideas from you.
Again, we will definitely ready to change system to fit msot users needs.

Thanks!

There are some duplicates.

BUT I tried IMPORTING only one record, after having made sure there was only one such record in the database on MYTASKHELPER. The NAME on both the MYTASKHELPER and the NAME in the IMPORT were identical. A couple of the columns in IMPORT were different and that was the reason for updating.

NAME = Blacke

Are you saying that no IMPORT of any kind can be done if there are ANY duplicates, even if those are not the records being updated ???

Hi, James

We have investigated your problem.

If you need to import a data to database using some column (for example Name) – in this column should be only unique records.

In your database the column Name has identical records.

Please, to correct import, use column with unique records.

Hope it helps.
Thanks

Hi, James

I can only repeat what this message said.
Please, let me know your database url and what data you trying to import, maybe you can make screenshots so we can better help you.

“knowing that the same (but slightly different)” it shouldn’t be different at all.

If you have database with just two columns: Name and Age, with such records

Name Age
Igor 25
Ivan 26
Nata 27

If you will have two Igor’s, like this:

Name Age
Igor 25
Ivan 26
Nata 27
Igor 28

import will show you your last error message.
And your first error message can be when you have entered something like this:

Name Age Name
Igor 25 asd
Ivan 26 aaa
Nata 27 aaa
Igor 28 aaa

i.e. two column with same name

And you select to update by name. Then you should have

Name Age
Igor 28
Ivan 29

in your Excel file (make sure to copy/paste from Excel and not type it in import text box).

So, when you hit import it should update your database and it will be looks like this:

Name Age
Igor 28
Ivan 29
Nata 27

Hope it helps. Otherwise, please, email me with more details.
Thanks!

no probs
thanks for you request

Sorry – didn’t see it. I should have known better. You always do a good job.

Most probably you didn’t saw it because blue flash message dissapears in 5 seconds.
So we changed it to red message, which will only dissapear after you will close it or refresh page.
Hope it looks better for you now.

Please, see screenshot below:

Sorry – but I don’t see that. I see the numbers down the side, for each record found, but I was looking for a total statement like “XXXX RECORDS FOUND” or something like that.

Hi, James

Done. Please, try to search something and you should see number of records found.
Hope this is what you need.

Thanks!

Hi, James

Ok, will be done.
Because you are not the first who requested it
and it’s really easy to implement.
Thanks!

Mylaya,

Please, click
here to find step by step Database Fitlering instructions.

Thanks!

Hi, Mylaya

I know why I took a while to implement your Filtering request – you didn’t answered to my reply to this topic.

However, please, take a look on your records page, you will find ‘Filtering link’, same you can find in your Database Widget.

It’s a beta functionality, we will be happy to hear feedback from you.

Thanks!

Hi, James

Yes, it will be underlined for sure.
I’ve understand you and we will do it.
I can’t give you estimate, because we really have a long list of features to implement very soon.
Users from DabbleDB requires some importent things to do.
But I can promisse you that we will not forget about this feature and will implement once will get any chance.
Thanks!

I would like for the name that has a link, to be underlined, and perhaps a different color (but that’s not necessary). No other column as it is already getting very wide and requires a lot of scrolling.

When a viewer sees a name that is underlined, he would know that he could click on that name and be taken to a different page outside on a different website.

Seems if I checked Validate and URL, it would open up a new box in which I would enter the URL. Close the box and it becomes an attached hidden link for that particular name.

I don’t expect you to redo your software just for me. I appreciate the consideration, and can live without this feature.

Oh, I see now, James.

My suggestion was to use URL validation, it just checks if you enter valid URL in text field.

What you need is to make links from text in data cells.
I’m not sure how it should looks like for you.
For example, we may want to create new Field Type called URL.
And on the form it will be looks like ‘Enter name of the link’ and ‘Enter URL’ and in database it will be looks like proper link, where name linked to entered URL.

We will think about it little bit and implement it for you.
Thanks!

I am not understanding your suggestion. I have a database of names and data. I want certain names to be a link to an outside page. In this case, click on a certain name, and be taken to a page with that person’s wartime diary.

I went back to Form Builder and clicked on Validate and URL and submitted. I don’t see any change, except if I click on that name I get a “can’t find”. I would expect to see a box in which I can type the path of the link and then attach that path to a name. Each name would have a different path, but not all names would have links.

Thanks, Maria

It is definitely makes sense to have all this options too.
We will do it for you.
Other users will enjoy it too, for sure.
Thanks!

Igor —

DabbleDB actually handles a variety of options for dates and times, either when setting default values, or when searching.

They include “today,” “yesterday,” “tomorrow,” and “next week.”

So, for example, when adding a new task, the default start date can be set to “today” and the default due date could be automatically set to “next week.”

Here’s some info: http://dabbledb.com/help/index/date_and_time_values

— Maria

Hi, Maria

No, you can’t do it now.
Because it is temporaly disabled.
We working on improving this part of functionality.
We have this feature from early stages of MTH (2007),
because our aim is to have real object oriented database.

However, we want it to staty easy-to-use, this is why improving it.
The way dabbledb handles it and the way we had it not good enought and we will open upgraded functionality this month with a lot of other improvements.

Thank you for asking and pointing to it.
This topic will be useful for another users.

Thanks!

Hi, Maria

Good point!
I agree that when you have ‘Today Date’ field you don’t want to select today’s date each time. It would be great if we can set ‘Default’ value for Date, Date & Time fields as ‘Today’ or ‘Now’.

Thanks for your good suggestions.
We will get back to you ASAP once it will be implemented.

Hi, Maria

Thank you for adding your voice.
Please, make sure to ‘Vote for this topic’ too.

We working on a views, investigating how dabble handles it making it even better.

For now, please, use Search on Records page. You will be able to find entries with In Progress status or with Due Data > today.

In the near future you will be able to save this search filters and results into the Views and even share it on your sites.

Thanks again, and, please, feel free to contact us at any time with any questions or suggestions. We look forward to help you to migrate from dabbledb.

Thanks!

I would also need to be able to create different views of the data in order to be able to switch from Dabble.

For example, I want to be able to create a list that shows:

• Only records with a particular field dalue (say, Status=“In Progress”)
• Only records with a particular date range (say, Due Date=“>today”)

— Maria Korolov
President, Trombly International

We’ve sorted it my creating severla MTH sites, i.e. .ru, .com.ua, .co.il

Hi, Andy

We’ve implemented it for you. Also emailed you about it.
Please, let us know if this is what you needed.

Thanks!

Hi, James

yes, you can do it now.
Just create any text field and click on Validation link.
You will see ‘URL’ option. Check it and MTH will assume that all data in this column are URL’s and will link it.

Nope, we do not have such.
But it sounds very interesting, we will think about it for sure.
Thanks!

Hi, James

Thanks for good feedback!

Please, see screenshots in this blog post, where you can see how to resize columns.

Nope, we did not ever needed vertical lines, so there is no way to see it.
Please, let us know more details about it. Do you need it as an option in Database Widget?
We may want to add such settings, it will be a part of our ‘database widget improvements’ task.

Thanks!

Hi, James

Please, send me screenshot of your excel file, which you trying to import or the whole excel file. And I’ll tell you where is the problem for sure. You can attach files right here or email at admin at mytaskhelper.com

We saw your kind words on dabble db, thank you very much!
And enjoy MTH!

James,

you are right. You can proceed this way.
You will receive emails and link to new entry and you can decide what to do with this new entry, copy it to needed xxth division database or delete.

I just thought that you can add xxth Form Widget to each xxth directory and it will automatically be added to your xxth listing.
If you need it to be reviewed/edited before going to database widget you can enable database moderation.

Hope it makes sense for you.

Looks like the questions and answers are getting jumbled up a little.

I have 5 separate databases, all are Rosters of WW2 and Korean War Veterans, classed by Army Divisions – 28th, 30th, 31st, 83rd, and 106th. Each is found on a separate website at www.IndianaMilitary.org That site has a link for each, plus much other historical info.

I wanted the form to be emailed to me and not to be added to any of the above listed databases. That is left up to me after I get the email. The one form will capture info for all the divisions, with one line asking for the division name.

I think I may understand – when a person fills out the form and submits, I will get an email telling me to go look at that form (which is a small database) and the new data should be here and I can copy or delete as I choose.

I wish I was smarter.

Re: notification about previous questions. Are you talking about this forum emails? It looks like we sending emails to all users in this topic after each reply. We may need to investigate it more if it looks like a forum defect.
Thanks.

James,

when your users will fill your form you will automatically receive email about it with all the data entered to your form.
You will also receive link to this added entry.

Just go to ‘Widget Builder’ → “Form Widget” and fill form here – you should receive email shortly.

Also, as I understand you separated forms from existent database.
But this new forms will collect data for your current projects?
I’m not sure why you did it. If data entered in forms are the same as in the database you can use the same project for this.

We also have Moderation feature, – when users will add new entries through your form it will not be shown on your database widget until your moderation.

If you need another columns heading – I’m with you you only need to add new project for this. Also, if you need to hide some columns in database widget you can do it also in database widget settings.

Please, let me know if you have any other questions.

I think I understand partially. I have created a brand new project that I want viewers to change or add information to my 5 separate databases. It would be a separate link on my website, such as “Click here to add or modify information”. It would not be associated with any database – that would be up to me after I receive the update.

But what I wanted, was for the SUBMIT button to send the completed form to me as an email. I can’t find any place to tell SUBMIT to do that ?

Hi, James

We glad to hear you’ve successfully built your database.
It would be great if another dabble db users can do the same.
By the way, it would be great if you will not delete your topics, because it would be very helpful for other users.

Regarding new form: you can just create new project or add ‘New form’ in Form Builder and it will be separated from your existed projects.

When you adding every new form it automatically creates database back-end for it. So you can create any kind of forms: contact forms, registration form, online order form.

If you only interested in creating database you creating your form for filling database.

For example, if you want to create People database you will add form ‘People’ with ‘Name’, ‘Age’ etc. fields (columns).

Then you can start adding people and will see data table on Records menu or in Database Widget where you can share it on the web.

Hope you will find it useful!

P.S. Please, make sure to invite other Dabble DB users if only possible and if you think they can find MTH good for them also! ;)

Hi

Hope you are well.

We’ve finally created what you asked.
It called Rules and you can find it in Form Builder.

it’s still Beta, so, please, be patient if you will find any issues with it :)

But shortly you can now do things like this
http://mytaskhelper.com/widgets/akIrPRWAbavAbOchIVdPhD/bB356f5RLeQP3VFlAqeGJx

Choose United States and you will see new field US States, choose another country and states will dissapear.

Another field asks you if you are married, if you answer is Yes it will ask your wife name.

Hope it helps you!

Доброго дня, Міха!

Сподіваюсь Ви гарно проводите вихідні дні і маєте гарний настрій :)

Ми також хочемо підняти Вам настрій і повідомити що виконали вашу пропозицію.

Це просили?
http://mytaskhelper.com/widgets/dngsRiFsPktBgguh9BiBjI/cmvDIauj9fIy4VA97bXx_8

Відступ від теми: до речі ми тепер маємо mytaskhelper.ru & mytaskhelper.com.ua і навіть mytaskhelper.co.il
домени

Це було зроблено з різних міркувань. Ми віримо що і нам і україно- та російсько-мовним користувачам так буде краще.

Але це також означає, що ми перестанемо підтирмувати всі ці мови на .com акаунті.

Для прикладу – ми додали модуль Rules – який дозволяє робити форми динамічними. Ви можете знайти його в Конструкторі Форм.
І весь цей модуль лише англійською. Поки що це Beta функціональність.
Коли ми покращимо/отримаємо фідбек то обов"язково перенесемо і на інші домени цю функціональність.

Це стосується і всіх подальших фіч в системі.

Сподіваюсь ми зробили ти що Ви хотіли! :)
Щасти!

Hi Igor! its working! thanx!

Hi, Andy

Thank you for this suggestions.
Is is definitely makes sense to implement and we will work on it for sure.
Thank you and please, let us know if you need anything else.

Hi, Mylaya

Have you looked at Team menu?
You can find/invite people to your project and make them members or administrator. maybe it will fit your needs?
We also planning to make big improvement to this teaming functionality, permissions restrictions etc.

Regarding filtering 0-9, A..Z – yes we are going to do it, just a bit later. Because we are on the way of introducing conditional logic functionality which will be useful for you also.

Regarding login system I’m not sure what do you mean, maybe it’s still that Team module what you are looking for.

Also we do plan so add one more layer of widgets protection ‘by password’ so you can only allow people who knows password to see form or database widget.

We wil definitely let you know first if we will have something new for you.

Please, let us know if you have any other thoughts how to improve MTH!

Also, please, make sure to vote for each your feature request.
See ‘Vote for this article’ and you forum post message.
This is the way we trying to prioritize our new feature request.
The idea is to vote or to donate for feature to push it to our top of the list.
The fact that you’ve signed up for paid plans adds 20$ to this topic :)

Anyway thanks and talk to you soon!

Hi, LuAnn

Just for your information – you can copy your form year from year, see how in this blog post How to copy form.

Enjoy!

Hi,

we are happy to let you know that we’ve introduced Duplicate Form as you requested.

Please, let us know if you need anything else from us.

Мы заметили, что “проблемные” емейл провайдеры чудом “исцелились” и теперь у Вас не должно быть никаких проблем.
Извиняемся за временное беспокойство!

Hi Helkis

You can’t do it now.
We have added your feature in our working plan.

To vote for needed topic please click on link Vote for this topic

See screenshot:

Hi Andrew!

i found the url option and work fine, but i will more :)
in many forums can link as alias exampe this syntax: [L:http://google.com]google[/L] here show google as link, not the url, how can i do that?

and where can i vote for the features?
Thanx! helkis

Hi Helkis

About url option please read here

Now you can’t copy forms to another projects. See post Backup database with web forms
You can vote for this feature or make donation and our developer will make it as soon as possible.

Hi, Eitan

Please, login to MTH, go to your projects and enter this link:
http://mytaskhelper.com/set_locale/he

Please, go though system and send us words you think has wrong translations or just missing translations.

Thank you!

Доброго времени суток, Иван!

Рад сообщить Вам, что мы выполнили ваш запрос.

Пожалуйста, откройте свой проект, перейдите в Конструктор Форм и откройте окно валидации для поля типа Файл.

Вы сможете увидеть две новые опции: тип файла и размер файла.

По-умолчанию разрешается загружать файлы любых типов, но размером не более десяти мегабайт.

Теперь Вы можете оставить необходимый Вам формат ворд: *.doc
и размер 0,3 мегабайта.

Надеюсь это Вам поможет.

Спасибо и удачи!

Hi,

we will add time stamps to our search filters for sure.

Please, give us more details about excel import and formulas you need.
So we can get back to you with a solution. But right now we do not support formulas, please, feel free to add this to separate feature request on this forum.

Thank you!

That time stamp does not seem to be searchable. I would want to be able to filter the category similar to the way I would any other category. I don’t need the IP or “Created” or “Updated”. All I need is date and time.

Is this possible without me having to export the data and create an Excel formula to pull out the relevant information?

Hi

This feature has already done

Please add any record to database and click to link MORE
Please see screenshot

На даний момент такої можливості немає

Це питання часу і грошей))

Доброго дня wlad12. Так Ви вже задали питання на форумі. Локалізація сервісу ще в процесі, і там де відсутній переклад використовується англійська мова, як базова.
Правильно робите, що звертаєтесь. Якщо є конкретні питання – задавайте, можете продовжувати писати сюди, або ж перемістимо тему і саму розмову в російськомовний розділ, як Вам зручніше.

Здравствуйте.Все очень хорошо, но для начинающих очень проблематично.Надо долго тыкать чтобы что-то найти.
Три языка на одном сайте перемешаны.Письма приходят на английском.Как задать вопрос на форум не разобрался.И всеравно-вам большое спасиба за то что вы есть.

Hi,

yes, please, upgrade your IE, because it looks fine here.
However we will try to fix it for older versions too, but in an order of priority.

Thank you for your good words about MTH, cheers!

Wonderful, this is exactly what we needed!

Thanks a lot, will get back to you with fixes asap.
Cheers

Hi Igor
Please find attaching herewith the PDF file with more precise explains.
Regards
Eitan

Uploaded file link:
http://mytaskhelper.com/images/data/btxTV1vGHiI4Ckm1CRK4B8/bGPgb6gaTo-BR7Ix8cg6uK/HebPagCorrectins.pdf

Hi, Eitan

Thank you for the screenshot.
But please, try to edit it in the Paint or something like to include arrows, shapes etc, because it is not clear for me, where to move text.
Please, confirm that in Hebrew radio button should be at the left and button text at the right?
‘Issue headers’ – this is form field names?
What does it mean ’I’ve made some changes within the file’, which ‘file’?

‘Page header must centralize to the right’ – how to understand it?
it would be fantastic if you can take that screenshot and just draw how text and controls should be.

Thank you and sorry for this, maybe I’m just too tired :)

Thanks!

No probs, guys, you are always welcome ;)

Great, thank you very much, will try that out today!

Thank you Igor for this feature!
You make great work in short time!

Hello, Sebastian

Please, go to Form Builder, find your URL field and click ‘Validation’. You will see ‘URL’ option under ‘Email’ option.
Please, check it and give it a try. It should validate if user entered correct URL, also after entry added to database it will be linked, all links opened in new window.

I’ve moved your topic to ‘Feature requests’.
Please, let us know if you need anything else
and have a good day ahead!

Enjoy!

It were already implemented. See how to use it in file field with upload progress blog post.

Also, see how to disable file upload progress.

Hello, Mikie

I want to thank you one more time for your very useful request.
I’m sure it will be widely used and even we will use it for sending email confirmation to our users when they will fill our contact form.

Between, Email confirmation based on email form field blog post were written for you and for all users who may need to use this feature.

Thank you,
Sincerely,
Igor

Hi, Sebastian

Thank you for your good feedback, we really appreciate this ;)

Yes, of course, we can easely add URL field for you, we will implement it shortly.

Please, let us know if you need anything else.

Thanks!

Yes, I will take care about it.

Наприклад для блогу ми зробила так що, якщо ви перейдете на сторінку
http://mytaskhelper.com/blog/ru локаль автоматично стане російської і показуватимуться лише статті на російській мові. Аналогічно і з іншими мовами.
Так само робитимемо і для форуму.

Hi Igor
I’ve made some changes within the file so the text now assembling in the correct way.

Most of the problems were with the Issue headers – they were assembled too much to the left.
Those headers must be placing right above the radio buttons (Or any other segment).

Also the page header must centralize to the right as possible.

I sending the work as Single Web Page and as screenshot.

Regards
Eitan

Dear Igor
How can I upload file(s) to here?
need you instructions
Eitan

Hi, Eitan

We did some changes. Please, could you review and comment on it?

Please, send us screenshots where you can highlight errors and how it should be.

I’ve noticed that widgets on direct links looks not the same as inside widget builder, investigating it.
But overal, we added encoding you provided and changed More section and element positioning in widgets.

Look forward to hear your feedback and improve it.
Thank you!

Hi, Mikie

Thank you for your detailed explanation.
See, if you will delete records from your project – record number is not what you want to use.

And if you need unique number we can use records id in database, it is absolute unique, like this ‘a0BM2E_Q4r3Q0EackWwstf’.
But if it is too long for you we have short, but still unique id in records ‘more’ section. You can see it by clicking ‘More’ link at the right side of each entry.

However, we do not have abbility to email this id to user yet. So we may want to add option to include this unique id in confirmation email (confirmation email feature we just added for you).

So user will have confirmation email with body entered by you in form widget + line at the bottom: ‘Unique ID: a0BM2E_Q4r3Q0EackWwstf’

Also, we may need to include this ‘unique ID’ to the search criteria list in search form.

Thank you and I’m sure we will make it possible for you to use MTH with your ticket help system.

Sorry for the late reply. For some reason I only received the emails about your reply today.

I never thought of the row number and that could work now that you mention it.

Let me explain the reason and maybe it will make more sense. I have a application that users can download and use. Now for support reason I want to give users the option to submit a problem and then I can reply to them with help. So they would fill out your form and then the unique ID number would be linked to there form and emailed to them automatically. This gives them a point of reference. SO when they come back later and search for there problem they can search via there unique number. Or if I reply directly to them by email I can quote there unique number.

I see that you have already set up the email option. I haven’t looked at it but will shortly. I will let you know what I think. Thanks for the help and quick updating of a wonderful service

Regards
Mikie

Hi, Mikie

We’ve implemented automated emails for you.

Please, go to Form Widget settings and find confirmation email section at the bottom right side.

You can set reply-to, subject, body, from email headers.

Enjoy!

Sincerely,
Igor

Thanks a lot, Eitan, we didn’t know that.

We will take care about it now.

Thank you!

Hi Igor
Please pay attention that the following code also should be placed within the Hebrew pages sources:
<meta http-equiv="Content-Language" content="he" /> <meta http-equiv="Content-Type" content="text/html; charset=windows-1255" />
Those codes will also alow Google to locate and presents the Hebrew pages correctly.

This code must be placed with all other enncoding codes – including the UTF-8.

Eitan

Hi Igor!
Thank you for notifying me about the changes concerning the Hebrew encoding.
I’ve reviewed your site’s pages and here are my comments:
A) The right-to-left are OK now, fit to Hebrew users.
B) The text located within the columns (file created at the 01/31/2010 at 09:20) should be in right-to-left centering encoding.
C) the RECORDS tab:
1. When pressing the VIEW next to a chosen file – the screen contents still in the English left-to-right encoding, it should be in the Hebrew right-to-left of course.
2. When pressing the EDIT option next to a chosen file – the screen bottom had cut off and can’t provide the page’s lower area (I guess it should provide the “Update” button).
The Form Builder tab is fine and correct.

D) Widget Builder
1. Encoding are incorrect, it should also provide the Hebrew encoding as right-to-left.
2. The entire contents are cut as it’s too much into the page’s left margin.
3. when clicking on the Direct Link option – the entire contents placed, but the encoding looks bad.
This is very important as this page is the final version that will be provides to the Hebrew’s users. At this time it is not recommended to have it like this.

I didn’t found the excel data that uploaded by you few weeks ago, please advise.

I hope that my comment assisting you.

Best Regards
Eitan Gal

Hi, Mikie

Hope you are well. I just want to let you know that your suggestion is on the top of our list. And I may have several questions for you.

As you can see from my previous reply we already generating unique id. But we want to make automated emails as well.

The way we planning to do it is:

In form widget settings you will be able to choose:

Sent email to ‘select your email form field’ with ‘body’
will it be enought for you?
And are you sure that we should send only to user but not cc this email to you? This way you will know when someone submitted something to your project.

Thanks and look forward to hear from you soon.

Andrew already added several videos on russian blog posts.
We also in a process of adding flash video on our main page – thanks Chris.

Hi, Eitan!

Please, notice ‘Hebrew’ link at the bottom of each page.
Please, click on it and text direction should become right-to-left.
However we really need your feedback on it, because it’s something not obious for us at all :)

Regarding changing locales on widget pages – it is something we can’t do now. However we do plan to add options for database owners to set default locale for their form and to add change locale options right to the widget, so user can change locale if he need.
We awaiting few more translates to start working on it (one from you ;) ).

Thanks and look forward to hear from you soon!

Hi,

Thank you for your very valuable suggestions.
Definitely makes sense and we will work on it.

Thank you,
Sincerely,
Igor

Таааааак, з Вас мого…розповідати всім про карти і систему загалом! :)))

Як Ви вже здогадались ми додали опис маркеру для вас :)

Є текстове поле в яке вводите назви колонок вашої таблиці,
порядок і правильність написання необхідні!

І в такому ж порядку, в форматі назва колонки: значення з"явиться опис при кліку по маркеру.

Насолоджуйтесь!

так, просто змініть координати хоча б на пів-метра
і все вийде супер :)

Дякую за лінки! :)

- А та карта згенерована по тим самим точкам?
Не впевнений )), але “картина” має бути приблизно такою ж.. Я спробую погратися, завантаживши різні таблиці з великою кількістю координат…

Кілька цікавинок )))
http://habrahabr.ru/blogs/php/38290/ (це вже майже вам непотрібно)
http://habrahabr.ru/blogs/google/28621/ (це має бути корисним)

А та карта згенерована по тим самим точкам?
Треба API вивчати,
але на перший погляд не зрозуміло як можна показати дві точки з однаковісінькими координатами :)

Та чого за “так”, за блог пост :-D

Хм… Ок, я спробую cтворити нову базу і вручну задавати координати, щоб перевірити, чи дійсно проблема в моїй базі…
Бо мало вийти щось на зразок цього http://biomon.org/frames/map-machaon-big.htm (за кількістю точок)

Образитись? Люди виконують усі мої забаганки за так, а я маю образитись? :)

1. Думаю це із-за того, що ваші точки повторюються, щойно переглянув базу і дійсно купа точок з однаковими координатами…є ідеї як це виправити?
2. Це ж треба ще знати про такий параметр в гугл картах))))
але це вже робота на потім, якщо не образитесь :)

Для першої ітерації цього має бути досить, як тільки вільна хвилинка з"явиться посидимо над InfoWindowHtml та проблемою однакових координат :)

Так! Це дійсно круто!!!! Дякую!
Єдине, я не зрозумів кілька моментів.
1. В базі 299 записів, відповідно, стільки ж і точок. Відображається лише 32… Я думав стане більше при наближенні, але на жаль, ні… (Зверніть увагу на те, що в моєму випадку всі точки вистроюються в прямі лінії – може причина криється в цьому?)
2. Опис точки (маркера). Я думав він буде не по типу підсвіки тайтла, а спливаючим віконцем (здається, Гугл називає це InfoWindowHtml). І я думав можна буде задати вівід не лише одного поля з бази у це віконце, а кількох (Наприклад, при кліку на маркер в спливаючому віконці відображаються інфа: НАЗВА, ОПИС, АДРЕСА, що є, по суті, відповідними полями запису в базі, з якого сформовано точку). Відповідно, логічно було б мати можливість не тільки відмічати які саме поля показувати в інфовікні, а й налаштовувати порядок цих полів…
Отакі у вас невибагливі користувачі )))

Hi, Mixa!

We are glad to announce few new features in our new Map Builder :)

You can set map center, map width and height, markers title,
enable or disable map types, set zoom, enable or disable large map.

Of course you can get direct link to your map and widget code,
set widget sizes and use on your own site!

Hope you find it useful,
Cheers!

Привіт, Міха!

Сподіваюсь у Вас все добре :)

Ми додали більше опцій до карт.
Зараз ти можеш обрати чи показувати типи карт (ландшафт і т.п.),
встановлювати розмір карти і розмір віджету (ширину і висоту),
задавати зум і взагалі прибирати або показувати його.
Звісно ж Ви зможете задавати центр карти, назву маркеру і отримати код віджету карти, або прямий лінк.

Щодо великої кількості точок, то з цим проблем не має бути.

Сподіваюсь це те, що Вам потрібно!

Щасти!

thanks,Nice work! Christien

Hi, Christien

Thank you for your great feedback about our database application, we very appreciate it!

We are planning to extend our Search capabilities with saving searche results. It will allow us to introduce something called Views.
This is where it were requested

So when we will be able to work with views it will allow us to make such kind of exports as you need. You will be able to find some records and your database and export only this result records.

Hope it makes sense for you and thanks again!

Hi, Mixa

Please, make sure to check your feature request status.
Basically we’ve uploaded Map feature alpha version, check it in Widget Builder in your Biomon project.
Cheers!

Привіт, Міха!

Як і обіцяли, ми почали роботу над картами.
Будь ласка, заглянь в свою базу Biomon
, і перейди до Конструктора Віджетів, маєш побачити підменю Карти.

Там ще працювати і працювати, альфа версія :)
але просто хотів показати Вам щось вже сьогодні :)

Щасти!

TC clarifies:) If you are at least part of this sell – you heroes! :)
For example, the user must type the table
Chervonograd | World | cherv.jpg | 32.564654 | 45.654476
Kahn | Cherkassy | kaniv.jpg | 36.654654 | 44.987534
….
He assigns the penultimate column of field type, for example LAT, and the last column – LONG and get a map with dots, for which data are taken from the table. When you click on the point of getting token description points for which data are taken from the same table. It would be nice to be able to customize what and in what sequence to show the description as that – no.
Centering the map. Center map or set manually or automatically determined based on the extreme points.
Prepares a map can be integrated on any page in frame size setting.
This is the basis. Additionally, you can still make super-turning …
If too many points, then initialization maps are usually very long (and, inokly thousands of points just do not see the same maps). (Or vice versa – if a certain part porivnyannni little point in another part of it (3 points and 1200 points), then the minimum may not be able see that this is the point of the map) To avoid this you can make such a move: ckrypt breaks map and displays the firing range or color range, intensity or number of points in a particular part of the map is not showing at this very point. If you zoom the map to a certain limit, instead of landfills starting to see the most points.
If you still remember some chips – will write.
Is it possible to implement all of your service?

Привіт Mixa,
Спасибі за детальне уточнення!
Дуже цікава ідея. Почнемо реалізацію цими вихідними.

Уточнюю ТЗ :)Якщо ви хоч частину з цьтого реалізуєте – ви герої!!! :)

Скажімо, користувач має таблицю типу

Червоноград | Львівська | cherv.jpg | 32.564654 | 45.654476
Канів | Черкаська | kaniv.jpg | 36.654654 | 44.987534
….

Він присвоює передостінній колонці тип поля, скажімо LAT, а отсанній колонці – LONG і отримує карту з точками, дані для яких беруться з таблиці. При кліку по маркеру точки отримуємо опис точки, дані для якого беруться з тієї ж таблиці. Було б добре мати можливість налаштовувати що і в якій послідовності показувати в описі, а що – ні.

Центрування карти. Центр карти або задається вручну, або визначається автоматично на основі крайніх точок.

Готову карту можна інтегрувати на будь-яку сторінку через фрейм, налаштувавши розміри.

Це основа. Додатково ж можна ще зробити супер-навороти…

Якщо точок дуже багато, то зазвичай ініціалізація карти відбувається дуже довго (та й, інокли за тисячами точок просто не видно самої карти). (Або ж навпаки – якщо у певній частині мало точок у порівняннні з іншою її частиною (3 точки і 1200 точок), то при мінімальному зумі може бути не видно, що в цій частині карти є точки) Щоб уникнути цього можна зробити такий фінт: cкрипт розбиває мапу на полігони і відображає або кольором полігону, або цифрами інтенсивність точок в конкретній частині карти, не показуючи при цьому самих точок. Якщо ж наближати карту до певної межі, то замість полігонів починаємо бачити самі точки.

Отакеот. Якщо згадаю ще якісь фішки – допишу.
Наскільки це все реально реалізувати на вашому сервісі?

Здравствуйте, Андрей!
Рада, что Вам понравилось! :)
Яна

Hello Igor!
Happy that you have appreciated my thoughts so greatly. But actually if we can now be “less worried about the forgotten flash” that is your and your team’s merit entirely. Thus thank you very much!
Will be in touch :)
Jana

Привіт, Михайло :)
Дивись
цей топік українською

а ще краще створи аналогічний, щоб можна було слідкувати за повідомленням по емейлу :)

Yes, I’m talking about Google Maps. Hard for me to tell more in English. Can I speak Ukrainian or Russian? :)

Hi Mixa,

Thank you for this request. Are you talking about Google maps? Please can you describe your feature in more details. Maybe you can show me examples.

Thanks for this great write up, Jana!

Thank you for all your good feedback and wishes!

I’m sure a lof of people will find very useful your example.
This is one of the main features of our system – to share data, share files and images for Free.

And your USB example is something we have to spread the word :)
and maybe users will be less worried about forgotten flash at home and use MTH instead :)

Thank you and all the best!

Добрый день Яна,

спасибо за ваши отзывы и приведенные примеры!

Очень удачный пример с флешкой!

Sure, Jana, I’ll be happy to meet you!

We will stay in touch ;)

WOW! Cool! Let’s meet then. ;)
… here in Moscow I mean …

However, maybe it were fine with attachment, because it’s a MTH form and I’m receiving link/notification about attachment via email. Si I were able to see your screenshot. So, maybe it’s fine, it’s some kind of secure attachment, not in all cases you may want to show your screenshots to everyone.
But from your file not clear where is a problem.
Yes we do not showing all fields, we skipping Note, Divider fields, which can’t be used for search.
Also, please, let’s discuss it on another topic if possible :)

Thanks, ttyl

Hi, Asania

As I remember I’ve emailed you the link to our blog post about the way we can create sectioned pages now. However, please, check it again.
If you need something more complex it is not in our first priorities too, so can take up to two months to implement. Or faster in case you put your feature to the top

I do not see your screenshot. This is probably because it is not clear how to use our reply attachment form. When you’ve uploaded your attachment you should see link to it, you have to manually copy it and paste to your reply. We will write howto or faw or blog post for this.

Thanks and talk to you soon.

Hi, Jana!

Great, Moscow!
I’ll definitely visit your capital soon!

Thanks!

Hi!
So I am in Moscow, Russia.

Hi Igor,

This is low priority but my business we wanted to know when the sectioned pages option was going to be implement as our page is very long and we want to break into sections, where the person clicks ‘next’ to advance to each section.

Also, the ‘Search’ option in doesn’t include all of the questions we place on our form (please see attached screen shot). Pleas fix when you can, thanks.

Have a great day too,
and my day and ‘week-end’ is over, going to home :)

Have a great and productive next week and
talk to you soon!

Asania,

Please, see screenshot below

with my super nice arrow :)
so this is what that option for. Because I though this is what you wanted from the beginning :)

Thanks a lot for your willing to support us financially, because we really need help, much appreciated!

Me and my team wish you all the best with your business and looking forward to see your site!

And you know that you are always welcome to contact us if you need anything else from us!

Cheers!

Hi Igor,

Great! The “Section Heading” is the same color as the rest of the text. The option you put to change the “Section Heading” doesn’t refer to anything though. Will this eventually make it so that you can change the “Section Heading” color different from the rest of the text color? Still, our form is perfect now. I’ll send my business partner a link and ask her what she thinks. Our site is not set to go live until mid-March 2010. When we’re live, I’ll send you the link. Both you and your team have been an invaluable aspect of our business-start-up efforts (many, many thanks to ALL involved with MTH!). I will definitely be supporting you, and your team financially, for all your hard work…as soon as I find out how many Canadian dollars for one Ukraine. ;D Thanks again and have a great day!

I just realized that you were talked about section heading text color. And I though that problem is in the line below it :)

So we’ve fixed it by assigning section ehading text color the same as all your form text color.
However you still should be able to change that line color, looks very nice for me :)

Hope it helps!

Cheers :)

Hi Igor,

I’m glad my suggestions are useful. I tried out the “Section Heading” color changing option and although the color pallet appears fully functional, when I try to view my changes, it’s still “default black” and the color hasn’t changed.

If you keep trying to tweak it, I’ll test it out, later, to see it’s functioning correctly and actual changes the “Section Heading” color. I’ll keep you posted. Thanks! ;D

Hi, Asania

Thanks for another one very valuable suggestion
- we’ve added possibility to change section heading color,
please, find it below highlighted option :)

We’ve just removed top reply link, I think having it at the bottom will be fine.

I’m glad to hear you like highlighted block option!

Please, let us know if you have any other ideas at any time ;)

Have a nice day!

Thanks,
Igor

Hi Igor,

The highlighted block coloring option looks fantastic! Thanks for that.

Just to let you know, the “Section Heading” color is stuck on the color black (as a default) and if your background color is black also, the same issue will occur (your working will disappear). Is there any way you could include a color selecting option for the “Section Heading” text as well?

Also, the “Reply” button at the top of this forum page still does nothing when you click on it. Many thanks again! :D

-Asania

Hello,

we are very interested in this!

To be honest we had no a chance to do it before.
So it can take some time for us to implement this.
It would be great if you can help us doing it by providing some examples or just more information about it. So we can do it faster.

However we will start investigating it and will get back to you soon!

Thank you,
Igor

Hi,

thanks for your questions.

It depends from your database and your needs.

Had you a chance to take a look into our Excel export?

Is there a way to export your data to Excel?
If so you will be able to import this data to MTH then.
And to show this data using database widget.

Also there may be another possibilities,
we may need to provide you some kind of API if needed.
But, please, let us know more details about data you want to use.

Please, feel free to email us if it’s secure information.

Thank you,
Sincerely,
Igor

That programm which you’ve suggested only for windows, nut no problem – I were able to add your radio to my iTunes.

So I’m listening you online! :-D

I’ll definitely check Programma when you will be online and
will use verzoekje!! :)

Between, I like the format, kind of music you playing :)

Cheers!

Hi,

I see your form and it looks great, I can see your logo,
do you still have any problems with it?

Hi, Asania

We’ve fixed it by introducing more flexible way.
You can select the color you wish for highlighting your fields.
Please, find it in for widget settings.

Hope it makes sense for you.

Thanks,
Igor

Thanks, Jana!

Thank you, Tope!

Really appreciate!

Sorry,
but sincerely -
THANK YOU!

HI, You guys re doing a really great job!
However I am going to need till the end of february to do this.
You got my word!
Regards

Hello

Regarding your first question about submitting form and showing result on the same page: please, see redirect to record page option in form widget.

Hope it makes sense for you!

Cool!

We are in Kherson city to be exactly :-D

Cheers :)

MyLaSound radio is located in The Netherlands, Province Limburg to be exactly:-)

Hi Igor,

Great…much appreciated! Thanks for taking my suggestions.

Hi, Asania

Thanks for your feedback!

Actually ‘Reply’ link works, but form appear at the bottom of the page, so you maybe just can’t see it.
However we will think how to improve it. Thanks!

In widget builder you can enable database moderation – your records will need to be approved before they will be shown in the database widget.

And you are right Bann IP is on records page at the right side of each entry. Sure, you can unbann in case of error. Please, click on ‘More’ link at the right side of the entry and you will see the ‘All banned IP’s’ link.
This is the place where you can unbann users if needed at any time.

Thanks for very valuable suggestion about highlighted block.
We will try to do it the way you suggested and get back to you soon.

Thanks and have a good day too!

Hi Igor,

Thanks for following through on the fixes to MTH. The highlighted blocks functions as it should. The only thing is, one can’t use light colored (or white text) otherwise the words will not be visible, or disappear. Perhaps, try making the words grows “slightly” larger as one mouses over each section, instead of highlights, that way people can truly choose what every text color they want.

I see the upload option on the forum, looks great. The only thing is your ‘Reply’ button at the top on the forum, isn’t working (but the one at the bottom is). I see the upload option that was added…thanks for providing that.

I also see the "ban IP’ option, hopefully, there is a way to undo the “ban IP” option, should one of my staff select this in error.

Thanks, again, for all the fixes and hard work and have a great day!

-Asania

Hi, Asania

We’ve fixed that issues with highlighting web form fields.
Please, let us know if it looks fine for you now.

Also, please, notice that we added appload forum attachment form.
It took more time then usual because we wanted to use MTH functionality for doing this. This is why we’ve added Redirect to entry page option to widget builder for being able to redirect to the attachment entry after uploading.

You can also use this feature for showing your users what they just submitted to your database.
For adding attachment to topic you have to upload you file and copy/paste this file URL to your topic body.

Also we’ve pushed few new security features.
Database moderation and Bann IP.

Again it may be useful for you to avoid showing not moderated records in database widget. Or if you can bann users using their IP addresses.

Hope you will find it useful.

Please, let us know if you need anything else.

Thank you,
Sincerely,
Igor

Great, thank you, Mylaya!

I’ll definitely give it a try today!
Cheers!

Hi Igor:-) when you download the program Screamer (thats a free version) you can put in the URL

http://server-11.stream-server.nl:8508

And then just save it as a favourite. So you only have to put on the screamer then and you will be able to listen to us:-)

Kind regards from Mylaya

Hi, LuAnn

Right now you can export all your records and use import to blank project.

However it will not save your form builder or widget builder settings. So this is something we want to work on. It’s a full app backup as I understand.

Thank you and please, let us know if you need anything else.

Sincerely,
Igor

Looks great, Mylaya!

You music database very good.
I’m glad to see that you using MTH web forms as much as possible.
It looks like we have to add few more CMS like features and web sites like your will be able to build using only MTH :-) lol

Please, can you also give us a link, so we can add it to our music player and listen it online? :)

Thank you!

Sincerely,
Igor

We got it, Mylaya

Thank you very very much!!

Sincerely,
Igor

Hi Igor:-)

We are gonna help!

The money is on its way through moneybookers.com

Kind regards,

Mylaya

www.mylasound.nl

Hi,

We are happy to tell you that we did what you asked.

Please, about how to moderate database input and block spammers features.

Hope you enjoy it!

Sincerely,
Igor

Hi, Mylaya

Please, read our blog post about new Database moderation and block spammers IP features.

Hope you find it useful!

Sincerely,
Igor

Sure, we will add attachment field to forum posts very soon and will get back to you to get screenshots, thanks, Asania!

Hi, Mylaya

Thanks for posting your feature request here!

Actually you should be able to see users IP on Records page.
Please, notice ‘More link’ at the right side of each entry.

However, as I understand you need more then that.
We already have this approve adding records feature request.
So there is something similar between this tasks.

Do you need this ‘Bann IP’ feature only inside MTH, or do you want to see IP and ‘Bann’ link right into your integrated widget at the right side of each record, or on the widget record page. I mean the page, which you see when you click on record number.

Thank you, we looking forward to introduce this feature.
I’m sure it will be very useful and allow working with records submission fit todays needs.

P.S. Your site and both forms and database looks great and it is one of the best examples how MTH can be used! Please, consider posting your site link, and probably links to all your forms to our Examples forum page.

Sincerely,
Igor

Please, read this blog post for more details. Remember to change Thank You message ;)

That’s quite easy. Just add Table field and set columns and rows on it. Then you will be able to populate it with any information you need.

Please, read blog post for more details. And feel free to post your comments and questions then.

Yes, we have a plans in the next month to work on the different dat views.
I agree that we should be able to hide column names and sorting and we will definitely implement it within next month.

Thanks for your valuable suggestions!

I see how you can customise it, but how about going that little bit further?

What if i want my displayed results to look ‘less’ like an excel spreadsheet, and ‘more’ like my own implemented design.

Here are some displayed results examples:

http://www.thatsmelbourne.com.au/DiningandNightlife/Nightlife/Pages/Nightlife.aspx

(in the above link, see the box “This week’s picks”..?? How about if i wanted my results to look just like that)

So i want to keep the data/ content, but not have the main bar with the sortable field names on it, and maybe i want to arrange where the content is placed.

To me it still looks like an excel spreadsheet, embedded within the website of the Game & Student sites.

Is this changeable?

Thank you for this example!

Sure, we understand and it definitely makes sense to implement this.

We will start working on it and get back to you asap!

Thank you and talk to you soon :)

Okay,

I might need some assistance with the data integration.

But i’ll explain further as to the type of thing I am looking to do.

Go to the following site: www.carsales.com.au

There is a drop down list for “Make”, which has every make/ brand of car available for sale. So I will select “Toyota” as the car ‘make’.

The next drop down box is “Model”. If I had selected “Any Make” in the previous “Make” drop down box, the model of every car available for sale would have been displayed. However, since I selected “Toyota” as the ‘Make’, only “Toyota” branded car models are available to select in the ‘Model’ drop down list.

Then I click on the “State” where I am located in another drop down box, then the next drop down box after that is titled “Region”, and only regions from within my selected state appear in the list.

This way, the data is sorted dependent on the previously selected options.

There may also be circumstances when I would need to select multiple options, for example, if I wanted to purchase a Toyota Celica or a Toyota Supra, then perhaps having the functionality to Ctrl-Select multiple car makes/ models would be ideal!

:-)

Hi, Leanne

You can integrate both form and database widget on the same page.
Just copy widget code from Form and DAtabase widget in MTH and palce to your web page.
Once you will neter some data to your form and refresh page it will appear in your database widget as well.

You can edit look & design in the Widget Builder, or you can apply your own styles.
Please, investigate how our users do it. Please, see few examples below or get back to us.

Game site

Students site

Online radio

Hope it helps!

Thank you!

Hi, Leanne

Thanks for posting your questions here!

Sure, you can have database linked to your website.
You can find the way to do it in Widget Builder.
Please, see Database Widget section.
Same with form, see Form Widget.

You can embed your form for data input and below, in the other section, have database integrated.
So, when any new entry will be added using form it will be seen below in database section.

Regarding your drop downs questions: it’s not possible right now. However we very interested in implementing it.
Now you can achieve this by creating several forms. If you can provide any screenshots, more examples it will be very helpful for us so we can build exactly what you need.

Thank you!

Hi, David

Thanks for your great feedback!

This is probably because you have disabled cookies.
Please, see small ‘cookies required’ link at the bottom right side of your search form.

Hope it helps.

P.S. You have amazing integrated both forms and database, one of the most beautiful I saw! :)

Thanks!

Привіт, Сергію!

Дякую за чудове питання!

Так, звісно, ми додамо форум для українських користувачів.
Але це буде окремий форум, скоріш за все він буде знаходитись за адресою
http://mytaskhelper.com/forums/uk

Hi, Mikie

Thanks for contacting us!

Thank you for your good feedback, very important for us!

Actually we have unique number on each row.
You can find it using ‘More’ link at the right side of each entry on Records page.
It’s not really clear for me how users will use it. You will share your issues table and they will refer to entry using this number?
But why to do not use just row number? Please, let me know. Maybe we will need to add an option to include this existent unique id to database widget.

Regarding automated emails. You can’t do it now, but we very interested in it and will work on it.
Please, feel free to contact us at any time with any other questions or suggestions.
Thank you!

Hi, I have created a registration form which is great!, thanks for that but one of the details I ask for is a logo image but didn’t work, I got nothing. Then, I tried asking for the logo url but the same problem, no image or url displays. Is it possible I’m doing something wrong?
Thank you and I’m sorry for my poor English

Thank you for your suggestion!
Makes sense for us.

We will definitely implement it for you!

Hi,

Right now you can’t do it. But we are on the road of doing it. We working on improving search which will give us ability to work with different views later.
Stay tuned!

Done

Ok, will be done tomorrow.
Thank you

We are happy to tell you that we’ve implemented this.
Please, try new search or read more about new database search
here

Hi,

thank you for your suggestions.
Not clear for me, are you talking about date ranges?
Do you want to select search date field and select date ranges then to search for some records between that range?
If so it definitely makes sense and we will implement it for sure.
Thank you,
Igor

nice, thanks but there is a problem still now. i just tried with a new form in my account. it shows me unnecessary fields on top of my specific searched data, also it shows all fields in the drop down list…

Hi, Rasel

We’ve implemented your suggestion.
Please, go to Widget Builder and see option ‘Allow database in a records widget’
Make sure to reload page to see your changes in action.
Cheers

Hi, Igor

We have done it.
Now you should be able to change background and add a logo to your form.

Enjoy!

Sincerely,
Igor Petrushenko

Agree completely.
Feel free to contact me for further details you want to see in MyTaskHelper.com

Sincerely,
Igor Petrushenko

Implemented,
please, check this out and let me know if we need anything else

Sincerely,
Igor

Agreed
Will implement asap

Thank you

Done,

please, review if it works for you now.

Thank you,
Sincerely,
Igor Petrushenko

Agreed,
will be implemented as soon as possible.
Thank you for your valuable feedback and pointing to this defect.

Sincerely,
Igor Petrushenko

We added unique id to the records list.

We added export to XLS from records page

Added Team page, where you can invite members, and promote/demote team members to owners/members. Members can only view records, and couldn’t edit something.

MTH Team located in Ukraine :)

Everything you can dream on can be done, but first think twice if anyone else may want it too!

But, please, do not hestistate to report any findings on this forum.

Please, feel free to reply with any suggestions about this form here.