Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


madman411 last won the day on September 16 2015

madman411 had the most liked content!

Community Reputation

2 Neutral

About madman411

  • Rank

Profile Information

  • Gender
    Not Telling
  • Location
    Los Angeles, CA

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform

Recent Profile Visitors

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

  1. Currently just using a hidden web viewer to send commands as I think this is the only way to send a URL.
  2. @ggt667 and @comment - thank you both! Now my FMP application and read the XML file and import from state.xml Now my final task of using FMP to update the XML. I have created a script using Insert from URL. The network device supports control via URL commands, for example, typing into the address bar will set the relaystate to 0, etc. The script uses a Case () function to determine if "1" or "0" should be sent in the URL but I'm currently getting a progress bar saying "URL data transfer" that stays on the screen for a long time wi
  3. Hi there Is this what you're looking for? <?xml version="1.0" encoding="UTF-8" ?> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"><ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="09-05-2019" NAME="FileMaker" VERSION="ProAdvanced 18.0.3"/> <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="Doors.fmp12" RECORDS="1" TIMEFORMAT="h:mm:ss a"/> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="DOOR" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="inputstate" TYPE="NUMBER"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="
  4. Hi all I am interested to know if there's any suggested reading and/or viewing that can help me achieve the following. I have a webrelay device on my network that controls a magnetic door lock. The device supports XML and HTTP GET requests. I have created a basic map of the property in filemaker and want to use a button to toggle the control the relay (thus locking or unlocking the door) and return the device status'. Conditional formatting will indicate whether the lock is energized or not, with a separate field indicating whether the door is closed (inputstate). The XML (state.xml
  5. Hi all I have the current script below set to find a random number of records based on the test question requirement (TestQuestionCount) within a found set. The script successfully is able to isolate x number of questions depending on the TestQuestionCount requirement. I have watched the Data Viewer during script debugging. However, if the question count requirement is 30 questions, it's usually finding ~25 records or so. Upon further investigation I see it is randomly (of course) capturing duplicate record ID's. When the system is creating a new request there are usually a couple duplica
  6. Yes, one test for each subject applicable to that users training level. Pass is 70%, score below a retest is possible, but with a new generated selection of questions. Agreed. Database design is something I'm teaching myself and I don't design solutions for compensation. My requirements have changed based on input from my instructor. I've now restructured the database question bank via subject > topic > topic code > question. What I've come up with works very well as far as I've managed to test functionality. Further alterations I'll re-visit the drawing board. My concern now
  7. Thanks comment! My database has multiple test questions for multiple subjects. I've done my best to simulate the actual test-taking experience that happens in the exam room (also on a computer, multiple choice). Several subjects have over 1,000 questions in the question bank, not written by me. If I want to "generate a test" for a given subject and have the computer randomly choose 100 questions out of the available 1,000+, would creating a script to export the randomly chosen questions to a Test table suffice? As I see it, this way there's a separate record available for *that* user
  8. Thanks, comment. I have moved the answer choices to a field in the question table and defined a new field in the same table that contains the correct response. The answer choices are now referenced in a value list which displays as a set of radio buttons. AnswerSelection = CorrectAnswer equals correct. AnswerSelect ≠ CorrectAnswer equals incorrect. Say there are 100 records (100 questions), what would be the best way to record the answer choices as the user progresses through? I see your comment on using a Responses table, but I'm failing to see how a new record would be created/modi
  9. Evening all I am creating a multiple choice test solution with three possible answers. I have an "Answers" table joined to my "Question" table via a QuestionID field. The answer selection to each question is presented in a portal. Currently I have set up a radio button for the user to select their answer ("selection"), however currently I'm stuck trying to figure out how to only permit one answer choice for each question. Right now I can select all three answers by clicking each radio button in each row. Is there a way to make FileMaker only permit one radio selection in a group of relate
  10. I've never attempted to filter a portal based on checkbox selections. Is there a particular function that would achieve this? Never mind PatternCount() did the trick
  11. @mr_vodka I figured this was it! Thank you. Can you suggest a work around for this?
  12. Hi guys! I'm about to embark on a project where I'm solely responsible for tracking a lot of different items distributed amongst 20 people. Barcodes were my solution and and the app I've put together works a treat. However, I'm trying to use checkboxes to filter out related records in a portal. When I try to implement this the portal goes blank, which isn't the result I expected. The two tables I'm having an issue with are "Projects" and "Assignments". The "Assignments" portal is on the "Projects" layout. The relationship is: Assignments::ProjectID = Projects::ProjectsID Th
  13. Hey guys I have a NAS which I administer by issuing commands via SSH inside of terminal. All that typing has become a little monotonous so I created a small FM solution to do it for me. This is one of my [native] Apple Scripts that are issued via a button click from inside of FM: on RunTerminal() set ScriptCommand to "docker restart 70763e5576a3 85201fbfccc4 935a69d98be1 afb9e027526d" tell application "Terminal" activate do script with command ScriptCommand in window 1 end tell end RunTerminal on run RunTerminal() end run It works great, but I want to customize it a little mo
  • Create New...

Important Information

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