
biggles1212
Members-
Posts
47 -
Joined
-
Last visited
Everything posted by biggles1212
-
Hi All, Been looking at the blog from clickworks and think it is a great way to generate a PDF. The only thing is my attempt was to do the following: CLIENT: Click button -> Creates a record in a blank table (triggers client robot waiting) then return to original layout ROBOT -> Complete action as script has been triggered with the record on load and then will tidy up and delete all records and wait again until another record is created Sounds simple but there are times when he script is triggered and it shouldn't be. It isn't a flawless effort. I know its a rough plan but could anyone give me any guidance on this? Something else I could try or use script parameters etc... Cheers, Adam
-
Hey, Thanks. I tried using that too in my script but nope... Doesn't want to find those records. I manually type it is still i.e. "1/1/15...31/1/15" and finds the two records. I just cannot work out what is going on? I have done this tons of times....
-
Hi Guys, Now if I manually search the date field I can get some record results ie. */1/2015 (in Australia so 1 is January) Now I created a script and the calculation puts "*/1/2015" into the date field YET when it gets to "Perform Find [ ]" it returns no records. Why is there a difference between manually typing it in and searching via a script do you think? Cheers
-
Hi all, Running FMS on a Windows VPS it seems it wants more and more Ram. There is only 10 clients max at any one time connected via FM Pro. Usually not that much. I have noticed if it reaches the limit for the RAM then FMS turns off web publishing automatically. Just wondering what other people may be using or could advise me on maybe why it is so ram hungry. The VPS is 8 CPUs, 10 GB ECC Ram, 35 SSD. Thanks
-
Thank you. The other day I missed a ',' or something similar and the page wouldn't load. It took me 30 minutes later to work out my stupidity. Thanks for looking it over. Sometimes it needs someone to have fresh eyes looking at it.
-
I am trying to get results based from a range. I have Date_Start and Date_End which are exploded so they meet the filemaker formatting. Then I take a variable of $dateRange and get it to use those two fields mentioned above. I just get an error however of "errorCode=508&errorMsg=Invalid+value+entered+in+Find+mode" Can you see anything out of the ordinary? Thanks for your help and I appreciate your contributions on the forum. Your helping me out anyway. <?php require_once('Connections/User.php'); ?> <?php //Setup date to be in US format from AU format $date_input1 = $_REQUEST['Date_Start']; $date_array1 = explode ("/", $date_input1); $date_start = $date_array1[1]."/".$date_array1[0]."/".$date_array1[2]; //Setup date to be in US format from AU format $date_input2 = $_REQUEST['Date_End']; $date_array2 = explode ("/", $date_input2); $date_end = $date_array2[1]."/".$date_array2[0]."/".$date_array2[2]; $dateRange = $_REQUEST['date_start'].'...'.$_REQUEST['date_end']; $founduser_find = $User->newFindCommand('Users'); $founduser_findCriterions = array('Username'=>'=='.fmsEscape($_SESSION["User_tableLogin"]["user"]),); foreach($founduser_findCriterions as $key=>$value) { $founduser_find->AddFindCriterion($key,$value); } $foundflights_find = $User->newFindCommand('Flights'); $foundflights_findCriterions = array('Username'=>'=='.fmsEscape($_SESSION["User_tableLogin"]["user"]),'Date' =>$dateRange,'Aircraft_Type'=>$_REQUEST['Aircraft_Type']); foreach($foundflights_findCriterions as $key=>$value) { $foundflights_find->AddFindCriterion($key,$value); }
-
Any hour past 10 hours or there part of i.e 1 minute and 30 seconds of duty over 10 hours would be 11 hours. I think any reasonable employee would just call it 10 hours of work rather than creating an inquiry of questions and time spent on why they logged an extra second.
-
Thanks mate
-
Hi folks, I am using: <input id="date" class="form-control" type="text" name="Date" data-data-format="dd/mm/yyyy" value="<?php echo date ("d/m/Y", strtotime ($found_flight_row->getField('Date') )); ?>" /> which allows me to have a date picker and also display dd/mm/yyyy via the 'strtotime'. What I am trying to do is have an edit query so I can edit the date and submit that. On my edit_response page I have the following for the date: //Setup date to be in US format from AU format $date_input = $_REQUEST['Date_Start']; $date_array = explode ("/", $date_input); $date_toFM = $date_array[1]."/".$date_array[0]."/".$date_array[2]; $edit_record_edit = $User->newEditCommand('Flights',$_REQUEST['-recid']); $edit_record_fields = array('Date'=>$date_toFM, etc etc etc etc....... I am getting the date doesn't meet the validation criteria. I am guessing it is being sent as d/m/y maybe to Filemaker. Can someone shed any light on this?
-
As crazy as that sounds no, it is actually for a duty roster tracking purpose. If the staff member goes over 10 hours of work (plus any part of an hour) they need to have x amount of time off.
-
Thanks!
-
I have a time field which I need to work out firstly is it over 10 hours and if it is I need it rounded to the nearest hour. A simple IF statement helped me with the first part. The second part however I am not sure about. ie. 10:59:22 ~ 11:00:00 10:01:30 ~ 11:00:00
-
Thank you so much. Worked perfectly. Definitely still learning how all this works :S
-
I hate to be a pain but where am I pasting that code? I assumed in the header of the search results page but I just get a blank white screen.
-
I have a user layout in filemaker which has a filtered portal on it displaying a total from another table. How do I get this filtered field to the website? I have tried several things however it keeps showing me the total for that field rather than the filtered total. ie. it is showing me the total amount of money received rather than how much that user has paid. Trying to use it for a dashboard.
-
Have a webpage where the date is required to be entered. The issue is it requires it in mm/dd order it seems. Any way to convert the dd/mm/yyyy while it sends to the database?
-
Maybe I wasn't clear. That is what I am meaning. My website would redirect based on the privilege set name (obviously based on the account they are logging in with). Once I have pulled the privilege set name what would the php code be to redirect admin to the admin.php page and the user to the user.php. This comes from having a webpage and successfully logging in and pulling records. That I can do. If I created for example an admin only area I don't know how to limit to stop the 'user' type getting to it so my thought would be to simply start at the login and technically build two websites. One for the admin side and the other for the user.
-
Any suggestions for logging in and it redirecting you to either the user page or the admin page based on your privilege. e.g. "user" privilege redirects to "user.php", "admin" privilege redirects to "admin.php"
-
What I have done as a stop gap measure is two email fields and another field that combines the two with @ between them. It works but don't have any idea why its adding the in the first place.
-
Hi all, I am using FMStudio to do my PHP for me. I have a webpage where the clients can amend their contact details including their email address. When you hit the submit / save button everything updates perfectly but the email address whether you change it or not seems to add '' before the @ symbol. If I remove the @ symbol and hit save it doesn't add it. Seems to be something to do with the @. Any ideas at all?
-
The reason we would create these records is because through the PHP Filemaker API we would have a website where people can book on to the scheduled bus routes. I guess similar to any Airline where you can search for available flights, select the flight and then book yourself on to the flight.
-
I have a calendar plugin that does a great job turning those layouts into something visual so you can see how busy a certain resource is. What would be a great way to create records based off a master record? For example: The database is keeping track of a bus charter schedule. Clients call up and can hire the bus at any time however the bus may also do set routes on Monday and Wednesdays. If I was to create a master table and entered in the information required could I somehow get a script to run that would create records for the next 3 months for every Monday and Wednesday that occurred between now and 3 months time. Master Route: Description: 1 Hour Scenic Tour Dates: Monday, Wednesday Expiry: 3 Months From Now
-
I have one table with sales. The person who did the selling, the item and date. While they are entering sales I want a summary of how much they have sold in the past month and past year. How would I get a calculation to find the sales persons records and filter them by the date range and then add up the amount field?
-
Popover and Slide Control
biggles1212 replied to biggles1212's topic in FileMaker Go for iPhone & iPad
HOLY MOLY I never updated the apps... Thank you... -
For some reason popovers and slide controls on my iPad aren't working. Actually they aren't even showing up at all... Has anyone come across this before?