-
Notifications
You must be signed in to change notification settings - Fork 0
pts tutorial2 module16
(Continues on from the "Database" script - requires you to follow the previous section first)
| The following commands are used in this module: FIELD LONGDATE_FIELD TALK_THEME |
|---|
Don't those dates from above look a bit funny? Not exactly a format you're used to seeing dates in. You may have noticed on the FIELD window that you could choose the format of the field.
Do the following: Go back to the FIELD command. Double-click it to edit it. Click the Long Date option. Click Update. Look better now? |
|---|
Don't get this date confused with the one we saw near the beginning of this tutorial. That date was taken from your system clock (today), or from the range you specified before opening the script. This date is taken from the database, and is the actual date stored in the table.
But whoa! Our FIELD command just changed to LONGDATE_FIELD! Don't panic. It is just a special type of FIELD to help the parser know what to do with it. Don't let the fancy name put you off. It still behaves exactly like FIELD, except for how it formats the chunk of text. Similarly the other formats produce their own variations. |
|---|
CUSTOMDATE_FIELD's special formatting parameter is covered elsewhere in this help documentation, so it won't be covered here. Notice how these adaptations of the FIELD command are like the DATE command changing depending on formatting and source.
Want to know what Talk theme name is for? Edit the LONGDATE_FIELD command. Choose Talk Number as the field instead of Talk Date. Select "Don't interpret, use contents as is" to begin with. Update it. Edit the TEXT command to say "This row's talk is: " instead. A nice set of talk numbers, eh? |
|---|
Now try it again: Edit the FIELD command. Format as a Talk theme name. Update it. It translated our talk numbers into proper talk names for us! The parser holds the list of defined talk numbers and their corresponding titles (names), as defined on the Maintenance window - thus, it can translate for us. |
This is probably giving you a headache; take a break - there are probably more headaches to come (sorry!).
| Now, please: Click Save Script click Close Script Then when you are ready continue with final module 17. |
|---|
| Previous Module | Next Module |
|---|
Copyright © 2002 - 2025 by Andrew Truckle. All Rights Reserved.
- Using Public Talks
- Main Application Menu
-
Database Ribbon Panel
- Assignments Editor
- Backup Database
- Check Talk Exchange
- Compact Database
- Convert Database
- Create Unassigned Date Entries
- Database Security
- Maintain Databases
- Purge Database
- Rearrange Dates
- Restore Database
- Help Ribbon Panel
-
Home Ribbon Panel
- Create a Report
-
Manage Custom Reports
- Editing Scripts
- Content Ribbon Panel
- System Ribbon Panel
- Script Command Syntax
-
Tutorials
- Using The Script Editor
-
How To Write Scripts
- Module 1 - The Basics
- Module 2 - Hello, World!
- Module 3 - Multiple Text Blocks
- Module 4 - It's A Date, Then
- Module 5 - Oh, I'm Blushing!
- Module 6 - It is a Rainbow!
- Module 7 - The Font Of All Knowledge
- Module 8 - Queue To The Right
- Module 9 - Memory Like An Elephant
- Module 10 - May I Squeeze In There?
- Module 11 - Move Over, Please
- Module 12 - You Move Over Here
- Module 13 - Is My Back A Funny Colour?
- Module 14 - I'm Going Loopy Here!
- Module 15 - Fields Of Golden... Text
- Module 16 - Man, That Looks Weird
- Module 17 - Inner Peace, Inner Loop
- Advanced Script Features
- Quick Access Toolbar
- Settings Ribbon Panel
- Tools Ribbon Panel
- Revision History
- Contact Information
Do the following: Go back to the FIELD command. Double-click it to edit it. Click the Long Date option. Click Update. Look better now?
But whoa! Our FIELD command just changed to LONGDATE_FIELD! Don't panic. It is just a special type of FIELD to help the parser know what to do with it. Don't let the fancy name put you off. It still behaves exactly like FIELD, except for how it formats the chunk of text. Similarly the other formats produce their own variations.
Want to know what Talk theme name is for? Edit the LONGDATE_FIELD command. Choose Talk Number as the field instead of Talk Date. Select "Don't interpret, use contents as is" to begin with. Update it. Edit the TEXT command to say "This row's talk is: " instead. A nice set of talk numbers, eh?
Now try it again: Edit the FIELD command. Format as a Talk theme name. Update it. It translated our talk numbers into proper talk names for us! The parser holds the list of defined talk numbers and their corresponding titles (names), as defined on the