This stream auto-updates
- Past hour
Jesse Barnum replied to fishtech's topic in MirrorSync by 360WorksShould be fixed in 3.14
I do. I was able to get the second deployment up and running, but it looks like I have to assign a different port for our web direct clients. I made the second machine listen to port 8080 (80 is server #1), and it works so far, it's just a little clunky to have to enter port numbers in the url. but at least so far, I'm happy that I don't have to create a vlan to run two servers!
marcelovitor joined the community
I'm reaching the 125 database limit of filemaker server, so I need to deploy a second and was hoping I can do that on the same network and just change the default ports. But I must be missing something because I'm not able to bring up the admin console after installation. I think it has to do with a conflict on port 5003, but I'm not sure. (FYI the databases don't have to talk to each other - they are all silo'd) My question is this - is there a way to run more than one filmmaker server deployment on the same network? If not, my only thought would be to create a virtual network with my router, but I don't want to go through the trouble if I don't have to. Any advice? Thanks in advance!
theusualsuspect joined the community
dcb4him joined the community
I just tried the following in the WillDelete section If Get ( LayoutName ) = "travels" set field[cars::lastdestination, "x"] I deleted a travel on the device and synced. The lastdestination field on the device was changed to "x" ! So the modification is sent back to client. The problem I have now is to modify my calculated field so it ignores the travels that are going to be deleted. Can I write something in the record that is going to be deleted or will it cause a problem ? EDIT Got it to work 1.created ToBeDeleted field in the travels table 2.modified the relation between travels and cars so the ToBeDeleted travels records are ignored 3.In the willdelete section I set the field ToBeDeleted of the travel to 1 and reevaluate the lastdestination
1) Which exact version of MirrorSync are you running? 2) In the MirrorSync configuration, do you have a foreign key configured from travels to cars? Actually, I just realized that neither of my questions matter, because we always do inserts for all tables, then updates for all tables, then deletes for all tables, so the delete will always happen last. You could edit the 'WillDelete' section for the hub, and in the travel table, you could update the related car record at that point. I don't know whether that will sync the car record back to the client though.
Sorry for the vague title. Let's suppose 2 tables Table Travels (travelID , carID, destinationID) Table Cars (carid, lastdestination) What I want is to update the lastdestination field in the table cars each time a travel is deleted. What I tried is 1.When a travel is deleted on the phone, I update the car modification time stamp to make sure it gets synced. 2.In the customization script in the "A RECORD WAS UPDATED ON THE HUB" section I added If Get ( LayoutName ) = "cars" set field [lastdestination, last(travels::destinationid)] 3.I deleted the last travel of a car and synced. The lastdestination field was not updated. I guess that this is because the deletion of the travel record is done after the car record update. 4. If I update the car on the device again and sync...then the field gets updated. Any way to achieve what I want to do ? Can I force the car table to be synced last ? P.S. Different users can use the same car. I can not use a calculated field to determine the last position on the device because the other user travels are not on the device.
milosisd joined the community
Your question is rather confusing, esp. the part about "button script trigger". If you have a button defined to run a script, then no script trigger is necessary. Make your script do something like: If [ Details::Type = "Meeting" ] Go to Layout [ "Meeting" ] Else If [ Details::Type = "Interview" ] Go to Layout [ "Interview" ] Else If [ Details::Type = "Incident" ] Go to Layout [ "Incident" ] # add more as necessary End If
Hello All, We have 6 layouts based on the type of Details being entered (ie, meeting, interview, incident report form). We created a value list for each type of Detail. From a list view of all Detail records, we would like to set the Detail ID field with a button script trigger that takes the user to the appropriate layout based on the Detail value list selection. Is this possible?
fishtech replied to fishtech's topic in MirrorSync by 360WorksFYI, I have just uploaded logs.
Sounds like you'd want to start with a table for items, and a related table for expenses. The Category field could go in either table, or both -- presumably with different values, e.g. banjo category might be "twangy things" and its expenses might have categories like, "parts," "lessons," "accessories," etc.
I am with a Los Angeles based television production company that is looking to hire someone to help us develop an asset/inventory tracking system using Filemaker. Below are a few of the features we would like to include. Inventory each item (with its own tracking #) To be used for tracking computer, camera, furniture, media, appliances, etc Check items in and out. Assign a work number to each item at time of check out. Generate inventory reports. Date of availability for each item (automated reminders) Ability to function with barcodes & barcode scanner Tracking sign in/out and maintenance histories We are located in Los Angeles, CA, but open to someone working remotely for design and implementation. This would be a project based job. The ideal candidate has extensive experience creating/developing applications using Filemaker Pro. Please forward your resume to firstname.lastname@example.org Best, Angelica
Thanks for the quick reply. Not sure how I would do that since they do not share a key. The relationship between Staff and workshop is all thru the WorkshopStaff table. I have been working with true relational databases for a long time, so I may be missing something here in FMP.
Hello, I am back to working in FMP after a multi-year hiatus, and I am rusty and am currently stuck. Hoping someone can point me in the right direction. I hope I am posting in the right topic. I am building a solution where we have a number of many-to-many relationships that are being used via portals. This is the issue that I am having that I am stumped on. In this instance I have the following db graph: Workshops <--=--> WorkshopStaff <--=--> Staff Each workshops may have multiple Staff and Staff may participate in Multiple workshops On the Workshops layout I have a portal to WorkshopsStaff In order to add Staff to the Workshop I have a button that brings up a popover with a portal that lists all Staff from which to select. I can select a Staff Member and they get added to the WorkshopStaff table. This popover was more or less modeled on the "invoices" starter solution The way I am displaying the portal inside the popover is via a table occurrence like this: Staff <--X--> StaffList (Cartesian relationship) My issue is that the portal in the popover (the result of the cartesian relationship) displays and works as intended as long as I have one related entry in the WorkshopClient table. But for a new Workshop for which I don't yet have any entries in the WorkshopClient table the portal in my popover comes up empty. What I am doing wrong or is there a better way to populate the list from which to select staff? Thanks a bunch. -J
Who's Online 4 Members, 0 Anonymous, 54 Guests (See full list)
Who Was Online81 Users were Online in the Last 24 Hours
- Brian Roller
- Jesse Barnum
- Lee Smith
- Kelly Wu
- Wim Decorte
- john renfrew
- Rick Whitelaw
- Aussie John
- Steve Martino
- Ted S
- Mike Duncan
- Todd Dignan
- Ocean West
- Tom R.
- David Wikström
- John May - Point In Space
- Gary Hoffman
- Claus Lavendt
- Ben Douglas
- Ron Cates
- Josh Ormond
- David Silverthorn
- Al Quimby
- Rupert Snyman
- Martin Šimáček
- Rodney Ang