- December 21, 2009 at 9:53 am #380
I have an employee database (employee_name, data 1, data 2, etc.)made up of a form instance for each employee. The database is usually accessed by another form through a connection which searches for a single name and returns all the data plus the instance ID. This second form can then update some of the data. This all works fine.
I have a requirement to access EVERY form instance of the database and update one of the data items based on the value of another data item (in the same form instance). Is there a global way of doing this without having to select each form instance by employee_name one at a time, and if so can it be done from a report (acting as a portal).
ThanksDecember 21, 2009 at 10:11 am #4981
not actually sure what you mean by ‘global’ as it seems that what you want to update may not be exactly the same for each user, but you could read your data in to a TABLE object on your form (or report if you wanted) so all the instances are returned into a row in the table.
from there, then possibly a script that you could run that can manipulate the data in the table columns (if the rule to ‘update’ is consistent for all) followed by updating the instance on a row by row basis..
have a look at the ‘Set Table Rows Properties’ /Documentation/manual/html/fl_set_table_rows.htm to see how you can manipulate data in a tableDecember 21, 2009 at 10:32 am #4982
Well guessed – By “Global”, I meant a one-off change across all form instances. The data to be changed is different per user, but the formula or rule is consistent.
Thanks for your solution which will do what I want and also make me change the way I have done some other things.
You must be logged in to reply to this topic.