
Amanco
Members-
Content Count
13 -
Joined
-
Last visited
Community Reputation
0 NeutralAbout Amanco
-
Rank
member
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
-
ok thank you I guess I leave it as it is for now using 2 fields. Thanks again
-
Both fields "Container1" and "Container2" have referenced scripts and calculations. I mean by changing the field name, the name will also change in all the scripts and calulations. In this case I want them all to be "Container1" In this case, is it not possible to make them all reference to the field "Container1" apart from doing it manually?
-
I am basically looking to remove the field "Container2" and use it as "Conatiner1". So image2.jpg to move it to "Container1". but i am looking mainly to change the field name first from "Container2" into "Container1" so all the attached scripts and calculations will change as well, so I don't have to do change them manually. but because the field with the name "container1" already exists in the table, I can't rename it. Thank you
-
Amanco started following Join Tables in Anchor-Buoy, Merge 2 field names (not text), Zoom API with file maker and 1 other
-
Hello, I moved fields (and scripts) from one FM file to another one. Now, I have a table to 2 fields that has same function but different names, example: Container1 and Container2 Both have their own attached scripts and calculations. I would like to merge "container2" into "Container1" field so the attached scripts and calculations will also change, but I can't rename it simply to "container1" is there a way to without going through all the scripts and calculations? Thanks
-
Hello, Any good tutorials/videos on how to implement zoom API with filemaker? Thanks
-
Set a container field based on another field
Amanco replied to Amanco's topic in Development Standards
Thank you comment, it is working great now -
Set a container field based on another field
Amanco replied to Amanco's topic in Development Standards
Thank you comment, I tried what you recommended but it is not working with me, maybe because: I am using a global table to manage my Value list, as follows: 1) I'm using a global table (GLOBALS) connected to a value list table (VL Items) where I make my value lists. 2) than I made a "VL items" Table Occurrence and connected it to the Main table "Main" (Main::Name) --> (VL items TO:: IDf VL items). Here I am getting my unique Value List in the "MAIN" dropdown that I need using the connected relationship with the globals. 3) Now, when I use the "Photo field" in "MAIN" la -
Hello, (1) I have a ready set value list table with the following fields: -ID -Name -Photo (Container) (2) I would like to do the following: when I choose field (Name) from a dropdown menu, I would like another container field (Photo) to auto populate automatically and show the photo based on the same (Name) in the value list. any help is greatly appreciated. Thanks
-
Hello, I need help please as I am new to the Anchor-Buoy using the following concept: I have a base table [PATIENTS] and would like to connect it to [STATUS], [DOCTORS], [TESTS], [TREATMENTS]...etc I looking to track the BOUYS Tables changes with time e.g. (A) Track the start/end dates/times of any [STATUS] changes of the patient --> becoming INPATIENT or OUTPATIENT or DISCHARGED (B) Track the start/end dates/times of [DOCTORS] interactions with [PATIENTS] ...etc 1) I figured a join-table is the approach to capture this data, is this correct? or is there
-
Amanco started following Load "Past" Related Records
-
Hello, I need help please with the best relationship design. I'm designing a database for patients and their encounters/visits, and I would like to like to view their information related to each visit (Current and old). I have the following tables: tbl_Patient ---> tbl_Encounter (inc date/time) ---> many tables capturing patient data What is the best way to view the old patient data based on the past date and time? Thank you
-
Amanco started following Archive records and Re-Activate and Slider bar field control style
-
Hello, Is it possible to make a slider bar field control like the attached image in filemaker 18? I only found a request feature 5 years back https://community.claris.com/en/s/idea/0870H000000fy9IQAQ/detail Thanks,
-
Thank you Steve, I have done what you suggested with a table separate for admissions with a date of admission and date of discharge. I attach my relationships. Okay, instead of the patient's name, I am going to use their unique chart number or National ID number to search for the patient and then add as new admission. Exactly as you suggested, I would like everything in their past history to be duplicated but under a new admission, so when I edit the information, It will not affect the information in their old admission encounter. Any pointers please on how to script this?
-
Hello, I am new to filemaker and using filemaker advanced pro 18. Im building a database for my patients who are admitted to the hospital. I would like help please with the following: 1) when I discharge the patient, the patient’s data are “archived” and not shown on the report. However, when the patient gets readmitted to the hospital, I would like to: 1) add patient by the hospital chart number 2) if patient is in the archive list, then activate and use the old data but under a new encounter to the hospital. whats the best w