Calculation Engine (Define Fields)
Field Types, Field Options, and those wonderful Calculation Functions!
12,881 topics in this forum
-
Hi all: This is tricky. (See attached. Sorry, I can't upload the working file here because it's work-related.) What you're looking at is a portal (LINE_ITEMS) in the parent table, ORDER. What we want to do is summarize by each order's related product codes and total the quantities of each per order, so in this example I want to summarize the total of PT's quantity (975) and W11's total quantity (975) on their own lines for this order ("John Smith"), so as a rough look it would look like: John Smith PT......975 W11.....975 I inserted Summary fields for Product Code (List of) and Quantity (Total of) in the LINE_ITEMS table, but …
-
- 3 replies
- 512 views
- 1 follower
-
-
Hi there: I'm close—I just can't figure out what I need to get this calc to work: Attached is a screenshot of the error message (from the DataViewer) and of course, the file; the calc is "remarked out" so I could preserve it and close the editing window. I'd sure appreciate the help. Thanks! Temp.fmp12
-
-
- 3 replies
- 300 views
- 1 follower
-
-
Can you guys help me in this? i need to make the pin point colored in custom web in filemaker when generating a map. i tried several way but does not work. what line should i change or what should i add? thank you very much Substitute ( "<!DOCTYPE html> <html> <head> <meta name=^^viewport^^ content=^^initial-scale=1.0, user-scalable=no^^ /> <meta http-equiv=^^content-type^^ content=^^text/html; charset=UTF-8^^/> <title>Google Maps</title> <style type=^^text/css^^> html, body { height: 100%; margin: 0; padding: 0; } #map_canvas { height: 100%; } </style> </…
-
- 1 reply
- 10.3k views
- 1 follower
-
-
Hello, Just wanna ask about my script in web viewer I'm having trouble making this script having multiple pinpoint in one map Here is my script: "data:text/html, <html> <head> <meta name='viewport' content='initial-scale=1.0'> <meta charset='utf-8'> <style> #map { height:100%; width:100%; } html, body { height:100%; margin:0; padding:0; } </style> </head> <body> <div id='map'></div> <script src='https://maps.googleapis.com/maps/api/js?key="I have my api i just remove it"'></script> <script> function initMap() { var map = new google.maps.Map(do…
-
- 0 replies
- 2.5k views
- 1 follower
-
-
Hello everyone. I have two related tables. One main table and another with delivery note records. In the main table, I have a field where I enter the delivery note number and I receive all the records from the related table. In the main table, I have 5 fields, and in them I want to receive the related data from the related table. For example: Item 1 (main table) I retrieve Item 1 data from the related table, Item 2 in main table, get the Item 2 data of the related table. If, for example, I have 6 records corresponding to the same delivery note, when I retrieve the data in the main table in the Item1 field, the data is correct, but in the Item 2 field, I recei…
-
-
- 3 replies
- 5.7k views
- 2 followers
-
-
I am trying to setup a calculation to select a number or letter from a field. Like Social Security number. I have that field and put in the social security. But for a form i want each number to go in a field so i can use on a form. If i use left(ssnumber, 1) i am good it is the rest that is tricky. is there any help out there and thanks in advance, I tried the middle function but that i did that wrong.
-
- 7 replies
- 1.7k views
- 1 follower
-
-
I have a filtered portal on layout, where I want to identify which portal row each row is and be able to identify this on the layout Table name is 'Contacts' On my layout, I have used a new relationship so the table used is 'Contacts_2' I have created a calculation in the Contacts table that runs in the context of the Contacts_2 table of 'Get (RecordNumber)'. This field shows correctly on with the portal row number. However on the main layout, when I have selected a contact in the portal, I populate the rest of the fields in main layout from table 'Contacts' based on a relationship, and I want to show the portal row number from the corresponding record…
-
- 10 replies
- 1.7k views
- 1 follower
-
-
Hi, all: I have a two-part problem: First, in the attached file, is there a way (in the Parent table/layout) to create a calculation (in CombinedLevels__lct) that will show a comma-delimited list in ascending order--similar to what you see in the portal--sorted by the numeric equivalent grade levels (CHILD::Data__lxn) instead of CHILD::Data__lxt? I can't use a portal since it eats up too much space in the layout I'm working in. Second, I tried all kinds of permutations in the Custom Function to populate CHILD::Data__lxn with a zero (for the value, K, in Data__lxt) but I just can't push a zero in the field--I have to change the field type to a Number field a…
-
-
- 10 replies
- 356 views
- 1 follower
-
-
Greets, all: I'd like to take child records (from/in a join table) and use a calculation to create a consolidated text string list (see attached)--the data's in the portal, but I'd like the output to look like like the two lines of text above it. I played with using UniqueValues and List, but I just can't get my head in gear to utilize those correctly no matter what syntax I've tried. Another possibility that just occurred to me is a script trigger that would run OnRecordLoad, but I still don't know how to pull this off. (I'm sure it's not too difficult, just that I'm being dense.) As always, thanks in advance for your time. Rich
-
-
- 8 replies
- 1.7k views
- 1 follower
-
-
Howdy all: I'm using this calculation to parse the department from a character string: Let ( db = District_Building__lxt ; If ( PatternCount ( db ; "Columbus Public - High School" ) or PatternCount ( db ; "ESU 7" ) or PatternCount ( db ; "Columbus Public - Kramer" ) ; Let ( [ len = Length ( db ) ; lastSpace = Position ( db ; "-" ; len ; -1 ) ] ; Right ( db ; len - lastSpace ) ) ) ) The calculation works, but curiously it inserts a character space at the beginning of the output of the calculation. How can i filter/calculate it out? Here are some samples of the …
-
-
- 1 reply
- 2k views
- 2 followers
-
-
Hi all I've inherited a project that I'm struggling to implement into a solution I've been asked to work on to see if FileMaker is an appropriate solution. Currently I'm working on a basic timecard system that uses a series of overtime schedules to break down hours worked into straight time, time and one half, double time, etc. Currently this is not calculating pay, but rather separating the hours worked during the day into their respective threshold categories. To begin with I've created a database and table called "hours testing" and have the following fields: schedule name - day number (1-7) - date - call - meal 1 out - meal 1 in - meal 2 out - meal 2 in…
-
- 7 replies
- 2k views
- 1 follower
-
-
I need a way to get the next available number on the sequence. I have a list of number 0001 0002 0004 In this this i should identify the next available serial should be 0003 then following 0004
-
- 1 reply
- 453 views
- 1 follower
-
-
Hi all, I support a FileMaker 22 Project Management database. Recently, the project manager I'm working with started using the database to calculate his project management fee and generate his invoices. His fee for each project is based on the total expenses accrued by the project. He currently has five different "Expense Cases" that have been set up by the organization he is working with that determine the fee he charges. Here is how it is currently structured: Cost of Work Case 1 - Under $350K Hourly Basis up to maximum of $15,000 Case 2 - $350K to $1,000K $15,000 on first $350,000 and 3% on next $650,000 Case 3 - $1,000K to $2500…
-
- 2 replies
- 388 views
- 2 followers
-
-
(Using FileMaker Pro v21.x) Happy holiday season to all: For reasons my boss wants (for our FMP ordering system), she wants records using the same product type to be sequentially ordered in each order no matter how many of the same item is added or deleted before the final "File Order" button is clicked, e.g., COPY-01, COPY-02, COPY-03, COPY-04, etc. It makes sense since there are subparts to each item so it makes it easier for the Billing team to reference all the charges to COPY-01, all the charges to COPY-02, etc. I suppose I could code a script that would fire every time an item is added or subtracted from the order so it would renumber the items sequen…
-
-
- 2 replies
- 1.9k views
- 2 followers
-
-
Help me, I'm struggling with the process I want to achieve. Here is the process for setting the amounts in my Plan B: I have a field for the Enrolment Fee with an amount of 715, which I will subtract from the Total School Fee of 21,605. The total difference of 20,890 will be divided by 8, resulting in 2,611.25. Let's assume this amount is 2,620. Now, this 2,620 needs to be set for the month of September. Like this: The next step, to set the amount for the month of October, is to subtract the amount of September ( 2,620 ) from the Miscellaneous Fee that has an amount of 3,400. So the total difference is 780. So here's what i want to happen, I want …
-
- 1 reply
- 1.9k views
- 3 followers
-
-
I'm struggling with the syntax to make it behave like this msSQL does: I'm doing this to avoid unstored fields redition of the sums and to avoid filtered portals.... --sd
-
-
- 2 replies
- 2.2k views
- 1 follower
-
-
I'm trying to convert data contained within a list to a format that can be used for a google chart. If at all possible, I would like for the conversion to take place within a single calculation field and I think there should be a way to handle it using the While function, but I'm struggling to get the configuration right and was hoping someone here more capable could provide some direction. Input List 2 October 23,Employee 1,10336 2 October 23,Employee 4,1500 3 July 24,Employee 3,2500 4 July 24,Employee 2,5228 4 July 24, Employee 3,1038 4 July 24, Employee 3,3700 4 July 24, Employee 4,3700 4 June 24, Employee 1,1276 4 June 24, Employee 1,206 …
-
-
- 6 replies
- 2.3k views
- 3 followers
-
-
When I try to save as PDF it returns error 3. From FIlemaker Client to Filemaker Server, it is working properly.
-
- 6 replies
- 834 views
- 2 followers
-
-
Hi, I have a List in a field 'List A' and also a List in a field 'List B' I need a calculation field to filter the list so it only shows me the items from List A that are NOT in List B. I can do the opposite (show me items that are in both lists) easy enough using filtervalues. Any help appreciated. Thanks
-
-
- 4 replies
- 1.9k views
- 3 followers
-
-
why speak cant be scripted in windows
-
- 0 replies
- 1.8k views
- 2 followers
-
-
1:: SCRIPTED TOOLTIP FORMULA TO GET INFO FROM ANOTHER TABLE If (B1::AR ALERT = 1 and B1::MR ALERT ≠ 1 ; B1::AR ALERTS ; "" ) & ¶ & If (B1::MR ALERT = 1 and B1::AR ALERT ≠ 1 ; B1::MR ALERTS ; "" ) & ¶ & If (B1::AR ALERT = 1 and B1::MR ALERT = 1 ; B1::AR ALERTS & ¶ & B1::MR ALERTS ; "" ) WHEN THIRD CONDITION IS OK ABOVE IM GETTING EXTRA SPACE ABOVE HOW TO GET RID 2:: IS IT POSSIBLE TO CONDITIONALLY FORMAT A FIELD WITH INNERSHADOW AND OUTERSHADOW Case( B1::AR ALERT = 1 and B1::MR ALERT ≠ 1 ; B1::AR ALERTS ; B1::MR ALERT = 1 and B1::AR ALERT ≠ …
-
-
- 9 replies
- 2.3k views
- 2 followers
-
-
i have a calculated result field named FINAL - RESULT is 1.1 desired result " i want is 1.5 with script for example using if substitue and result " for example im writing script forgive typographical errors if ( right(final;1)>1andright(final;1)<5 ; .5 ( i want .1 to be replaced by .5 ) ; final ) many times we do complex calculations sometimes small1s doesnt bright up the spark ;( may be due non stop designing my brain hung up im going wrong somewhere my medical brain couldnt find it out please help me :(
-
-
- 10 replies
- 2.3k views
- 2 followers
-
-
Hi Everyone, I guess I'm doing something stupid! I'm trying to find a character in a string, working from the RHS. Position ( "123456789" ; "7" ; 9 ; -1 ) returns the value 7. And I had thought that it would return 3, as starting from the RHS (due to the -1) 7 is the 3rd character. Position ( "123456789" ; "7" ; 1 ; 1 ) gives me 7 Position ( "123456789" ; "7" ; 1 ; -1 ) give me 0 Position ( "123456789" ; "7" ; 9 ; 1 ) gives me 0 Checking it with different numbers, Position ( "123456789" ; "2" ; 9 ; -1 ) returns 2. Again, I had thought that it would give me 7 as that's the 7th digit from the RHS Can someone tell me what the …
-
-
- 8 replies
- 2.1k views
- 5 followers
-
-
How to get the json information on the line $script = 'Web: Generate Invoice Report'; $doc_data = [ 'type' => $type, 'clientID' => $clientID, 'invoiceNumber' => $invoiceNumber, 'jobNumber' => $jobNumber, ];
-
- 5 replies
- 625 views
- 2 followers
-
-
I have four categories in my Year Level portal in FileMaker: Enrollment Fee, Miscellaneous Fee, Tuition Fee, and Other Fee. Each one of them has a dedicated amount: Enrollment Fee has an amount of 695, Miscellaneous Fee has 2,194, Tuition Fee has 11,349.20, and Other Fee has 1,870. What I want to happen is to create a plan where the Total Fee of the four categories, which is 16,108.20, will be subtracted from the Entrance Fee with an amount of 9,808.20, and from the Scholarship with a dedicated amount as well. Then, the total will be divided by 9. What calculation or function in FileMaker should I use to achieve this process?
-
-
- 17 replies
- 2.7k views
- 2 followers
-
-
Howdy, howdy: I'm stuck in trying to figure out how to pull this off (see attached.) What I want to do is take each comment (left pane, a portal) that has either (or both) the Impact or Implementation checkbox ticked and insert those comments into their respective columns (in the right pane.) So, the first comment, "Over 90 tech tickets..." would fall under the Impact column; "Utilizing the ESU more now..." comment would go into the Impact + Implementation column, "Like the instructional coaching." wouldn't appear at all, etc. Obviously, the records would be pulled from a found set made in the child table where the initial pull would be of records belonging to a…
-
- 4 replies
- 1.9k views
- 2 followers
-
-
Hi all I've written a small database that calculates crew hours in the production and entertainment industry. I've been asked to "flag" employees automatically that have turnaround violations (i.e. they weren't given enough time off between finishing the previous day and starting on the current day as stipulated by their particular union contract.) The goal being to list the names each day so the department heads have an idea who are accruing these rest period violations. I currently have a "day" table where the work date is entered and each employee working is added to a portal and their hours are entered ("DailyHours"). These are further broken down into weeks…
-
-
- 2 replies
- 1.8k views
- 2 followers
-
-
Or is it just me?? https://tinyurl.com/bdcmsc9w It's the examples made in 3. and 4. --sd
-
- 7 replies
- 2.1k views
- 2 followers
-
-
I know it is possible from a button. But is there any workaround to do it from a portal row (button)? Thank you.
-
- 14 replies
- 2.4k views
- 3 followers
-
-
I have a text field with this autoenter calculation: List (Table::PrimaryID ; 1 ). It works fine and returns the PrimaryID + carriage return + 1. No problem with that. Is there a different behaviour if this field is used in a relationship that I don't know. Because in my solution, sometimes works some others it doesn't. Thanks.
-
-
- 9 replies
- 2.3k views
- 2 followers
-
-
Hi, I have a field (field_a) with an imported value of: 0.06825066050921494 I also have a calculated field (field_b) that uses the imported field, however, if I remove all calculations and only use field_a as a 'calculation' the value in field_b, the value becomes 6825066050921494. the 0.0 is stripped of all imported values, rendering any calculation using that field useless. Field_b result is set as a number field, indexed. If I change the first 0 into a 1, it updates the field but still ignores the decimal point. Import value: 0.06825066050921494 Changing the first 0 to 1 changes the calculated value to: 106825066050921494 I have tried…
-
- 3 replies
- 2k views
- 2 followers
-
-
How could I extract the first continuous string from the right in a text field? The string can contain letters, numbers, as well as special characters such as "-", or "_", or ".". Therefore RightWords or MiddleWords fails/returns incomplete results Here's an example: -rwxrwxrwx 7 998 1001 244678656 Jan 26 19:11 HBS5_Prototype-DragDropV2.fmp12 What I'm looking to extract is "HBS5_Prototype-DragDropV2.fmp12" The content to the left is variable, as is the string to be extracted. What is constant is the " " space (and the fact that within the string there are NO spaces). Here are some more examples: -rwxrwxrwx 1 998 1001 4308992 Fe…
-
- 2 replies
- 2k views
- 1 follower
-
-
I have a list and I want to separate it into chunks of, let's say, five values each, and then present it in colums. I think the way goes through the while function in which I'm not very good... I can make the chunks, and in another while emulate the final result I want to accomplish, but I can't connect the dots... Any advise?
-
-
- 14 replies
- 2.9k views
- 2 followers
-
-
After searching the forum and looking into some others, finally I have to ask for some help... I’m trying to make work a calc field in a portal and I can’t figure out what am I doing wrong because not always shows the correct count of days (lack of knowledge must be key, for sure, lol). Everything seems to work fine, except the field that counts the overlapped days. I upload a demo file, I apologise it’s in Spanish but I’m sure it’s easy understandable. Is it the relationship, is it the calc? I’m lost. FechasSuperpuestas.fmp12
-
-
- 10 replies
- 2.6k views
- 1 follower
-
-
I have a numeric field that I use to set different types of record, and another field to see the text that each option means. 0, 1, 2, 3 -> Orange, apple, peach, lemon... Is there any way to make it work if I use a check box and select two values? Using a third field? 0, 2 -> Orange, peach I know it’s easy if I set a value list with the four types of fruits, and then use (substitute(list)). But I’d like to keep using numbers. Any advice? Thank you.
-
- 3 replies
- 2.3k views
- 2 followers
-
-
Hi. I have setup a google API to bring in emails into new FM records. From that FM record I create new records in another table. I'm having trouble parsing the text in the body of the email. Wondering if anyone has some guidance on how to accomplish extracting the "Address Number" and "Address Street from the body field in the message table. The location changes depending on the call type (the one below is a Fire - Alarm). but the address number is ALWAYS on line 3 and after the word "at ". Similarly, the Address Street is always after the Address Number and the street name ALWAYS ends just before the "," Here is how the emails come in and …
-
-
- 1 reply
- 2k views
- 1 follower
-
-
HI I add name for one table to 2nd table via script ,I want to add only in empty portal row ( example if firt portal row is empty name come to first portal , if not empty goes to 2nd row and so on .... how if add a script step that i do that ,
-
- 1 reply
- 2k views
- 1 follower
-
-
Hi guys! I hope someone can help me with this. I have a SUMMARY LIST field which contains types of items eg. (shoes, shoes, sneakers, boxers, jumpers, boxers, jackets, shoes, sneakers...). These items are also listed in a value list (boxers, jumpers, shoes, jackets, sneakers) Is there a way how I can generate a count list of items by and in order of the value list? Taken the example above, this count list would look like this (2, 1, 3, 1, 2). The commas here should actually be the carriage return. Tnx a lot!
-
-
- 11 replies
- 2.5k views
- 1 follower
-
-
Greetings, Curious if anyone has ever experienced a field validated by calculation that is validating correctly (when anything on the record is modified - it is meant to only require a value when another field has a specific value), but when certain repeating fields on the same record are modified, it acts as though the original field is suddenly invalid/empty? Additionally does not seem to bring me to the field in question when I select "No" from the custom message (doesn't seem to bring me anywhere). The validation calc is simple: If(IsEmpty(Self) and Field1>0;0;1) I know the field is in a validated state because 1. it's not empty, and 2. other fields…
-
- 5 replies
- 1.1k views
- 1 follower
-
-
Howdy, howdy... I have an Events database with a related table (Dates) since a named event can occur on multiple dates, e.g., SAT Study Hall can occur on 6/1/2023, 6/3/2023, and 6/11/2023, or 6/1/2023, 6/2/2023, and 6/3/2023. (As an aside, the reason why the Dates table is related is because there's also a grandchild table (Attendees); each day's attendees can be the same or different depending on whether all the attendees show or not. This conforms to the one-to-many relationship model...I hope.) Currently, I have a checkbox/flag field users click to show whether an event's dates are sequential or non-sequential; the result of that is a calculation that display…
-
-
- 3 replies
- 744 views
- 1 follower
-
-
I’m trying to create a field calculation to display the date found in the second row of a portal. This will be used in reports and other layouts to show the precious date something was done. I already can display the current date (first row). The portal is a running history and has many entries for each item, but want to just show the previous date in the calculation field. I’d like to do this at a calculation, but lost on how to do this. Can’t find any answers online and the few ways I’ve tried don’t work. is this possible?
-
-
- 9 replies
- 1.1k views
- 1 follower
-
-
This is a funky issue that doesn't seem to be limited to FMP, but it's also showing up in Excel. This is on a check register file. I have a transactions amount field and a running total, which is the balance. I've been able to verify the very transaction is entered and accounted for, but I'm off form what the bank shows. I exported all of the transactions to Excel and had it do it's own running total, which matches what was exported from FMP. Here's where it gets odd. In Excel, I had it do a calculation in each row that subtracts the imported running total from it's running total. Every single one should be zero, but I have some that it says for example -1.2207…
-
- 22 replies
- 1.8k views
- 1 follower
-
-
I've created a photo catalog in FileMaker and import the images directly (not referenced) into an 'image' container field. In the process I capture the filename and filepath. I've realised the photo scanner I use is making B+W images too dark so I might have to process them through an app and lighten them. For already imported images is there any way to overwrite the current images using the Import function where the image path or filename is matched and only the image container field is updated? I've done this previously with other data but can't recall if I've done it with embedded images.
-
- 6 replies
- 958 views
- 1 follower
-
-
there is a bug I cannot figure out (which I did not modify at all other than creating a new record for example purpose). The solution is in french but nothing complicated about it. The problem fields appear to be (but it could be something else) : Taux TVA Montant TVA Sous-total The problem is that the tax rate (Taux TVA) multiplies Sous-total as a whole number and not a percent. In the attached example, if I enter the number 5 or 0.05 or whatever else with a 5, the result is always 475$ for Montant TVA. The calculation uses a $ to make it a local value but even if I close the solution and reopen it an enter 0.05 for example, it still cal…
-
- 2 replies
- 715 views
- 1 follower
-
-
I'm doing a budgeting page, and have two fields. A Start Date and End Date. The idea is let's say I want to show bills due between the 1st and the 15th, then the next record would be the 16th to the end of the month (let's just go with the 30th for easy math.) I might need to adjust the starting date because the 1st might be on a weekend. So, what I started with was a calculation in the End Date, to look at the Start Date of the next record, and subtract 1. That is simply: GetNthRecord ( StartDate; Get ( RecordNumber )+1) The problem comes in with the last record, since there is no next record to look at, but I'd still like to plug in a range of dates for a…
-
- 6 replies
- 880 views
- 2 followers
-
-
I have a text field that looks like this: ,Time: 2/26/2023 8:22:29 PM,Station: Buffing Queue,Time: 2/26/2023 8:22:34 PM,Station: Sanding Queue,Time: 2/26/2023 8:22:35 PM,Station: Saw Queue,Time: 2/26/2023 8:22:36 PM,Station: Buffing Queue any tips on how I parse this and pull out each time? and calculate how much time has passed between stations? Thankyou kindly!
-
-
- 4 replies
- 1k views
- 2 followers
-
-
I have a join/xref table where I populate two different ID fields throug two differente relationships. Let´s say, I set an invoice number and if that invoice it´s paid, the Invoice Paid ID field gets populated in the join/xref table. If it's not paid, the Invoice UnPaid ID field gets populated. The thing is. If I have to "re set" the invoice as paid/unpaid, when I reselect it again, the other field (paid/unpaid) gets populated, but the first one remains with data. What I want to accomplish is, how could I like "toggle" between the two fields (one gets full, the other gets empty). I'm not very good at relookup scrip step yet. …
-
- 4 replies
- 1.2k views
- 1 follower
-
-
Hi All. Attempting to implement an Excel spreadsheet I have been using into a newly designed FileMaker database, but the Excel sheet isn't without limitations. The attached Excel spreadsheet file was provided to me to help start the process. The attached file is a timecard, however what I'm doing doesn't require calculation of wages - just tracking departmental daily film industry hours worked in "clicks" (tenth of an hour, military time) so we can submit the report for our department to our manager at the end of each day. I need help repurposing the calculation for meal penalties, particularly Union meal penalties. Please see Excel formula below exampling the calcul…
-
-
- 5 replies
- 1.3k views
- 2 followers
-
-
Hi all. Attempting to sum hours worked using SQL where a separate field matches a particular value in another field. The calculation is determined from the "Tax Year" table. The calculation references a child table where the job entries are created - Relationship is: Tax Year::YEAR = Job Lines::YEARid ExecuteSQL ( "SELECT Sum (HRS TOTAL) FROM \"Job Lines\" WHERE IA = 'Y' YEARid = ? " ; "" ; "" ; "" ; "" ; TAX YEAR::PrimaryKey ) I keep getting a ? as a result. My suspicions are somewhere in the last three lines of the calculation. Any ideas?
-
-
- 1 reply
- 620 views
- 1 follower
-
-
Greets all: I found the attached solution* to create a value list based on a calculation, but when I substitute the values in Field A's value list with non-numeric values, the solution fails. Why? I'd like to be able to replace W1, W2, and W3 with non-numeric values, but I can't see (by looking at the existing calcs) why the solution fails when you remove numbers from Field A's value list. Cheers, Rich *https://community.claris.com/en/s/question/0D53w00005QdyVqCAJ/value-list-defined-by-a-calculation Day Selector.fmp12
-
-
- 2 replies
- 960 views
- 2 followers
-
-
Howdy all: The goal is to take the contents of the Notes field from each record in a found set and combine them into one field with a line space between each note entry; it'll then end up as a text inserted into a Send Mail script step. Rather than the traditional way of looping through a found set of records to create this--or even using a Summary (List of) field--I thought I'd try my hand at using the (new) WHILE command but for the life of me I can't figure out how it works even after re-reading Skeleton Key's fine article ( https://skeletonkey.com/filemaker-18-the-while-function-looping-in-calculations/ ). I'd appreciate some guidance in putting it together.…
-
-
- 1 reply
- 802 views
- 2 followers
-
-
Hi all I am trying to utilize ExecuteSQL to calculate earnings per quarter last year, however it doesn't appear to be working and I'm sitting here scratching my head. Table JOB LINES - where each check is entered and the check issue date. Table JOB TRACKING - contains portal for JOB LINES where data for each tax year, including checks and the quarterly earnings fields. Other calculation fields are able to reference each table accordingly and return accurate results for each tax year. Let ( [ sqlQuery = "SELECT Sum (Chk_GROSS) FROM \"JOB LINES\" WHERE paymentFlag IS NULL AND Chk_DATE BETWEEN ? AND ? AND Form IN («FORMS») " ; FORMS = Substitute ( JOB…
-
- 1 reply
- 1.3k views
- 2 followers
-
-
Hello all. I have an attendance table that holds a few calculation fields based on on a stipend program for firefighters. For each attendance record it calculates the stipend payout for that particular record. Then I have a summary field in the attendance table that gathers all the records and adds them for each firefighter on a new layout. There is one piece I can't figure out how to make work. If the firefighter is an "Officer" they are given a set value (from a personnel record table) added to the stipend. I cannot get a calculation to work adding those two values together. Here is what i have been trying to manipulate to make it work. I'm gues…
-
- 3 replies
- 1.5k views
- 3 followers
-
-
Hello forum. Don’t know if this is possible. What I was hoping to do was to show related data, 2 data point pairs in a single horizontal line, kind of like a progress bar. For example the following related records data points consist of an angle and a measurement: 0 23.5 22.5 42 22.5 36 90 38.25 What I hope to display would be a horizontal line where the the first (left side) would show 0 (angle) on top of the line and 0 (measurement). The next point (segment of the line) would show 0 (angle) on top and 23.5 (measurement), and so on until the end of the line shows 90 on top, 38.25 on bottom, with the total length equ…
-
- 4 replies
- 1.2k views
- 2 followers
-
-
Hi all. I am having a horrible time trying to fumble my way though what should be a simple ExecuteSQL calculation. I'm trying to count the number of records in the ACCOUNT table that have the value of "Bergen" in the field called CountyName. Am I doing something wrong, the calc isn't working. i've tried single and double quotes around the field value of Bergen and it doesn't change anything. Thank you in advance for looking and trying to help me. Chris ExecuteSQL ( " SELECT Count (id) FROM Account WHERE CountyName = Bergen " ;"";"")
-
- 2 replies
- 1.2k views
- 1 follower
-
-
I have three fields that i call: apples, bananas and oranges... and there's a fourth field called: basket... I want to know which fruit or fruits is/are present in the greatest quantity in the basket. Now I'll give you some examples: 1st case: apples = 3, bananas = 2 and oranges = 1. In the basket I would like "apples" will be written down because apples are more than bananas and oranges. The same needs to be if bananas are more then apples and oranges. 2nd case: apples = 3, bananas = 1 and oranges = 3. In the basket now I would like "apples and oranges" will be written down because they are the fruits in greater quantities and are in equal number. 3rd case: apple…
-
- 2 replies
- 930 views
- 2 followers
-
-
Hello everyone, I've got a problem. I'm trying to build up a very simple database with two tables. Basically I want one set of records where I can input the repayments of some loans, and another table where I can get the status of the loans (how much is left to pay and how many rates have been paid so far or how many rates are left) TABLE 1 FIELDS (Multiple Records) CREDITOR, Text Field, (has a dropdown with 3 names) DATE, Date Field AMOUNT, Number Field TABLE 2 FIELDS (One Record) CREDITOR1, Calculation Field = 10.000 - If (TABLE1::CREDITOR = "CREDITOR1" ; TABLE1::AMOUNT ; 0) CREDITOR2, Calculation Field = 20.000 - If (TABLE1::CREDITOR = "C…
-
- 3 replies
- 1.2k views
- 1 follower
-
-
I've seen quite frequently how having a lot of fields with unstored calculations may result in sluggish database performance. Most articles and forum posts I've found suggest using a script to set values instead of using a calculation field. The idea makes sense to me, but I'm a bit at a loss when it comes to how to implement such a change. I humbly request assistance with one of my simplest applications: There are two tables: Product List, Issues In a portal for the product list, I want to count the number of open issues per product. As it stands now, I have a calculated field on the product list to count open issues on the Issues table. Because it's …
-
-
- 1 reply
- 895 views
- 2 followers
-
-
Hi, I have a current field that is a calculation that displays the last data from a relationship (the relationship is sorted by the date of a particular field) Is there a simple way to display the 2nd last, and 3rd last in the same way Last ( Certs::result ) I think Max works in the same way for this purpose and displays the latest related record Max ( Certs::result ) Thanks!
-
-
- 11 replies
- 1.4k views
- 1 follower
-
-
Is there a way to trigger what value i selected on a field with multiple checkbox? I have field with valuelist checkbox. How do i know what value i selected when checking the box?
-
- 1 reply
- 613 views
- 2 followers
-
-
I have this problem on how to get the nearest price. I have field qty and price ex. qty 100 price $41 and qty 250 price $39. how to calculate to get the correct price if i enter 105 i should get 39
-
-
- 4 replies
- 860 views
- 3 followers
-
-
Hello, have puzzle to solve, and I'm not certain how to approach it. Thought I would post here and see how others may approach this. I've attached a little demo file to play with. In my ITEM table I build out charges that I will invoice Clients. I commonly charge people in 3 ways: 1) hourly fee (rate * hours) 2) markup fee (expense + markup) 3) flat fee (arbitrary set fee) Thinking that the expense field is the starting point. Trying to make data entry minimal as posible, only give User "markup" fields if there is an expense (tho I wonder if saying [expense > 0] is solid enough to build off of as used in the demo). In other solutions I've …
-
- 7 replies
- 1.6k views
- 2 followers
-
-
Hello! I'm not very familiar with the Barcode Generator Add-on (yet), maybe it's not a very difficult issue to solve I would like to set the settings of the Barcode Configurator, however, upon dragging the barcode generator add-on onto the layout and opening the settings, the window is not completely shown and hence I can't save the changes made. Any help would be really appreciated!!
-
- 0 replies
- 921 views
- 1 follower
-
-
👋 Hello and thank you! 😊 looking for a calculation to properly concatenate address/suite/city/state/zip fields with punctuation on one line ie: 1235 Alley Way, Suite A, Dreamcity, 95991 CA also looking to avoid goofy results if there is any missing data ie: ,, Suite A, Dreamcity, 95991, with my limited knowledge I'm currently using: Case(not IsEmpty(address); address & ", ") & Case(not IsEmpty(suite); suiteTitle & " " & suite & ", ") & Case(not IsEmpty(city); city & ", ") & Case(not IsEmpty(state); state & " ") & Case(not IsEmpty(zip); zip) which may work if I could trim off the ", " at the end if ever …
-
-
- 4 replies
- 816 views
- 2 followers
-
-
Howdy all: I'm flummoxed. The following calculation works fine: TextSize ( TextStyleAdd ( LABEL_WORKSPACE::Field1__lxt ; Uppercase + Bold ) ; LABEL_WORKSPACE::_g_Field1_FontSize__lxn ) However, when I replace the argument for the style change with a global field that has the same text (Uppercase + Bold), TextSize ( TextStyleAdd ( LABEL_WORKSPACE::Field1__lxt ; LABEL_WORKSPACE::_g_Field1_StyleChoice__gxt ) ; LABEL_WORKSPACE::_g_Field1_FontSize__lxn ) ...it doesn't change the text's format--it remains plain. I looked at the Help page and didn't see anything that says that the argument can't be a field, just that it has to be text. Am I missing …
-
- 3 replies
- 1.1k views
- 2 followers
-
-
I have to work with imported data that consistently follow this pattern. tbn:ANd9GcRd4fVcExYeQOa4L3AahyuyAh4rlLfaKuHd6EWJZAlcKSUYVJS7IcugGE1impKxwfJDTvU:https://get.pxhere.com/photo/food-natural-foods-whole-food-Food-group-superfood-cuisine-local-food-vegetable-ingredient-dish-vegan-nutrition-produce-vegetarian-food-delicacy-still-life-meal-recipe-herb-still-life-photography-1621684.jpg The field contents aways begin with tbn, followed by a colon. An apparently random string follows, always ends with a colon. There are never any colons in the string (except at the beginning and end). The URL follows the second colon. I need to create a calculation …
-
- 2 replies
- 977 views
- 2 followers
-
-
Greetings, So I have multiple Container Fields and I want to create a script that can be used on those multiple Container Fields instead of creating each script for each Container Field. I have a simple working "Insert PDF script" below: Go to Object [Object Name: "Container1"] Insert PDF [] But of course the problem is that if I have 20 Container fields I will have to write each script for each Container field. Not to mention the Delete PDF Script. So I tried the Set Trigger Script on Object Enter and it works fine when I click the Container Field I am able to insert a PDF but the problem is that the script will run regardles…
-
-
- 2 replies
- 981 views
- 1 follower
-
-
So I have multiple dates sort of like a start to end dates. Date1, Date2, Date3, Date4, Date5 Each date is later than the previous date. My question is how can I count the days in between those dates (excluding the weekends and holidays)? For example: Date1 to Date2 = 3days Date2 to Date3 = 7days Date3 to Date4 = 2days Date4 to Date5 =12days Total Days = 24days I followed the guide on this page https://support.claris.com/s/article/Calculating-Number-of-Weekdays-Work-Days-Between-Dates-1503692920764?language=en_US and it works fine without the holidays. But I am having difficulties when trying to include the holidays in the calc…
-
-
- 6 replies
- 1.4k views
- 2 followers
-
-
So I have 3 text input Fields and 1 Status (Calculation) Field. I want the Status Field to calculate if: all the 3 text fields are empty it will output "Pending", if one or two text fields are not empty it will output "In Progress" and if all 3 text Fields are not Empty then will output "Completed". How can I go about doing this? I tried a few Case and If statements and always end up only between "Pending" and "Completed" as a result and couldn't get the "In Progress" result. A little light on this would really appreciate it. Thank you.
-
-
- 2 replies
- 770 views
- 2 followers
-
-
Hello forum! I was wondering if there is any 'tricks' to converting a very long Excel formula to use in FM. The formula contains Ln( ) and Exp ( ) functions. I tried the usual-changing the Excel cell references to FM fields, changing the commas to semicolons, but end up with entirely different results. I went through and (tried) to break down chunks of the formula and they match up. But all together, still a different result. Any tips would be appreciated. Thanks! I'm attaching a simple version of the SS and the FM file, just for reference. Unless it's something obvious I don't expect anyone to delve into it for free. If it's something someone wants t…
-
- 9 replies
- 1.9k views
- 1 follower
-
-
Im struggling with this. I have a series of about 50 parameters which are used as a multiplier to a field in another table. A simplified example would be I have a number of persons in a "Staff Table". Some staff get an office and some get an open plan workspace. Each staff member would have a designation type to determine office or workstation. The "parameter" table would show 12 sq m for an office and 6 sq m for a workstation. Basically the number of staff * the area rate is required (in each category). My problem is I believe I have too many parameters to have a single record and the alternative is to have 50 records each with a small number of fields but how…
-
- 1 reply
- 793 views
-
-
Greets, all: I'm not sure if this is a calculation issue or a script one, so I apologize if I'm posting in the wrong place. Objective: Have a text box (or button) appear when a global variable is set to 1. (The text box has the word SENT in it to confirm to the user that an e-mail has been sent via a mail script.) I There's a two-second delay for the object to appear, then it'll be cleared by said script. The problem is, *blush*, I can't get it to work. The script part is fairly straightforward: Set Variable [ $$_SentMessage; Value: 1 ] Pause/Resume Script [Duration (seconds): 2 ] Set Variable [ $$_SentMessage; Value: 0 ] T…
-
- 5 replies
- 1.5k views
- 3 followers
-
-
I would like to use a text field to store links from Hook, then use the OpenURL step to open the linked resources. But when I paste a Hook link into a text field, FileMaker renders it. For example: hook://file/DOFUUff5c?p=SGFyZGluZy9GaWxlcw==&n=H1%20project%20outline%2Eooutline gets pasted in as H1 project outline.ooutline FM interprets what it can, and strips out the rest. I need for the field to store the raw text without modification. Of course, once it does this, there's no guarantee that OpenURL will recognize it, but one step at a time. If anyone else is using Hook, and has a workable method, I would like to hear about it. Thanks.
-
- 3 replies
- 685 views
- 1 follower
-
-
Is there a way to check what are the connected bluetooth device on my PC or Ipad using Filemaker?
-
- 0 replies
- 492 views
- 2 followers
-
-
Hi All, I have a text field which is used for a full property address. I need to extract this data into separate fields, [street address], [city], [state] and [zip]. There are variables I don't know how to address when using Leftwords, Middlewords and Rightwords. For example, an address maybe easy, such as [123 Main Street] [Manhattan], [KS] [88888], while another may be [1234 East 164th Ave, Ste 100] [Saint Louis], [MO] [88888]. Wondering is anyone knows a way to make work or can give advice. Thanks for any help!
-
- 1 reply
- 733 views
- 1 follower
-
-
I'm looking for someone to make a dumb (but useful) function much smarter and more elegant: Case ( GetNthRecord ( DriverPortal_Driverlog::Kilometer From ; 5 ) < 1; GetNthRecord ( DriverPortal_Driverlog::Kilometer From ; 6 ); GetNthRecord ( DriverPortal_Driverlog::Kilometer From ; 4 ) < 1; GetNthRecord ( DriverPortal_Driverlog::Kilometer From ; 5 ); GetNthRecord ( DriverPortal_Driverlog::Kilometer From ; 3 ) < 1; GetNthRecord ( DriverPortal_Driverlog::Kilometer From ; 4 ); GetNthRecord ( DriverPortal_Driverlog::Kilometer From ; 2 ) < 1; GetNthRecord ( DriverPortal_Driverlog::Kilometer From ; 3 ); GetNthRecord ( DriverPortal_Driverlog::Kilometer Fro…
-
- 8 replies
- 832 views
- 2 followers
-
-
Scenario: When users insert an order Due Date, it must be at least three days from the current date (Get (CurrentDate) + 3 ) --or be in the future beyond three days from the current date. However, we want it where if the order is set for a Wednesday or Thursday, the fulfillment date would be pushed to the following Monday since nobody's here on weekends. I found this calculation from our fearless site leader, Comment, from 2005: Let ( dueDate = OrderDate + 7 ; dueDate + Position ( "17" ; DayOfWeek ( dueDate ) ; 1 ; 1 ) ) ...and changed OrderDate + 7 to OrderDate +3, but try as I might I can't get the calculation to work where a new date …
-
-
- 5 replies
- 859 views
- 2 followers
-
-
I'm trying to figure out a good and semi-repurposeable way to do the following. Set a variable to the contents of a field, starting with (and including) an identified string (in this case, the string is unique to the field, but to make the script more general, it can be the first occurrence of the string), to the end of the field. I then want to set the field to that the value of the variable. I probably don't even need a variable, but I have been trying to use one during testing. Set Field seems to be the best function to start with. To clarify: Field initial state: <beginningTextToEliminate> uniquestring <endingTextToKeep>…
-
-
- 2 replies
- 731 views
- 1 follower
-
-
Hi, Im trying to get a calculation for a field so when "Status" is changed to say.. "Canceled" then the "Canceled date" field auto fills in the current timestamp.
-
- 4 replies
- 1.1k views
- 2 followers
-
-
I'm trying to clean up some existing data (about 10,000 records). I have an Address field which has primarily been filled with all caps (the entire db is actually, but attacking this piece by piece). So, I'd like to change 50A OAK STREET to 50A Oak Street Replace field contents with Proper (Address) works great except that I'm left with 50a Oak Street. How can capitalize the 'a' after '50'? The number can be 1, 2, or 3 characters long - and in some rare cases, occurs after the street name.
-
- 2 replies
- 602 views
-
-
I was looking for simple lightbox layout for images. I'm using FMP 15 and the only example I could find was from FM7. I got most of the script imported set up but it stalled on FoundSetValues("ImageData::ImageID") and says the function doesn't exist. It works if I open the original converted file but not if I import it into my current image database. Is there a quick replacement for this? The script is below and link to the lightbox file further down. Set Field [ Lightbox::gSetValues; FoundSetValues("ImageData::ImageID") ] Set Variable [ $SetSize; Value:ValueCount(Lightbox::gSetValues) / 7 ] Go to Layout [ “Lightbox” (Lightbox) ] Show All Recor…
-
- 3 replies
- 1k views
- 1 follower
-
-
Hi I have a table with 1000's of records, all of which have a postcode. I need to determine from each field what the first part of the postcode is (GL1, or L1, SN15), which at first I thought was easy. But we have 3 different uk postcode lengths (5, 6 or 7), sometimes the first part of the postcode can be 2 digits (E1), 3 digits (GL1) or 4 digits (GL11). What i'd like is an another field that sits in the same table, that is an auto calculation that just has that first part of the postcode. But is hard due to them being different lengths, so simple 'Left' won't work for example. Also add to the fact that postcodes may not be entered by the cu…
-
- 5 replies
- 858 views
- 1 follower
-
-
May I ask, I'm making database with ID, DATE and NAME, but I want if I input DATE for example day(2digit),month(2digit)and year(4digit) and I enter it will be automatic in the ID it say year(4digit)month(2digit)day(2digit) and there is 0001 behind day. for example date:25-02-2022 if I enter the ID must be like 20220225-0001 it will be like that and automatically sequentially. sorry if my English is not good. I'm Dedy from Jakarta, Indonesia
-
-
- 9 replies
- 1.8k views
- 1 follower
-
-
I'm building a maintenance scheduling & tracking solution and am trying to create a field, which will calculate the date from the most recent entry into a related, LINE ITEMS table. If I sort the related table by date descending, the following calculation works, as I've used it in other solutions: GetNthRecord ( LINE_ITEMS::date ; 1 ) In this case, I'd like to filter the results by another field in the related LINE_ITEMS table. For example, I'm going to have a text field, which contains a value from a list - MONTHLY, QUARTERLY, ANNUAL. In the parent table, I'd like to have three calculation fields (one for each value), and obtain the (separate) most recen…
-
- 1 reply
- 784 views
- 2 followers
-
-
I have a row of checkboxes to speed up entry, but want their checked values to be pasted into a single text field. So if the checkbox items appear as [ ] apples [X] oranges [ ] pears [X] plumbs, I'd like the text field to have the checked values as words - oranges, plumbs. What options are there for this? It can be as the items are checked or after all the data is entered in the database for a given period.
-
-
- 2 replies
- 1.2k views
- 1 follower
-
-
Greetings to all, I need help to create a calculation that presents the number of the third day prior to the last work day of a month. Date = 1/5/2022 Month(Date) = 1 "I need the calculation to present 27" Thanks in advance!!
-
-
- 9 replies
- 862 views
- 4 followers
-
-
So I have a field name [Company]; each time I am inputting the company's name such as nissan, toyota, chevrolet, lexus, and so forth I want to make the first letter Capitalize "automatically" =Nissan, Ford, Chevrolet and so forth. By the way table name is "Car". How would I do that? do I need to create a script? do I need to use the "Calculation"? I pressed the Help in FileMaker Pro 18 - it shows to use of function ==> Proper (text). However it doesn't work. So far these are what I have tried so far.... 1. Proper(:car::company") - no luck - try to input a new entry still the company's name is all in lowercase format. 2. Proper(car::comp…
-
- 1 reply
- 803 views
- 1 follower
-
-
Hi: I’ve created a file where I’m trying to do a filter according to each concrete customer and one of his products that he has bought. Now I’m trying to create a graphic with the result but I cannot get a monthly count like in the left chart. I’d like to have 3 lines, each of those describing the tend in each year, with the 12 month on the x-basis Is it possible? Thank you very much. RECOUNT.fmp12
-
- 2 replies
- 981 views
- 1 follower
-
-
Greetings, all. This one's tricky: I'm using the List function in a parent table ("PARENT") field to create a comma-delimited list from a child table ("ESU7_DEPT_CONTACT_EARLY_CHILDHOOD" ) using this command: Substitute ( List ( ESU7_DEPT_CONTACT_EARLY_CHILDHOOD::NameFL__lxt ) ; "¶" ; ", " ) It dutifully lists all names from the child table, separated by a comma. However, I'd like the child table names--that are related to grandchildren tables--to be highlighted in red in the aforementioned List function so the output would look like this: John Smith, Jane Doe, A Blivet, Al Capone, Gomez Addams Is that doable? TIA for your help. Rich
-
- 5 replies
- 1.4k views
- 2 followers
-
-
Hi, This is a split thread from Where I began with a fairly large amount of substitutions with codes appended to the known patterns. Comment kindly provided a simpler solution MultiPatternCount+Hilite.fmp12, which beautifully resolves the problem using two Custom Functions: HiliteSingle and HiliteMulti. I start with the text field with TextColor ( string ; RGB(73;99;140)) Blue. If the pattern is detected, and the code is harvested, the known pattern changes to TextColor ( string ; RGB(0;255;0)) Green. The current problem is that it's not recognizing whole words/phrases but rather shorter patterns first. I've ordered the known patterns by counting …
-
- 2 replies
- 963 views
- 1 follower
-
-
Hi, I've created a few thousand (or more) substitutions where a code is appended to a phrase, such as: Substitute ( text ; ["DIABETES MELLITUS, TYPE II";TextStyleAdd("Diabetes mellitus, type II (E119)";Bold+ HighlightYellow)]; ["ALZHEIMER'S DISEASE";TextStyleAdd("Alzheimer's Disease (F009)";Bold+ HighlightYellow)]; ... and so on. I'd like to harvest the codes that have been added to the text and list them, first alphabetically, then numerically. Using the previous example the resulting harvested file should look like: Date | ID | Code 1 | Code 2 2019-05-23 | HGTY87654 | (E119) | (F009) Currently, I'm harvesting the codes by h…
-
-
- 13 replies
- 1k views
- 1 follower
-
-
I have a script for importing records. The script is quite long and executes some other commands as well. Therefore in my case, the "Import Summary" dialog box that pops up rigth after the import is completed, is an annoyance. Is there any way to surppress it BUT allowing the import mapping? PS! I generate my own calculated import summary at the of the script.
-
- 4 replies
- 919 views
- 1 follower
-
-
I have a four Letter Code that I want to prepend to an ID Field, ECHR0001, or AGAV0001. I am a total newbie i can get the letter to generate but i can no t get the auto increment to work with this.
-
- 1 reply
- 1.3k views
-
-
I have a question, and perhaps someone may have a answer (solution). 🙂 I have an application where images are imported using script. Images are imported in the Container field, named [Image]. In another field named [FileName] is where the image filename including the file format is been stored (extracted by calculation upon import). There are several criteria required (file format, among other things.), therefore, images that do not meet the criteria are not imported. The question is: Is there any way to capture and display the file(s) name(s), incl. the file format, of not imported images i.e. “Total records skipped due to erros:” ? Thank you in advance.
-
-
- 6 replies
- 1.5k views
-
-
Hello to you all. I am looking for an Auto-Enter Calculation to extract text of varying length found between two characters. I have two text fields: The first field is named [FileName] and contains image file names e.g. "NIK000223_hab-ven.jpg". The second field is named [ImageType]. Now, what I need is to extract from filed [FileName] and insert to field [ImageType], the any given text that is found between the underscore character “_” and the period character “.” I will greatly appreciate any help. Thank in advance.
-
-
- 9 replies
- 1.4k views
- 1 follower
-
-
In my multi platform solution, I want to save a pdf file to the user Downloads folder in any of both OS, so I've set up this variable: Case ( Get ( SystemPlatform ) = 1; "filemac:"; Get ( SystemPlatform ) = -2; "filewin:"; "" ) & Substitute (Get (DocumentsPath); "Documents"; "Downloads" ) & docs::docName & ".pdf" It works in Mac but in Windows 10, I get an error saying: "docName.pdf" can't be created in this disk. Is this a Windows disk permissions issue? it can be fixed?
-
- 0 replies
- 758 views
-
-
Is it possible to put multiple product pictures in one container field and have it act as a kind of slideshow where the pics change every x seconds for example? If so, how please. Thank you.
-
- 1 reply
- 688 views
-
-
First of all, I hope this question is in the correct forum. I am a total beginner with Filemaker. I have an older version to try out (14 Advanced). I am trying to make a calculation for the following. Im creating a database, for now with 1000 records. Each record has a set of fields. Lets say field A is the name of the product, field B is the type of product it is (type 1,2,3.....), and field C is its value. So lets say I want to know the total value of each type of product...how do I make a field calculation to achieve this? Please be patient with me, I have just started using FM 2 days ago. A sample file for the calculation would be amazing. I learn faster by seeing. Th…
-
- 3 replies
- 1.4k views
- 1 follower
-
-
I'm currently designing a database to track my properties, leases, tenants and costs involved. I want to make this as simple to explain as possible but fear it might not read that way. After spending a few days trying to figure this out I have no idea what to try next. I have an invoicing table related to my lease table (leaseid::leaseid) and on the lease layout I have an invoicing portal which I enter any charges/payments made on that lease. Some records entered in this table are charges/payments towards other companies, like different property management companies that I have. This is selected in a "Vendor" field with a popup menu where I can select said compa…
-
-
- 4 replies
- 960 views
- 1 follower
-
-
I was just wondering if there is a way to set my image container field to launch the webcam on my PC and capture the image (take photo) instead of manually inserting a photo? If there is a way to do this I would appreciate it if you could tell me or point me to where I can find the solution for it. Much appreciated. Using Filemaker Pro 18 on Windows 10 Pro
-
-
- 4 replies
- 3.5k views
- 3 followers
-
Recently Browsing 0
- No registered users viewing this page.