• 日付範囲をキーとするリレーションの計算

    この場では初めて質問させていただきます。 万が一、至らぬ点があればご容赦を。   Mac版FileMaker Pro 15 Advanceを使用しております。 このようなデータベースにおいて、期間毎の集計をしたいと思っています。 (実際はもっと混みいっていますが、簡略化のために必要なフィールドを抽出し、質問の趣旨を説明できるように変更してあります。)   【現状】 Table_A:各日のTable_Bのデータを...
    marth
    last modified by marth
  • Parameter Passing Problem With Radio Button

    I have a very simple sort script that I call from a radio button. The radio button has three selections; Contact, Account and Date. I pass the radio button field to the sort script from OnObjectModify. For some reason...
    laguna92651
    last modified by laguna92651
  • 別のPCに保存されている特定のPDFを開きたい

    環境はMacOS10.11~12 ファイルメーカープロ15です。 別のmacの共有ファイルの保存されているPDFをボタン一つで閲覧したいと思っています。 PDFファイルは複数あり、ナンバーと名前で保存されています。 ナンバーごとに階層を組んで保存されています。 1~10000---1~1000---1~100----         ...
    ハンソン
    last modified by ハンソン
  • チェックボックスセットで複数チェックした値を複数レコードとして登録させたい

    初心者の川崎と申します。よろしくお願いいたします。 チェックボックスセットで AAA BBB CCC DDD EEE と表示するデータから AAA BBB DDD をチェック データ入力後、レコード保存でExcelの形式に保存すると、 ひとつのセルに AAA【改行】 BBB【改行】 DDD【改行】 と保存されます。 これを複数レコードとして登録するにはどのように設定すればよいのでしょうか。 よろしくお願いいたします。
    takekawa34
    last modified by takekawa34
  • 指定した日付の在庫数を表示

    ファイルメーカー初心者です。 現在、社内の在庫管理システムを作成中です。 〇伝票テーブル 伝票ID 日付 記録者   〇伝票明細テーブル 伝票明細ID 伝票ID 商品ID 数量   〇商品テーブル 商品ID 型番 商品名 初期在庫 現在在庫   といった感じで3つのテーブルをリレーションシップでつないでおります。 現在在庫について、グローバルフィールドの日付フィール...
    masa22
    last modified by masa22
  • Add public/private key encryption to the crypto functions

    score16
    Active
    16 votes
    The extensions of the curl functions in 16 made almost all Web Services available using native HTTP functions.  However, some websites using various implementations of Oauth ( 1.0 and 2.0 ) utilise public/private...
    nickorr
    last modified by nickorr
  • Force Re-LookUp / Re-Calc

    Is there a way to force a "re-look up" or "re-calculation" when changing information in one table that affects a calculation in another table. I am using a standard CLIENT / INVENTORY / INVOICE / INVOICE LINE ITEM er...
    jefro
    last modified by jefro
  • How do I find a single character value in a field

    I have data from a legacy system imported into filemaker.   A field has valid values C,CANS,CANB etc. I am running a scripted find where one criteria is the field value C.    I have tried vari...
    andyk3005
    last modified by andyk3005
  • Finding the Article via the article number

    Hi there,   I am very new to FileMaker and need your help. For an invoice it is necassary, that I must be able to find the articles, via typing the articlenumber in the Invoice details. I am testing around and a...
    heinrichh
    created by heinrichh
  • WebViewer blink

    Hi I have create a calendar with fullcallendar and I have implemented in my app. I have a problem when I am adding event to the calendar, the refreshing is blinking the calendar. I am using a recursive custom func...
    max_bog
    last modified by max_bog
  • I am looking for a Filemaker expert in The Netherlands who can help me ..

    I am looking for a Filemaker expert in the Netherlands who can help me...
    janwind
    created by janwind
  • Find name of next month

    Calculations & dates do not mix well with me... =)   Date question ... if I was wanting to determine the name of the month following a current date, what would need to be done. I'm able to extract the month...
    skingjack
    last modified by skingjack
  • many global fields vs. many global variables

    Referencing to an other question recently posted Database structure   I think that the framework of the problem should be quite common for those who work on complex professional solutions: there is a need of ha...
    Wicktor
    last modified by Wicktor
  • Best programming languages that work well with Filemaker

    This might be a silly question however, I've built (with lots of help) and am expanding a current filemaker solution. I don't have a programming background but am working on that. What are additional programming langu...
    sfarnsworth
    last modified by sfarnsworth
  • Setting static ip address in server 16

    We have just moved from server 11 to server 16. New install on a new machine. We shut down and removed the old machine from the network. Followed the manual for the set-up of 16. However, I cannot find where to set my...
    CharllotteKwon
    last modified by CharllotteKwon
  • choose 1 of 4 sequentially

    I'm trying to change textfield so that each change iteration chooses different color. I arbitrary selected 4 as a good number as I don' t expect a usual calling for more than three changes in a session   &...
    tomswell
    last modified by tomswell
  • LookupNext with a Cartesian relationship

    I am attempting LookupNext from one table to another joined by a cartesian relationship. Specifically, I need to find the previous and next Weights and the previous and next Moments so that I can perform a weighted av...
    cmayerle
    last modified by cmayerle
  • FileMaker 16 Server Webserver not starting

    Installed latest version of FileMaker Server 16. However the Web Server will not start. Read through other forums and tried their solutions without success.   Any ideas. Please advise.   Thank you.
    user2147192
    last modified by user2147192
  • Obligatory Create, not populating Auto Enter Data

    Hey FM Folks,   I'm normalizing my database, splitting my Members table into (People --> (Staff,Volunteers,Vendors) Previously I was using an obligatory create to add Members from an 'Applicants' table, this...
    cmcleod
    last modified by cmcleod
  • Layout Mode / Inspector / Position: Keystroke [Tab] wrong

    Product and version:  FMPA 16.0.3 OS and version: macOS 10.13.3 beta 4 [17D34a] Hardware: MBP 13" Retina Late 2013 Description: In Layout Mode, using Tab-Key in Inspector to define Position used to jump from L...
    Benjamin Fehr
    last modified by Benjamin Fehr