aguest Posted September 23, 2015 Share Posted September 23, 2015 Apologies if this is in the wrong section. I've got an db for lesson observations. it's used via iPads. Teachers observe lessons and fill out some information based on a form. The issue I have is that when two teachers observe the same lesson and create observations, it appears that only 1 of them is actually been saved to the table(s). is there a setting that needs to be changed to allow two people to write to a table at the same time as we really don't want to be losing an observation or more each time they are carried out as we can have numerous members of staff observing lessons at the same time. Link to comment Share on other sites More sharing options...
Wim Decorte Posted September 23, 2015 Share Posted September 23, 2015 No setting, this is default behaviour. You will need to adjust your design to accommodate multiple users adding observations to a lesson. FM locks the record that a user is editing. But if you add records in a portal, both that edited record AND the parent gets locked, which is probably what you are seeing. So give the users an interface to add observation records without doing it in a portal. 1 Link to comment Share on other sites More sharing options...
aguest Posted September 23, 2015 Author Share Posted September 23, 2015 They are doing it in this way. They click add new and go to a layout which creates a new record. I am expecting it to create two separate records in the table for the person being observed but it doesn't appear to be doing this. Link to comment Share on other sites More sharing options...
Wim Decorte Posted September 23, 2015 Share Posted September 23, 2015 That should work without locking people out... each user would have its own record without any locks. Can you post your script? Link to comment Share on other sites More sharing options...
aguest Posted September 23, 2015 Author Share Posted September 23, 2015 its just a very simple script.its attached and then it calls another script which is also attached. Link to comment Share on other sites More sharing options...
Wim Decorte Posted September 23, 2015 Share Posted September 23, 2015 You really need to get rid of the copy & paste.... Use Set Field instead, gather the info once and then go to the lessonsobs layout just once. Can't really make out what the exact sequence is from these screenshots. But you should be able to determine with the script debugger at which step in what script the lock happens. Work backwards from there. 1 Link to comment Share on other sites More sharing options...
aguest Posted September 23, 2015 Author Share Posted September 23, 2015 thanks I'll have a look at the copy and paste. Link to comment Share on other sites More sharing options...
bruceR Posted September 23, 2015 Share Posted September 23, 2015 I certainly agree with Wim's suggestion regarding copy and paste. In case this way of scripting is unfamiliar to you, it would go something like this. No need to copy paste, no need to keep bouncing back and forth between layouts. Go to Layout [ "ObsMatrixTemplate" ( LessonObsMatrixTemplate )] Set Variable [ $progOutstanding; LessonObsMatrixTemplate::ProgOutstanding ] Set Variable [ $progGood; LessonObsMatrixTemplate::ProgGood ] Set Variable [ $progReqImp; LessonObsMatrixTemplate::progReqImp ] Set Variable [ $progInadequate; LessonObsMatrixTemplate::progInadequate ] Go to Layout [ "LessonObs" ( LessonObservations )] Set Field [ LessonObs_OBSMATRIX::progOutstanding ; $progOutstanding ] Set Field [ LessonObs_OBSMATRIX::progGood ; $progGood ] Set Field [ LessonObs_OBSMATRIX::progReqImp ; $progReqImp ] Set Field [ LessonObs_OBSMATRIX::progInadequate ; $progInadequate ] Link to comment Share on other sites More sharing options...
aguest Posted September 23, 2015 Author Share Posted September 23, 2015 thank you both. The copy and paste method was something I did when I was very new to filemaker and just teaching myself things. I've since learned a lot (through this forum) but haven't had a chance to go back and alter previous things to ensure they work more efficiently.I intend to do this tonight now. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3272 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now