Marking a record using a field rule

[noldfield]

I want to mark a record using a field rule when the record changes, but setting up the field rule asks me to specify a form name and of course there is no form.

[Ted Giles]

Table.mark function in the documentation.

[noldfield]

thanks. I had been looking for some way of marking a record and I thought table.mark was only marking tables not individual records.

next associated issue: if I try to set up only marked records in my export operation, the setting does not work. I use the genie which gives me a list of additional filter options but when I select marked/unmarked the select criteria (where I would expect to see a setting for marked or unmarked) is from some other option, and if I reselect it I get another corrupted criteria .

[noldfield]

If I add marked to the main filter criteria when I call the export function, it works fine. But not if I add it as an additional criterion through the export genie.

[Ted Giles]

I have to admit that I would probably choose an easier way than using MARK/UNMARK (Ctrl+M, CTRL+U)
Can you outine the process please?

If I wanted to export records which have changed, I suspect that I would;

Create a 1 byte field in the record call it "Changed"
In the table Field Rules, I would update that field with "Y" if changed in the Record Events.
Run an extract where Changed Field value = "Y"
Reset Change Field to "N" for all records.
That way you don't need to code anything really, Nick.

When you choose the records to export, there is a setting Select Records, Marked/Unmarked, Select Marked in the next UI.
It definitely works.

[noldfield]

I should have said I was only interested in changes to certain fields, which need to be exported to another application via a csv file. . Not sure there is much difference between what I implemented this morning and your solution.
In the field rules for the selected fields I mark the record when the record changes. Then when I do the export, I filter out every record that isn't marked.

In my release of Alpha 5 (which is an old one) the setting you referred to does not work, the settings field is corrupted. It does work however if I just add it to the main filter for the export.

Thanks for the help!!

[Ted Giles]

What version are you on.
I only tested on V11.5

[noldfield]

It's working, thanks....