Jump to content

ehwalker

Members
  • Content Count

    51
  • Joined

  • Last visited

Community Reputation

0 Neutral

About ehwalker

  • Rank
    ehwalker

Profile Information

  • Title
    Wildlife Research
  • Industry
    Wildlife Conservation

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Ah... well, I'm working on importing very messy data from excel and to do this had setup the relationship using a "name" field in both the main database table ("Farms) and a temp. table imported from excel. In this temp table, I wanted to filter out all the records that had parent "farm" records already in the main database (based on these matching names) so that I could see which records within the excel table did not have related "farm" records so that I could create them based of data in the excel table. Does this make sense?
  2. Yes, okay thanks. I first ran into this issue when trying to use the "*" operator and the omit option to find records that did not have a related child record by using this operator within the related primarykey field (UUIDnumber) from the child table. I guess then there would be no way to do this then without changing the validation options?
  3. Hi Comment, thanks for the quick reply. Sure. I have a numeric field "Exam#" that has validation set as follows: Then, within a table view layout - I'd like use the available find operators for the find (e.g. * or # ) When trying to run the find, I get the error that the find value fails the validation and says a numeric value only can be used. If I check "allow user to override..." in the field options, I can override the validation fail and the find works as expected. Thanks for your assistance, please let me know if further clarification is necessary. Perhaps I've made some simple mistake somewhere, but I don't think I've experienced this issue in the past...
  4. Hi, I'd like to search in a field with validation set to 'numeric only' using the available find operators (e.g. match empty "=" or, zero or more characters "*") but the find is being prevented by the validation. Is there anyway of getting around this without removing field validation? I realise you can set it to allow overide, but would like to avoid that as well. Is this a recent change to FMP? I'm not sure I've run into this issue before in the past. Thanks.
  5. Ah, well that's certainly an easier solution that's quite obvious now that I think about it 🤣. Thanks for the help, really appreciate it!
  6. Thanks! As I have two table occurrences of DRUG.ADMINISTRATION (one to EXAMS and another to ANAESTHESIA), does this calculation work? It would have to be set to evaluate based from one of those occurrences, yes?
  7. Thanks Comment! Very simple, but my concern there is with data export. When exporting, would one then need to export records from each table occurrence individually to ensure that the DATE field is included in the export? This is why I was trying to populate the DATE field with the actual date rather than just showing the date through the relationship... as I thought it would cause issues with data export?
  8. I have a table DRUG.ADMINISTRATION with 2 table occurrences relating to the tables EXAMS, and ANAESTHESIA, both of which I'm considering as parents as DRUG.ADMINISTRATION records need to be created from each of these tables via a portal on their layouts. Within DRUG.ADMINISTRATION there is a field DATE which should capture the DATE of the parent. Currently, I have two table occurrences of DRUG.ADMINISTRATION; one setup with a relationship to EXAMS via DATE and EXAM.UUID and one setup with a relationship to ANAESTHESIA via DATE and ANAESTHESIA.UUID. This works fine when creating records, but if the DATE field is modified in the parent table DATE is not updated in the child table and the relationship is broken. I need this DATE field to update automatically if the DATE field is modified in the parent table. I had thought to try an auto-enter calculation/lookup or calculation field to capture this date, but because I have the two occurrences of DRUG.ADMINISTRATION there's no way (that I know of) to set this calculation to evaluate in the context of the appropriate table occurrence. Any solutions to this? Perhaps this setup is not best practice as I'm struggling to find a solution (not requiring scripts), so any advice is welcome! Thanks.
  9. Thanks bcooney for the advice, I'll have a look at this option! Hadn't thought about backups, so having the external file seems a really good solution. Will still need to figure out how to make it work with my layouts so that the appropriate identifiers will populate whenever a photo is added. Thanks!
  10. I'm looking for advice regarding strategies for storing photos/scans within my database. Currently, I'm of the mindset that I would prefer to have a single 'container table' that is used throughout the database where needed. This table would have a few identifiers, which autofill based on where (as in from which layout, or where on the layout) the container is populated. Then, there would be a single layout where all photos/scans could be browsed/filtered/etc based upon those identifiers. First question, is this design good practice or should I reconsider my approach? Please note that for my purposes a container is not always necessary for every record (i.e. some records will have photos attached to them, and many others will not), and some records will need multiple containers (a record can have more than one photo attached to it). Second, in the case this is good practice, are there any examples available on how to best implement it? I really appreciate your time, please let me know if further clarification of my question is necessary.
  11. Okay, thanks for the insight. Really appreciate your help with all these questions Comment!
  12. Ah, okay. I understand and that was what I was looking for. Thanks! From your first comment are you suggesting that it's not necessarily a problem to have empty records within the value table?
  13. Hi Comment, just another follow up question here. I've implemented the design you said without issue and it works perfectly, thanks so much. How would you suggest setting things up so that you could easily delete a value that was entered? I was just going to put a button on the portal that triggers a script to go and delete that specific answer record, but thought perhaps you'd have a better way of doing this. Thanks again for the help!
  14. I'm working on a set of FM solutions that all share data links between one another. Currently, I'm working on local versions of the files but eventually the solutions will be uploaded to FM Server. Is there anyway that I can upload all of these solutions at once without breaking their links to one another? Or is it best I just build those links after the solutions are uploaded to FM Server? Thanks!!!
  15. I realised that I had misunderstood what you said right as I sent the message. Great, makes sense for sure. Thanks again!
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.