Jump to content

Adding to text rather than writing over


This topic is 7869 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a field that receives today's date when I send a thank-you letter, thus a flag that the letter was sent. Now, a few months later, I want to send another thank-you to the same person. I want the new date to be ADDED to the previous date (both dates now appearing) rather than writing over the old one. How do I do it?

Thanks in advance. Maxwell Morlay

Link to comment
Share on other sites

Here is a solution:

I use a french version, so I hope my translation will be fine.

Create a text field called "date of day copy".

Then create (or use) the date field "date of day1" that is an automatic entry (modificable) and a second date field "date of day2"(with automatic entry -modificable).

In the field setup, uncheck "select all text" for both field

Then do the script (summary)

Letter 1 :

Copy "date of day1" into "date of day copy"

Letter :

Select "date of day copy"

Insert date of day (which is a script)

Link to comment
Share on other sites

Oups ! Sorry I post it without previewing it.

Here is a solution:

I use a french version, so I hope my translation will be fine.

Create a text field called "date of day copy" and place it into the layout.

Then create (or use) the date field "date of day1" thatwill be an automatic entry (modificable) for the date of the first letter and a second date field "date of day2"(with automatic entry -modificable) for the second letter sent.

In the field setup, uncheck "select all text" for both field

Then do the script (summary)

Letter 1 -Script 1

Activate (select) "date of day1"

Copy

Activate "date of day copy" (unselected)

Letter 2 -Script 2

Select "date of day copy" (unselected)

Insert date of day (from scriptmaker)

I try this one...that works...but try even more simple

Activate "date of day copy"

Insert date of day (from scriptmaker)

If select all in setup field is unchecked, the date will appear close to the other (there is no space though)

Link to comment
Share on other sites

Thanks for responding. Sorry, I'm having some trouble understanding your suggestion. Maybe I didn't provide enough information. The following is my process:

I click on a script that takes me to my thankyou letter. It prints it, then takes me back to my "Data-Entry" layout which contains a "Date_ThankYou_Sent" field. Today's date is entered automatically. A month later, I want to perform the same script, and when it comes to the "Date_ThankYou_Sent" field, it will ADD today's date to last month's date. At present, it writes over last month's date. I want a record of all thankyou letters sent. Maxwell Morlay

Link to comment
Share on other sites

>I click on a script that takes me to my thankyou letter. It prints it, then takes me back to my "Data-Entry" layout which contains a "Date_ThankYou_Sent" field.

Create a "HistoryDate_ThankYou_Sent" field that would be text formated (no date) and place it in the layout. Go in setup and uncheck at the bottom of the window "Select all text" (translation from french?) but check "Allow entry"

>Today's date is entered automatically.

I imagine you created that field as an automatic entry "date of day" in the field definition. Make sure you uncheck "Non Modificable" option

Ask the script to :

select Layout "Data Entry"

go to "HistoryDate_ThankYou_Sent"

Insert Today's date (available in the scriptmaker menu)

The result will be : "HistoryDate_ThankYou_Sent" : "11/07/02"

and "Date_ThankYou_Sent" : 11/07/02 (as an automatic entry)

>A month later, I want to perform the same script, and when it comes to the "Date_ThankYou_Sent" field, it will ADD today's date to last month's date.

Perform the same script on the 12/07/02

Ask the script to :

select Layout "Data Entry"

go to "HistoryDate_ThankYou_Sent"

Insert Today's date (available in the scriptmaker menu)

The result will be : "HistoryDate_ThankYou_Sent" : "11/07/0212/07/02"

and "Date_ThankYou_Sent" : 12/07/02 (as an automatic entry)

Then you would have to perform another script to create a space every xx/xx/xx (8 characters) -

Ask the forum for this one. I'm a beginner...

The thing is you have two fields in the same layout (one date, another text formated)

Hope this will help

Link to comment
Share on other sites

You will need to make a change to the script that sets the date and change the "Date_ThankYou_Sent" field to a text field.

I am assuming that your script has the step:

Set Field["Date_ThankYou_Sent","Today"]

Change the step to the following:

Set Field["Date_Thankyou_Sent","If(IsEmpty(Date_Thankyou_Sent),DateToText(Today), Date_Thankyou_Sent &", " & DateToText(Today))"]

An example of the result is:

11/7/2002 (if this is the first time the script is run for the current record)

10/7/2002, 11/7/2002 (if this is the second time the script is run for the current record)

If you want the dates to appear as:

10/7/2002

11/7/2002

replace ", " with "

Link to comment
Share on other sites

This topic is 7869 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.