I see. Thank you for the clarification.
You have done a very nice job on the beta. Is there a beta forum for discussing the enhancements? I thought a full calendar would be included in the new release. Guess not. Jon |
Quote:
On the beta page we're instructed to direct communications to Kinook Support, which is understandable and I'm hesitant to pollute this board with discussions that are being quickly resloved, but there are other aspects of the beta that may benefit from user discussion - public or private. |
Quote:
Armstrong |
So how -- in your opinon -- would / should this be resolved?
For example, I have a couple of questions about how to use a few of the new tools & I don't want to bother the developers with that. OTOH, I do post giltches, etc directly to support as requested. |
Quote:
|
Feel free to discuss questions about the beta in this thread, but please continue to report bugs directly to us. Thanks.
|
Feeling Free
OK, what does this mean, do? Example?
"Support user-defined formatting of item title" I assumed it meant I could format an item title but if I select item title, no formatting functions are available via menus. Feeling dumb in Ridgefield. |
Re: Feeling Free
Quote:
This refers to creating a Title Expression (from Attributes) for an Item's Title. In the beta Help file see Getting Started | Basic Concepts | Templates | Custom Item Titles. There are some good samples to build on, but I'm a little sketchy of the syntax beyond what's provided. |
hmmm, I'd be interested to know how to force UR to use the new rules for item title. I tried to change the template, but new rules are not applied, and the old title based on "Item title" remains.
ps: I find the rules for creating Item Title pretty straightforward, just check the provided examples if sth is not clear |
Geeez... First thing I had to do was look up the word coalesce.
I mean that whole set up is so geeky as to be waaaaay over my head. I guess.... and it is a guess... is that it's a way to create an item title by combining the data that is input into the form. Am I close? |
Quote:
|
Quote:
If the template is no longer using the Item Title attribute for the title, you can delete it from the template to avoid confusion. AND If items already exist for the template when you change the Title Expression value, the titles are not automatically refreshed for the existing items until you change an attribute value that is part of the Title Expression. ========== At the Template level, if you use a Title Expression you might want to delete any value that is present for Item Title and/or remove the Item Title from the assigned Form for that Template. Deleting the Item Title value for a Template will force a default title of "(Untitled)" for a new Item until values are present for the Attributes used in the Title Expression. Perhaps if Item Title were read-only (EDIT: on a Form) when a value is present for Title Expression... I'm also wondering if there isn't some way (programatically) to "Apply" a Title Expression to exisitng Items, but this assumes that all existing Items have the proper values in the Attributes that are used to create the expression - applying a Title Expression to exisiting Items could be a boon or a bust. |
Quote:
trim(coalesce([Last Name] || ', ' || [First Name],[Last Name],[First Name],[Company],[Email (Work)],[Email (Home)],'(New Contact)')). |
Quote:
I probably should've left this off, but I was thinking of a case where a user may have used the same field for different types of data. Granted not a good idea, but I've seen it happen. Just trying to think of a senario where applying a Title Expression to exisitng Items would lead to unexpected problems. |
Quote:
It may help if you break an expression down into it's parts, for example the Title Expression for the default UR Contact Template: trim(coalesce([Last Name] || ', ' || [First Name],[Last Name],[First Name],[Company],[Email (Work)],[Email (Home)],'(New Contact)')) Let's look at it another way: Code:
trim( In the above example the coalesce function will return a value that will be acted upon by the trim funtion. coalesce(value1,value2,value3,...): uses the first non-null value in the provided values, from left to right. This is kinda like an if,then statement - if the first value returns null (blank), then try the next..., if all values return null, then use the "fall-thru" value which in this case is (New Contact). The first value in the above coalesce statement: [Last Name] || ', ' || [First Name], demonstrates the text concatenation operator: || (Note: a NULL || anything equals NULL) Quote:
coalesce(': ' || [Type], '') It may help if you create a new database and construct it according to this example from the help file: A title based on 2 or more other attributes: Assume a template contains a Part Name attribute, a Size attribute and a Type attribute and the title should be equal to Product: Type: Size. Create a template with a Title Expression value of: [Part Name] || coalesce(': ' || [Type], '') || coalesce(': ' || [Size], ''). Then create some Items from this template and see how the Title Expression works, especially if you leave out values for (Type) or (Size) in a record. Anyway, that's as far as I've gotten. |
All times are GMT -5. The time now is 06:56 PM. |
Copyright © 1999-2023 Kinook Software, Inc.