Hi,
I’m new to servoy, and javascript, and have spent a long time looking at posts related to this subject, but can’t seem to find the answer I’m looking for. I think it’s a fabulous application but I’m still learning all the ins and outs.
I have a solution that involves a personnel table, proposal table and a grants table. I have tabs set up that will display a personnel record and the related proposals and grants for that record. In the proposals form I have a button (called approved) that when clicked on, I would like to create a method that takes the contents of the proposal table and updates the grants table with all the similar fields. I have relations setup between proposals, grants and personnel. I’ve tried the fsUpdater method, but it doesn’t know about the grants fields, and I’ve tried the getDataSetByQuery, to retrieve the field contents, but I don’t see a function to write the query back to the grants table.
Any help would be greatly appreciated
Thanks
Graham