I have a form with a date filed (Read Date). For most records this field is blank. When I created a layout on my iPad (3 columns), it puts in today’s date in each record that had blank dates. I do not have “use today’s date” selected. So the iPad Layout will show today’s date when the date field should have been blank. When I switch to the default layout (Main Detail), it shows the date field as empty (which is correct). See attachments.
Attachments:
You must be
logged in to view attached files.
Hi Cliff,
Ya, that’s something I need to work on. I need to build the same kind of date field entry as is on the Default Layout. Right now it’s just using the built-in data controls that Apple provides, so that’s why it’s putting in today’s date for empty date fields. I’ll work on that. It was on my to-do list.
Thanks,
Brendan
Also glad to see you’re trying out Universal Layouts.
It was on my to-do list.
Thank you. Since I’m just testing universal layouts, I’ll not use the date field for now, except for those db’s where I always have the date field filled.
Also glad to see you’re trying out Universal Layouts.
I like this feature. Can’t wait to see what you can do with this.
Taks care.
Hi Cliff,
As a temporary workaround, you could use a calculation field that creates a date string that will display on your Universal Layout. This is just for displaying!
Here’s the formula: IF ([Date] = 0; ""; DATE([Date]; "MMM dd, yyyy")). With [Date] being your date field. When your date field is empty (eg, set to 0), an empty string is returned. Otherwise, a date string is created with the given format.
Cheers, Daniel
---
See https://lab.danielleu.com/tapformspro/ for scripts and tips&tricks
you could use a calculation field that creates a date string that will display on your Universal
Thanks Daniel. I will try this and report back.
I tried the formula. I created a DateCalc field as a formula field. I initially had “0” when the Date field was empty, but where the Date field had a date, the DateCalc field was empty. Then I tried this and every DateCalc field shows “Dec 31, 1969 at 6:00:00 PM”. Obviously I have something set wrong. Then second attachment show the settings for the DateCalc field. Can you identify anything wrong? I appreciate your help. — Cliff
Attachments:
You must be
logged in to view attached files.
Hi Cliff,
When you click on a function on the right side of the Formula Editor screen, you’ll see it tells you what type of value is returned from that function. In your case, you’re telling Tap Forms the value should be a Date, so you have the Result Type set to Date. But the DATE() function actually returns Text. So you need to tell Tap Forms to return Text instead of Date.
Thanks,
Brendan
Also, you should use IFEMPTY() or IFNOTEMPTY() to check for empty date values instead of IF DATE = 0.
you should use IFEMPTY() or IFNOTEMPTY() to check for empty date values
I reset the Result to Text and changed the formula to use IFEMPTY().
Works great. Thank you and thanks Daniel for the suggestion and initial formula.
Sorry, I forgot to mention to set the return type to text. Great that you got it working!
Cheers, Daniel
---
See https://lab.danielleu.com/tapformspro/ for scripts and tips&tricks
At first I had set it to number (I think that was the default). Then I set it to date. So I had 3 choices and I picked the 2 wrong ones. Oh well.
Again, thanks for your help.
Basically the function definition on the right (at the bottom) tells you what Result Type you should use.
.
