Log In

Log In



Not registered yet?


Reset password Activation link
Forums
Tag "date"

Hidden field option

Publication date: August 15, 2018

Hi,
On a previous interface of MTH there was an option to make a field hidden, and only shown in records for admin. I used it before in a “Date” field.
However, on the newer interface, I can’t seem to find that option. I scrolled through the menu (attached) but can’t find the checkbox with the Hidden option to make field in the form hidden.

Any help is much appreciated.
Thanks.

Today as a Constant for Formulas

Publication date: August 8, 2018

Dears, good morning!

I am very satisfied with the MTH. It has been very helpful to me.

(1)
But I need some help on the following:
On a form I enter a date of a day that has already passed. Ex: 20/12/2017 (data1)
In this same form I need a formula that points me how many days have passed from “date1” to the current date (ie, today). Ex: data1 – data2 (today) = 51
Remembering that the “today” date needs to be updated daily. I have tried to put “date2” as the default for today, but the calculation does not work.

(2)
When I signed the plan there was a free 2 month promotion for annual subscriptions. It seems that my account is valid for only 1 year, not including 2 months free. Can you check that?


I’m using the translator.


Thank you very much for your attention.

Rodrigo

Drop down menus and dates

Publication date: August 10, 2018

Is it possible to have drop down menus appear in forms/reports as drop downs right on the page, without having to click on the field and then click on the drop down? It would be one less click.

Also, is there an option in date fields to have a calendar date picker pop up, rather than a three column selector?

Thanks.

Formula: How many days between last updated date (or any given date) to today's date?

Publication date: August 13, 2018

Hi Igor,
Thank you for your answers to my earlier question.
I feel I have now learnt a lot about the logic of team and reports as well as formatting rules etc, as well as importing tables etc.
I have been glad to see that the software works really smooth and quick and there are many quite advanced options and functionalities.
I have also some ideas how to work-around some of the problems regarding emails to invited new members. I can share those ideas with you when I have tested them.

Question: How can I create a formula where i count the days since a given date?
We need to track progress of our projects and see easily how long time has gone since signing a contract for instance, or how many days left to a deadline as another example.
For that I would need to calculate the time between the dates given two date fields, where one date field would today’s date.

Can you give me some advice please?

Best regards,
Björn

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!

Your SaaS product

Publication date: August 14, 2018

Nice product, a little trouble with the date when trying to enter and SEND disappearing. One question, SMS makes no sense to me with “-”… .20 cents per sms?

Does the legend below the form go away if you buy in?

Bob

DATA FORMULARIOS

Publication date: August 15, 2018

FRIENDS
HOW TO CHANGE THE DATE OF ENGLISH TO PORTUGUESE IN FORMULARIOS FOLLOWING DD MM YY


LUCIDIO

Reminder based on a date in the past

Publication date: August 15, 2018

Hello,

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

Best Regards
Dawoud

Cant add this report?

Publication date: August 16, 2018

Hi

I want to add a report with an equivalent of:

WHERE Ratio<0.9 AND Recorded>=Date()-3

Is this possible in MTH?

Limit Date Acceptance on a Form

Publication date: August 16, 2018

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

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

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

Date Format

Publication date: August 16, 2018

I would like to use this date format: DD/MM/YYYY, I modify the form on PC, but when we create a new record on smartphone the date format becomes MM/DD/YYYY… Can you help me please…? Thank U

Formula and Date Issue

Publication date: August 16, 2018

1) When adding a date field set to dd/mm/yyyy format into a formula the result always expresses as yyyy-mm-dd format – which is OK for the USA but for other countries is not friendly. I have tried various date formats to effect the result but always does the same.


2) When using a formula field to subtract dates, the math only works correctly if both dates are in the last half of the month.

Date Sorting Not working?

Publication date: August 16, 2018

Hi,

I have a problem with date sorting. It doesn’t sort. I sent you the link to my project but also am posting it here too. When I hit sort, the dates don’t line up.

Formula Field Date Issue

Publication date: August 16, 2018

Formula Field using Date. When including a DATE field into a formula MTH does not retain the format for date as set in the date field parameters, making the resulting data difficult to read.

Issues with Date Field

Publication date: August 16, 2018

Field rules that evaluate a Date field that is set to default content do not work if the condition is based on the date=empty parameter.

Date Field Bug

Publication date: August 16, 2018

Another new bug relating to a field that did not have one previous to this MTH release. DATE FIELD.
1. If date field default set to TODAY then the string “Today” writes to the database.
2. If change system date to another future date, then all fields still reflect “Today”.

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.

Database Time Zone

Publication date: August 16, 2018

I used today as the default date feature and it moved it up a day. What time zone is the Database in and if its not correct how do I switch it to EST USA

Date Format

Publication date: August 16, 2018

It would be nice to be able to format the dates using the US style of mm-dd-yr.

I see that the birthday calendar uses the US format, but unfortunately includes the baby:) thing too.

Date format for Birthday

Publication date: August 16, 2018

The format for birthday is DD-MM-YYYY, whereas, most people in the U.S. are used to MM-DD-YYYY. Please allow the User to either set a preference or, just use what their PC settings use.

Default Date

Publication date: August 20, 2018

Currently you can setup a default date using “Yesterday, today, tomorrow, or next week”.

It would be nice to be able to setup a specific amount of days, weeks or months. This way we could automatically setup a due date by default.

For example if we setup 3 months as default and today is Nov 23 the default date would be Feb 23. (Today+3 months).

If you need extra information I would be glad to provide it!

Feature Request

Publication date: August 20, 2018

I’d like to see a more interactive feature request forum with a “Date Added” column (and have the initial default show the latest requests first). As it currently works visitor don’t see new requests (and have the opportunity to vote for them) unless they browse all requests, which pretty much makes the voting irrelevant.

Other form/database site forums have this, thus making the feature requests and/or help forums an excellent learning environment.

Sort after Grouping

Publication date: August 20, 2018

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

Today filter, search, grouping

Publication date: August 20, 2018

it would be great to be able to search, filter or group not just by Date, but using Today, Next Week, Last month filters.

Set default date to "today"

Publication date: August 20, 2018

Is it possible yet to set the default date to “today” when a new record is added?

— Maria Korolov
President, Trombly International