Re: Question about multi users and using flags

Usually tagging of records in a multi-user environment requires the
following;

Fields
ID (unique serial #)
TaggedRecords_g (global text field)
DisplayTag_c (calc with formula
If(Patterncount("¶" & TaggedRecords_g, "¶" & ID & "¶") > 0, 1,
"")

ValueList
One (custom values with only the value "1")


The field "DisplayTag_c" is displayed in the list view and formated as
a checkbox and attach to it the valuelist "One". Attach to this field
the following script;

If(IsEmpty(DisplayTag_c))
#Need to tag the record
Set Field "TaggedRecords_g" to TaggedRecords_g & ID & "¶"
else
#Remove the ID
Set Field "TaggedRecords_g" to Substitute("¶" & TaggedRecords_g,
"¶" & ID & "¶", "")
EndIf
Commit Record Request


Since a global value is unique to each user the field "DisplayTag_c"
will show the record as tagged for me if I tag it but it won't be
tagged for you even though were looking at the same record. To find
the records I tagged, simply go to related records using a relationship
between the field "TaggedRecords_g" and "ID".

You should be aware that the values in the field "TaggedRecords_g" are
carriage return separated and MUST have a carriage return as the last
character OR the field should be completely empty.

.

Relevant Pages

  • Re: mutt: thread reconstruction?
    ... >> I'd like suggestions on how I might go about restoring at least ... >> this matter. ... > Tag the message you want to attach to, scroll down to the top message ...
    (Debian-User)
  • Re: "Insert Hyperlinks" Causes Front Page To Crash
    ... if the behavior is duplicated it's meta-data... ... > corrupted cache on your computer.) ... Look for a file with carriage returns in a meta-keywords or meta-description ... Either remove the tag entirely or just the carriage return and the ...
    (microsoft.public.frontpage.client)
  • Re: Policy routing idea (Was: ipfw: Would it be possible to continue processing rest of rules after
    ... >> yes i think you should reuse the tag, just add a new opcode so that ... >> the action is attach the mtag to the mbuf if not there yet ...
    (freebsd-net)
  • Re: SmacBook
    ... a carriage return. ... (with sound effects of course!) ... I'll only consider it when it comes with a long chromed lever, ... Does your iMac have the magnet on the RHS so you attach the remote control? ...
    (uk.comp.sys.mac)
  • Re: recordset fragility
    ... Only if they are surrounded with a tag, which I thought you said you ... space, not a carriage return. ... textarea is NOT the same as a in HTML. ...
    (microsoft.public.inetserver.asp.general)