Hello,

Vraag 1 :

In een form heb ik twee datum velden :

Datum1 = datum die ingevuld wordt bv 05/01/2010

Datum2 = computed = datum1 + 250 dagen

Wie kan me helpen want op het net vind ik geen oplossing en met

@ToTime(@ToNumber(datum1)+250) lukt het niet

Vraag 2 :

Ik wil de inhoud van een kolom van kleur laten wijzigen afhankelijk van bepaalde waarde

Hoe doe ik dat?

Alvast bedankt

Charlie

Hoi, beetje kort antwoord want ik ben bezig met een opdracht:

Antwoord 1:

Datum1 = datum die ingevuld wordt bv 05/01/2010

Datum2 = computed = @Adjust( datum1; 0 ; 0 ; 250 ; 0 ; 0 ; 0)

Antwoord 2:

Hier verwijs ik naar de Designer help:

Setting column colors programmatically
In Notes client applications, you can set a column's background color and text color programmatically by selecting the "Use value as color" option on the Info tab of the Column Properties box and then supplying RGB coordinates in the Programmer's pane as the value for the column.
Note  This feature is supported on the Web, but you must supply the RGB coordinates of the color as a number list (e.g. 255:0:255).  Text color values (e.g. "FF00FF") are not supported.
If you specify one set of coordinates (three numbers separated by colons), the color defines the appearance of the text. If you specify two sets of coordinates (six numbers separated by colons), the first set of coordinates defines the background color for the column, and the second set of coordinates specifies the text color. The color affects the column where you set the color value and all columns to the right of that until another color is set.
Note  Setting colors to -1:-1:-1 reverts to the view and column properties.
For example, the following formula example shows how RGB coordinates can be used in both single and paired sets.
red := 255:0:0;
blue := 0:0:255;
yellow := 255:255:0;
pink := 255:193:253;
white := 255:255:255;
black :=  1:1:1;
apricot := 255:155:133;
plain:= 0:0:0;

@If (category = "cats";blue:red ;subcategory = "collars";pink;subcategory  ="leashes";black:plain;0:0:0);
Note  You do not need to define the color names -- you can enter the numeric combinations directly into a formula. However, defining the colors makes it easier to see what you are doing and reduces the possibility of a typing error if you are using the same color more than once. While defining the colors makes it easier for you to use words rather than number combinations, the color column sets does not display the data itself. To display the category "cats" in red, for example, you would need a subsequent column that is set to display the category.
You can also set the column value equal to a field value that supplies RGB coordinates. You can use this feature in conjunction with the color field to allow a user to set a color with a color picker. You can then apply that color to a view component -- for example to the text in a column. For information on using this feature to make view colors customizable, see "Allowing users to set colors in a view."

Marcel,

Bedankt voor snelle reactie

charlie