• Find mode in a script

    Hi all,   I have two questions regarding Find mode in a script. Let see if someone help. I have the following script:   In this example, $encargo = 1   1- When this script is trigered, and $encarg...
    last modified by manuelruizga
  • Substitute not searching full phrase

    I am having a issue wit a Substitute function. Because Print appears in   2 different options it is causing the output to combine so instead of 40 or 60 its 40 and 60. Is there a way to have the substitute t...
    last modified by Macz
  • Following on from the master-detail portal

    Following on from the new master detail portal, would it not be logical to develop it to work with detail portals as well.   I have modified a Sales Ledger to remove the script required to show the detail of...
    last modified by andyk3005
  • Sub Summary calculation problem

    Hi, I'm having a problem with a sub summary calculation that I though should be pretty straight forward but apparently not. I have found set of records sorted by a field named L# (our job number). Each L# may have mul...
    last modified by ToddBeach
  • Percentage Question

    How can I write a script for calculating a percent of another item. It will always be one half of one percent
    last modified by chaymore
  • Padding for txt export file

    Hi,   I have to create a text file that is always 750 characters long. Most of the records are 750 characters long but the header and footer records have spaces padding them out of 720 and 713 characters each. H...
    last modified by user29188
  • Matching records exactly - not all that are similiar

    I have an issue with the wrong records updating. In the screen shot below, the idea is to enter a roll number (pertains to a roll of paper in inventory) and all the other fields automatically fill in. At the end of ...
    last modified by Jon1
  • Set Invoice Due Date to 1st every new invoice???

    So, after having mental breakdown, and running around like a chicken without a head. I turn to the really you guys for help!!!....   In the solution I am building, I only generate invoices/statements at the 1st ...
    last modified by TekGlobe
  • Automatic generation of ID number, upon satisfying a condition from another field

    Hi I am a relatively new user of FM, and have been tasked with developing a data base for a volunteer run archive. This archive manages the history of Australian Jazz. To date it has used a rudimentary data base to re...
    last modified by whitsend
  • How do I create an ever present user notification icon

    I want to create a notification icon that signifies pending notifications unique only to the user. This icon will display in the upper left hand corner of the user's nav bar as seen in fig.1 (dashboard nav).   ...
    last modified by joshuaw07
  • List of summary of people start working in company

    HI, i am new to filemaker, i would like to ask how to show a list of  sub-summary in a field. For example,   2018/4 ..............4 people 2018/3...............3 people 2018/2...............0 people .....
    last modified by sam0723
  • Replace a word in a line of a field

    I have data in lines, each line has data separated by spaces (in words).  After a calculation, I need to replace the specific value.  Is there an easy way to do this?
    last modified by vcummins
  • FM thinks two number values are not the same, when they are.

    Hello,   I am in a situation where I'm trying to compare two number values in two different fields in the same table, for testing purposes. One value is in a calculation field the result of which is set to be ...
    last modified by robk
  • Filter out same record in two different portals

    Afternoon everyone!   Hope everyone is having a great day, I do have a quick question for anyone who is willing to help. I have two separate portals in my database and they both show records from the same table....
    last modified by kestelle123
  • Get Upcoming date of Saturday and sunday!

    Hi,   I have 3 Date fields and 1 text field Category start_Date End_Date Celebration_Date. I entered current date in start_Date and inserted a date from december 2018 on End_Date. If Category field = "DJ" ...
    last modified by anoobs
  • Slick Boolean Checkbox

    Hi All - I am chasing down ideas and examples of simple Boolean value layout objects.   I want to not use a Check or Tick for a checkbox object on a portal row or layout, they look ugly and I was wondering what ...
    last modified by user30198
  • Calculating Month

    Hello all,   I am trying to build a sales forecasting layout and I have a field for the forecast for the "starting month".  Is there a way, based on the month that is entered in this field, to fill in the n...
    last modified by bleyden
  • GetSensor (Attitude)

    I want to use the function GetSensor (Attitude) to get the angle of the device when the button is pushed. think digital level direct input. I can do the radians to degrees conversion easily enough the problem I am hav...
    last modified by nathangreertank
  • Find records as per username

    Hi,   I have a button which should go to another layout and just display the records of the user by searching the user first name from tblUsers by their username and matching this first name with sample record f...
    last modified by vaishnavi
  • Filter text for numbers and letters only

    I have a calculation in one of my database fields to create the email address from the first and last name following the standard the company uses. This is working great.   NameFirst&"_"&NameLast&"@"...
    last modified by MacDevGuy