10 posts in this topic
I have a table with NAME field containing Return Separated Values (RSV).
I want to run a script that will add more RSV's to the same NAME field in the same table.
This will be from the same NAME field on other rows. It will be based on a "match" on a PRODUCT field.
I don't want to wipe out the values already in the NAME field obviously.
This is one of the hardest thing I been trying to acomplish, I want to transform the contacts module into a Donors module for our blood bank.
I have transform most of the fields already to match the donor information we will need. However I want each donor to show in a portal all the units or (products) associated to that donor.
Example: 1 Donor can donate blood every 56 days 1 unit (which has a serial number associated to it)
I want each donor to show all the products or units associated to him.
Im sure this might be something really simple to some of you so any help will me much appreciated
Thank you in advance for all the help
I am newbie to filemaker pro but love it Said so, I am struggling a solution that I am building for management of holiday apartments, based on FMSP. I have created a table for bookings, and apartments, and now I am working with another table call Daytariffs that would give the price for each day of the year for each apartment. So far I have being able to show the available apartments for a range of dates, but what I am struggling now is to show the prices for those days. Basically, what I have done on the DayTariffs table is to load 365 days (records) then I have created a field called "Range" and put a calculations that shows "YES" if a date is within the dates I have set on the Booking layout as StartDate and EndDate (this dates are global fields). I have created relationship between Daytariffs and Bookings through ID_DayTariffs (Daytariffs table) = id_daytariffs (Bookings table). Later, I have also created a global field called "BookingDAYS" on Bookings tables and set the field value as "YES", and I have created a new relationship that relates BookingDAYS = Range.
Then I have created a portal based on the the relationship between BookingDAYS=Range, on the Bookings Layout but wont show any records I am stuck here because if I change the Range field to be just text without any calculation and I write "YES" then the portal works, but as soon as I put the calculation back, the related records disappear...
I have checked that calculated result on Range field is set as Text as well as BookinDAYS is a text field... also what have noticed is that the relationship graph for BookingDAYS=Range has this simbol at both sides "|---" when normally would have a three lines (like a folk) when I choose any other filed for that realtionship instead of Range.
I am attaching screenshots of relationship graph, booking layout and DayTariffs Table
Any ideas what I am missing here?
Thanks a lot.
I'm very new to FileMaker design, so I may be missing something very basic, but I cannot figure out how to make this work. I've got a working portal set up, showing the correct records. I can add new records using the blank line in the portal, and those records then show in the portal window. However, if I go look at the actual table that the portal links to, the new records are not being added there. Are they going somewhere else instead? I need to actually create new records, not just display them!
Hi, I’m really Stuck , any suggestions would be most appreciated.
I need to replicate a particular behavior of the PopOver that is inside a Portal.
When inserting or editing portal Rows via popOvers, the data updates in the portal before “committing”.
Trying to replicate this behavior according to this rules:
-. Using Transactions and Data modeling.
.- Data not updated at the portal before committing (refreshing portal by trigger or exiting a field doesn't work).
.- Data not updated at the portal as inserts or edits are been made (same as above).
.- Inserts or Edits are made outside the portal in the same layout (no modals, Using SlideControl).
.- Not using PopOvers inside portal.
.- Portal is not accesible by user it only shows the list of items been inserted or updated.
I have tried different approaches but no solution yet, trying to replicate behavior has been very frustrating.
Filtered Single Line portals and Magic Key with different Techniques and different relationship approaches, I have not tried Globals via Scripts which I presume could be a solution but don’t have much to start with!!!.
For the record:
A few months ago I started implementing “Selector Conector and Transactions”, I´m not so sure I have correctly implemented this.
I have prepared a Sample file (is not the actual solution) with very simple use of Transactions and Data Modeling, it shows different approaches I have tried. Used some technics learned here at this forum which have been very helpful.
Approaches number 1 and number 2 from the Sample file are not the preferred, but merely show the behavior I´m trying to replicate.
A script at start creates small window that shows records are been created in child's table even tough it won’t update the portal before commiting when using technics 3 and 4 from the Sample file.
Hope my explanation makes any sense.
Thanks in advance, and cheers to all
PS.: Check the green Framed Portal at the right hand side of the layout´s Sample file for a cool technique that I designed, it uses “Hide Object when”, and a combination of formatting the Button and portal row (Padding), which makes the illusion of an X circle appearing on the right side when Hovering portal rows, mostly used for deleting. Hope any one has a use for it.