FileMaker Interface Features
-
Hi, Using Server 11 v2, client 11 v2 ...client in city A Server in city B ...vpn connection ipsec...window environment. Everything works fine with all my layouts except for the layout that has a dropdown list to choose a customer to create a ticket. When I click on the dropdown arrow to choose from the list there is a time period lag and then several customers on the list appear to load ready for selection...if I scroll down the list then it will go blank and there is a time delay and then more load ...this process continues until all the the customers are loaded from A to Z ...Once all the customers in the dropdown list appear to be loaded then I can scroll up and …
-
- 5 replies
- 2.5k views
-
-
Afternoon all, In one of my tables i'm storing the URI of images located on my Flickr account. What i would like is to be able to show a thumbnail of the image once the URI has been entered. Flickr offers a square format of 75px x 75px which can be accessed by appending _s to the raw filename before the .jpg suffix. However, when i create a web portal of 75 x 75 with that address, I'm getting a white space appear at the bottom of the box and the top of the image is cut off. Is there a way to remove the white space or a better way to get this funcionality? Thanks!
-
- 2 replies
- 1.7k views
-
-
When I create a new Filemaker database it creates fields that are white on white. I want to define a my own field color as the default. Is this possible in FM11A?
-
- 10 replies
- 1.6k views
-
-
I need to give my users the ability to scroll in a text window, in browse mode, so that the window size can remain fixed. Can somebody please tell me how to do it -- or, at least, how to start? Alternatively,I need to enable them to open a text window that they can move around the screen and re-size. Thanks!
-
- 1 reply
- 1.6k views
-
-
I have made this timesheet for recording my work hours. I made a portal and relationship via the date of the time sheet. When I create a record in the portal, it makes a mirror duplicate of the record in the master. So when I create "1" record, and go to add the job codes in the portal, it makes another record in the main time sheet, not too difficult to fix, however I am drawing a blank on what I am doing wrong. Any advice?? Time_Cards.zip
-
- 7 replies
- 1.9k views
-
-
Hi experts, I want to conditional format a field when the field contains a name with extension of .txt, .pdf, .bmp, .gif, .jpg, .png, or .mov. This one will work, but I'm wondering if there is a better way to write it. PatternCount ( Test::Uploadnames ; ".JPG" ) or PatternCount ( Test::Uploadnames ; ".png" ) or PatternCount ( Test::Uploadnames ; ".pdf" ) or PatternCount ( Test::Uploadnames ; ".txt" ) or PatternCount ( Test::Uploadnames ; ".gif" ) TIA for your kind assistance. Kiele
-
- 2 replies
- 2k views
-
-
Hi, I have created a layout for keeping records of all the projects my company is working on. I have created a field called 'Status' which is a drop down menu containing 2 values: Live and Complete. There is also a field in the layout that is for entering the name of each project. I want to use conditional formatting to change this field to the 'StrikeThru' style when the 'Status' value is changed to Complete. I have tried creating an If formula within Conditional formatting but its not working. Any help would be much appreciated, Ruby
-
- 2 replies
- 1.6k views
-
-
Hi everyone, I work for a magazine and have to calculate how much to pay each contributing author based on the length of his/her poem or article (this part I have working: I have a "Lines/Words" field where the user enters the number of lines [for poems, b/c we pay per line] or words [for articles, b/c we pay those authors by the word], and a script trigger on the field performs a script to see what "genre" is selected from the drop-down menu (basically, article or poem), then computes the payment for each piece and puts this number in an editable field called "piece payment." I need that field to be editable (and not a calculation field) because sometimes we make s…
-
- 1 reply
- 1.2k views
-
-
Hello! I have created a ne database with differente tables, my question is if i can just say to filemaker to display all columns i created in database on layout simple so i don´t have to put every column manually on layout. thank you very much. regards, daniel
-
- 2 replies
- 1k views
-
-
Help - I've got several objects on a layout which keep disappearing! In the attached file, please look at the layout which automatically loads when you open the file, and click on the "Donations" tab. Then click on "Edit Layout" and look at that tab again. Moving individual objects to the top of the tab makes them reappear. Any objects which are completely below a certain point on the layout completely disappear when you try browsing the layout normally! And this is true of labels, too - not just empty fields. I've tried moving these objects to the front, grouping them and ungrouping them, replacing them with completely new ones, sleeping on it... Nothing h…
-
- 5 replies
- 2.2k views
-
-
Through the web viewer, I am accessing a specific site (not my own) which has it's own Print button that switches layouts to a multi-page form, prints and returns to the original layout, just as you might do within FileMaker. The problem is that after the Print Dialog pops up, FileMaker retakes focus and the Print Dialog is behind the FileMaker window. Is there any way I can allow the Print Dialog to retain or even regain focus? I don't want to have to force the users to have to minimize FileMaker to finish printing and then maximize FileMaker after the printing is completed.
-
- 0 replies
- 2k views
-
-
Maybe I am missing something but I have not gotten the following to work. I have a layout with two portals each with 4 columns. I would like to navigate within the portal from column to column on the first row then move to the second portal and do the same. The issue is that with tab order, it will not leave the initial portal after the last column but just goes to the second row.
-
- 0 replies
- 1k views
-
-
image_src: /Applications/MAMP/htdocs/jQuery_Notes/images/image1.jpg body_text_3
-
- 3 replies
- 5.3k views
-
-
Hi, I'm using checkbox in my layout, and realized that the multiple options in the checkbox are dislayed in one line/row. I just wonder if there is any way to separate the different options by rows? e.g. checkbox with three names will look like "Sarah Leah" in the checkbox. Can it be changed to Sarah Leah Thanks! :
-
- 2 replies
- 1.6k views
-
-
Hi everyone, This is another general question that I got stuck with.. I have been using portals in my layouts, and I noticed that the fields defined in the portals are not field contained in the related table where the portal is placed, as portals are just field holders. Am I right? I just wonder if I can somehow make those fields be part of the table, as I need to retrieve the content of those portal fields in the layout where the portal is placed. Hope it makes sense. Thank you. :)
-
- 21 replies
- 3.4k views
-
-
Hi, I wonder if there is any way to reformat the time input in FM.. The default is hh:mm:ss AM/PM. Can I change that to 24-hour type of time input? e.g. hh:mm (with hh in the range of 0-24) Thanks! :
-
- 2 replies
- 1.4k views
-
-
I have employed this method in one of my screens, to enable the user to quickly navigate through records: Although it works just fine, the problem is that in a list view with many records (exceeding the screen) if you press continuously the down arrow, at some point the current record disappears and you have to go back-and-forth one time to make it appear inside the window. Can anyone figure out why this happens?
-
- 2 replies
- 2.2k views
-
-
Is somehow possible to bind multiple dropdowns to drop-down simultaneously? Or 1 dropdown with repetitive fields? My goal is make simple layout with just a few rows of dropdowns which consist of 3 fields. row1: |Dropdown1|Dropdown2|Dropdown3| : rowN: |Dropdown6|Dropdown7|Dropdown8| And if user tries edit any of dropdown in one row the others DP will rollout too.
-
- 1 reply
- 1.2k views
-
-
Is it normal for a layout viewed in Table mode to be refreshed in very low speeds just because one column contains radio buttons? Are radio buttons so burdensome? I've even found that replacing the radio buttons with a calculated container field and a script run by clicking on it, I get the same effect of toggling the field between 0-1, with faster redraw, less possibility for errors and better user feeling (icon is obvious)!!!
-
- 0 replies
- 887 views
-
-
hey guys i've been lurking around a bit, trying to figure out conditional formatting. so far it doesn't quite make sense to me. i have a status field, let's say it's set to 1, 2, or 3 i want to change the color of the field and text based on the status. the examples i've seen of the conditional formatting allows me to make a container field change its color to red, blue, or green. but how do I get this container screen to evaluate the status value? i remember doing this for an invoices database i did back with filemaker pro 4 a long time ago in a galaxy far away.
-
- 13 replies
- 3.1k views
-
-
Hello, Started working on a new project, an eight photo, photo lineup and I need help. I have a contact db which will store data about people as well as a photo. I also have a layout with Global Containers (8 total for the photos I select from the contact db). What I want to do is attach a button to the photo on the contact db that will place the photo in the first Global Container if it is empty. If the first container is Not Empty then the selected photo will be placed in Global Container #2...if #2 is not empty then #3 etc. I have tried to use If Not IsEmpty in the script, but that only can get me to container #2 and then I am stuck. Am …
-
- 3 replies
- 1.2k views
-
-
I have a product database with two tables, "products" and "productCategories". The productCategories table is setup as a portal in my products database. I have a found set in my products database (let's call the found set "Posters"). I want to assign all of the records in the found set to two different productCategories, "Movie Posters" and "Science Fiction". Is there any way that I can do this using the replace command without having to create a looping script to create each related record?
-
- 5 replies
- 1.9k views
-
-
I created a field called "background color" that is conditional. So if a company is a current customer, this field will be solid green. I placed this field behind several other fields so that the entire row is green ( or other color depending on condition ). On the screen, everything is perfect with the color, but when I print to printer or to PDF the this "Background color" field does not print. In otherwords, the background is green on the screen just like I want it but it does not print to printer or PDF like is shown on screen. I also made sure that the color field is not touching any border that may prevent it from printing. I even experimented with reducing its size…
-
- 1 reply
- 2.6k views
-
-
I have a weird problem with a solution I am developing that has a web viewer using a DATA URL field and using OpenLayers Javascript. In some occasions I get a blank web viewer as if the the page was not fully processed but sometimes the web viewer displays the data url correctly. I am not sure if it is a cache problem or an encoding issue. Any ideas? Thank you! Otto Krauth
-
- 17 replies
- 4.3k views
-
-
I've been trying to figure out a solution for this and have gone down this path, although I'm not sure if there's a simpler solution. Essentially, I'm creating a job application. There are radial selections for "Have you been convicted of a Felony?" and "Are you related to anyone who works for the company?" These are Yes/No fields and are stored in the APPLICATION table. The problem is that I want to "pop-up" explanation fields only in cases where the answer is yes. For the felony explanation field, that is easy - I have a one line portal that hides itself when the answer is no and it has one field from the APPLICATION table included. The relationship field…
-
-
- 2 replies
- 3.1k views
-
-
I have one field with 3 choices: A M, Noon, and P M. When A M is selected I would like the field to be one color, If Noon is selected, then a different color; P M would be a 3rd color. Is this possible? Any ideas will be appreciated.
-
- 6 replies
- 1.5k views
-
-
Is it normal that when I draw a line, it is not fully straight? Check the selected line in the following printscreen. It doesn't align well with the end of the two gray rectangles. That makes the printing not really professional. Is there a way to fix this problem?
-
- 7 replies
- 1.5k views
-
-
Hi everybody, I need some help making a drop-down list in a linguistic database... The idea is that for each sentence that I analyze, I add the root verb (i.e. walk instead of walks or walked) of that sentence, which are stored in another table ("Verbs"). I have created a portal with, among other fields, the foreign key of the "Verbs" table and the field that lists all the root verbs. I want to make a drop-down list of these two related fields, with these properties: 1. if I press on the foreign key field, I want to be able to look up the relevant key, press on it and get the corresponding verb in the other field; 2. if I press on the verb field, I want to b…
-
- 1 reply
- 1.7k views
-
-
I have a layout that has multiple portals (40-50) side by side to display records in a grid format. Is there any way of improving the speed at which this layout displays?
-
- 2 replies
- 1.4k views
-
-
Hi all I'm trying to create a solution where we have multiple tracks hosted on Soundcloud and then host a database of our albums/tracks via IWP and use the web viewer to view to the soundcloud widget. Soundcloud offers an embeddable code similar to youtube videos and other hosting sites, but I'm not sure how to impliment this through IWP. it works great on the client but this site will be used by people across the country. has anyone had success using any embed codes like this with IWP?
-
- 0 replies
- 1.5k views
-
-
Can anyone tell me why i am seeing this anomally in conditional formatting in FMP 11 Adv v 2 on win 7? Looks like ive got the calc and relation right but conditional formatting is only affecting 3 related records when i would expect that 7 are affected. See attachment. TIA Kris CondFormatting.zip
-
- 3 replies
- 1.7k views
-
-
Hi everyone, I have created a portal in the HouseHold layout to contain the household's cultural information (Asian, American etc) This info comes from each baby's record. Since each baby record contains cultural information, household with more than one kid would have duplicate cultural information (each sibling would have the same cultural info) So in my portal, the same cultural info would show up twice or more depending on the siblings' number. Is there a way to get rid of the duplicates in the portal? Is scriping the only way? I have a feeling that there should be a better way to develop this portal. Please advice. Thank you!
-
- 12 replies
- 2.8k views
-
-
Hi everyone, I need to "force" the users to choose input options from drop-down calendars or lists. How can I do that? I know there is a validation tag in the field property set-up dialog where I can do some settings in the "require" section, but that is not exactly what I want.. I just wonder if there is a way for me to disable the free text input by the users. Please advice. Thank you!
-
- 4 replies
- 2.7k views
-
-
Hi, apologies in advance, I am at the bottom of the learning curve. I thought that I'd done reasonably well but then encountered a bit of an obstacle. Any pointers appreciated! I have created a database from a starter solution (contact management) for a small series of events that I am developing. I need to create something like a value list with a range of tags (for want of a better phrase) that I can apply to individuals in my database. I might need to apply one tag to one person and five to another. What is best practice to be able to do this? I realise that when indexed it is likely that I will only be able to search on one tag at one time. Than…
-
- 9 replies
- 2k views
-
-
I'm running a database where I've created a script that loops through a series of product web pages to check product availability - use the "get content" from the Web Viewer, and then parse the text to establish a base field, then set a mirror field with that information - so the next time the system navigates to that page, it can compare the two fields and trigger an alert of something has changed. All that works fine. However, with one vendor (Victoria's Secret), the amount of system memory used triples over other vendors (like Abercrombie or Hollister). I've noticed their web pages are very "java intensive" and am wondering if that could be causing the huge memor…
-
- 4 replies
- 1.8k views
-
-
Hi.. b4 i wander in the wrong direction.. thought i ask something I can't find answer to/// TIA I am currently using current time and time to timestamp our messages/// Now we have a client account in another Time Zone.. Thought I add a Account field acc_timezone It be + or - number from our current timezone, that the operator is working at taking a message. Trying to figure how to timestamp Client message with their own timezone? If not isEmpty(acc_timezone) [color:blue]How might I calculate +/- from current date/ time? else */ default use system time to mark message Endif
-
- 5 replies
- 1.8k views
-
-
ok, here's a simple question, I think. I want to highlight (fill color of light yellow) the active field. Is there an easy way to do this?
-
- 1 reply
- 1.6k views
-
-
Not sure if there's an easy solution to this, maybe I'm being dumb again! In Browse mode, users select from a drop down list which stores the ContactID number of related contacts. A lookup field displays the select Contact's full name. In Find mode when the user searches for a contact by using that value list, the Lookup isn't performed as in Browse mode, so the user thinks that they haven't selected a contact to search for...any elegant solutions to this one please?
-
- 2 replies
- 1.9k views
-
-
We are trying to create a dynamic Value List that filters the results in real time as the user enters data into the destination field. We are also trying to format the value list in a unique way in which all sub-categories are indented just below the main category. We would also like the Value List to display a separate column containing an additional value. I have created a quick screencast that shows the QuickBooks functionality that we are trying to achieve in FileMaker 11. Is this possible? If not, is there a plug-in for FileMaker that would allow us to do this? Thanks. View ScreenCast Movie
-
- 3 replies
- 1.6k views
-
-
Hi everyone, I have a quick question to ask - in portals, can we still keep the drop down menus and such there? Seems to me that portals are just extracting the data from related tables, and it does not keep the data input format. I would like to have users use drop down menus in the portal when they enter new data in the future. Please let me know. Thanks a lot! :
-
- 2 replies
- 1.3k views
-
-
On the Window's side. All of a sudden. I can't see the entered text in a field until you leave the field. Also, this is some kind of window issue. I have a script that open another window. When you choose something on that new window, the new window closes. All of a sudden the first window loses it's graphics and other highlights. It does this until something makes the layout refresh and going to another layout and coming back to it. This is Filemaker 11 advance on XP. This just started the other day. The file works fine on OSX. Nothing's changed on the Windows side.
-
- 9 replies
- 1.8k views
-
-
I am trying to create a value list that will return the placement that the record currently occupies in the current found set. On the surface this sounds very easy; just use get(RecordNumber). The problem that I am running into is that the records I am trying to count are first created in an unrelated table, and then imported into the table that the value list is part of. The reason for this is that the record represents a list of choices presented to the user to choose from a master list of examples, and then once the user has selected from this list, is then imported into the related table where I want the value list to count. My solution to this problem was to …
-
- 5 replies
- 1.9k views
-
-
I received a file where the fields in layout mode display a value, not the field name. How is this done?
-
- 1 reply
- 864 views
-
-
Hi All, I have created a solution which includes new tables to store records and along with tables of records imported from Access databases. At least one of the imported databases is not formatted in such a way that I am easily able to perform lookups based upon related match fields. I have included a sample file to illustrate my predicament. Layout "Range1" illustrates the imported database while "Range2" illustrates what I consider to be a more conventional layout. The problem is I have approximately 30,000 records in the imported database that would have to be copied several times and split up to contain one term and rate per record if I am unable to perform look…
-
- 4 replies
- 1.3k views
-
-
Hi everyone, I have a date field in FM Pro defined as the auto-enter field which sets "Date" upon creation. But the output is DD/MM/YYYY which is the same as my PC's system date format. I would like to change it to MM/DD/YYYY instead. Anyone knows how to do so? I couldn't find any options in FM Pro to change the setting/format. Does it have to do with the system setting of my PC? Thanks a lot! :
-
- 10 replies
- 2.4k views
-
-
I have a layout that shows a list view of various open issues... Multiple users keep that screen up during the day. New issues get added to the list a few times a day. The users need to manually click a refresh button to see anything new added. I want to make it auto-refresh... so I installed a timer that would reload every X minutes. The problem is that if a user is doing something in the app when it reloads, it kills what they are doing and forces them back to the refreshed layout. For example, if a user is entering a new issue when this timer kicks on, it pushes back to the layout and the record they were entering is in there as incomplete…
-
- 11 replies
- 2k views
-
-
This is one of those things that might be staring me right in the face but I can't figure out nor can I find any threads here discussing it. By default radio and checkbox selections always show the button/checkbox to the left of the value it represents. Is there a way to align them to the right? I am mimicking some vendor supplied form in a layout and they are right aligned. I can think of a couple ways to hack it but I thought I would see if there's a 'correct' way to do it.
-
- 4 replies
- 1.4k views
-
-
Hello everybody, I was thinking if I can integrate Google maps distance estimation into Filemaker. I know that I can use Web Viewer, but it's going to show me the whole page. I'm interested only in the actual distance between two zip code inputs.Do you think I can use Web Viewer to show me only a portion of google map site ? ( The idea is similar to Web Clip Dashboard on Mac OS) . Thanks
-
- 1 reply
- 2.6k views
-
-
I have a database with two related tables, Processing Systems and Processing Records. My relationship is based off of the processing record status (Complete or Active) and the machine that it is tied to which allows me to determine which system is available. Currently everything is displayed in a nice list with a one row portal view, which works well for an available system view but not for reporting. I need a way to list all records assigned to the system but also show available systems (with a 0 record count). Below is an example: Current Display: (list view with a one row portal) Tower1 John Doe Tower2 Jane Smith Tower3 (Blank - 0 related records) Towe…
-
-
- 4 replies
- 7.2k views
-
-
I have a line item portal on an invoice layout. I have a checkbox on each line that gets checked by the user when that line item needs to be ordered - which works just fine, its just a little repetitive... I would like to have a single checkbox that would automatically check all the line items that are showing in that portal.
-
- 2 replies
- 1.1k views
-
-
Hi all My relationships are shown in the graph attached. When I created a new tax in the ArtworkTax table, my drop-down list that is using a value list determind by field was not updating. I was using value from field (TaxID), using also second field (TaxName) and showing only values from second field (TaxName). I hadn't left any TaxName fields blank. I swapped the value list to only use the 1st field (TaxID), now the drop-down list shows all records in ArtworkTax table. I changed the value list to show also second field; all records now show in the drop-down list. If I switch back to show only second field, only 1 record is shown even though I have three …
-
- 7 replies
- 1.9k views
-
-
Hi all, I have several tables related to each other (tblBabies, tblHouseholds, tblStudies, tblLanguages etc) I also created portals about the babies info in the tblHouseholds. Problems occured when I tried to create new records of households with babies' information in the web version after I published the database. In the developer's end, I set the baby ID to be generated automatically, but it is not doing it in the web end. And the error message "This record cannot be modified in this window because it is already being modified in a different window." popped up when I was trying to input info in the portal. Anybody could explain why? Can I enter info in…
-
- 3 replies
- 1.2k views
-
-
When viewing a layout, the mouse wheel will cycle through records when scrolled... I have a record details layout that pops up to show the details of a record listed in list view. That all works great - but when a user clicks the details button off the list, he gets that record - but if they scroll the mouse wheel, the records cycle up or down. Can this be turned off somehow? With a little thought I guess I could do something like a self relationship and GTRR and only get those relations... but that makes a much more convoluded scheme to just turn off the mouse wheel. any ideas?
-
- 1 reply
- 2.4k views
-
-
Hy: I need to know, it's possible hidden objects, conditionaly. example: if value > 0 show object if value < = 0 hidden object Thanks
-
- 4 replies
- 1.7k views
-
-
I am a self-taught filemaker user who has recently made the move to sharing a database over the internet, and I have only now discovered how important it can be to make speed-conscious choices in how one defines tables and constructs layouts. I have many unstored calculations, and I understand that I can improve speed significantly by having fewer of these. A fair number of these calculations I use specifically in scripts but don't actually ever need to display in layouts. Am I right in thinking that the speed issue isn't really about whether one has a lot of unstored calculations in one's tables but about whether one places them on layouts that get invoked in the co…
-
- 0 replies
- 945 views
-
-
Is there anyway that I can Show the status bar, but not show the Layout drop down menu, or the little buttons that change view ? In my db/app I typically have the the entire Status bar hidden and have the user navigate by buttons in the layout. However when previewing certain reports I would like to show the status bar but don't want the Layout drop down menu visible. Would also like to add.. I'm pretty new to Filemaker although I have over 15 years development experience with MySQL based solutions. These forums have been a great resource. Thanks to everyone who contributes.
-
- 2 replies
- 7.7k views
-
-
Hello everyone... I was asked to add a feature to an existing file. What we have is a table that has appointments and a field called NSO with a unique text value in it. I have created a new table called NSO_Imports. The NSO_Imports table has several fields ID, NSO_PDF_Name, NSO_PDF_Imported (Container), cNSO. In NSO_Imports I import PDF files into a container field and the cNSO number strips calculates on the NSO_PDF_Name field to get a value that matches NSO field in the appointments table. So I can relate on that. On a layout that is based on appointments, I would like to have a print button that will print the layout the way I have it and if i…
-
- 0 replies
- 829 views
-
-
Hi, I have a fairly simple database with 4 tables - > Customers > Contacts > Sites > Survey_Results All of these are related by idCustomer. In order to keep things simple for users I'd like to keep all information on a single layout (Customers). This is simple for Contacts and Sites as I just created a tab control set with each of these two tables in portal form on their own tab. I starts to get complicated (for me at least) for the Survey_Results table. This table contains too much information to show in a portal (short of buying the users a couple of extra monitors to span the information across) so I have used a combination of tab con…
-
- 4 replies
- 1.4k views
-
-
Hi, i will be attaching a BarCode reader to the System i created. How do i make sure that everytime the Barcode scans, on "tab" that it will skip to the correct next field?
-
- 0 replies
- 935 views
-
-
This has tripped me up all day... I have a Clients table which stores all my clients (obviously). Just recently I've added another table for a certain type of client (private instead of a company). The reason I have this separate table is because they need more information stored about them than the companies do. Let's call it Private_Details So I created a separate layout and it works well in only showing the private clients. However, now I want the original Client layout to only show the Companies and exclude those that appear in Private_Details as well. I thought it was going to be a simple matter of using a TO for the Private_Details and creating a rel…
-
- 4 replies
- 1.5k views
-
-
I have tried many things to create grand summaries in a layout having fields from related tables. Only those fields from the table directly associated with the layout will give grand totals. I can do sub-summaries using the same tables and layout, I just cannot get the grand totals. The main table is related to the other two by a date field and a unique company number or company region code. I would like to have the grand total following any of the sub-sammaries I have made. I have tried calculation and summary fields with no success - any ideas?
-
- 3 replies
- 1.2k views
-
-
Hello, I want to create a portal that has a start date field and an end date field which will constrain the portal data. I'm not sure where to start. How does Filemaker handle dates; for example, is 1/1/2001 lesser or greater in value than 12/1/2009? When I enter a date range into the date fields, I want the portal to automatically update, so I imagine that I need to do this with my portal relationship. Can anyone give me some clues on how to start?
-
- 8 replies
- 2.5k views
-
-
Hi, I have a field (jepg #1) that only shows the first 5 lines, and 90% of the time that's plenty of room to users to explain what they need, but there are sometimes that users will use 10 lines. Currently the only way to see the lines is to click on the field to extend it. (see Jpeg #2) I'm trying to see if there's a way to use the conditional formatting to flag the end user that the field has extra lines and he has to click on the field to extend. any ideas how i can do this or if its even duable. Thanks
-
- 8 replies
- 2.5k views
-
-
Okay here goes- We have a field displayed as a checkbox set, the data it displays is the lists of services the customers offers, the description also includes the price. They want to be able to click a checkbox or multiple checkboxes per line item & the description & dollar amount appear on that line. I have a script that takes the items that are checked and puts it together on one line by simply using the substitute function, that substitutes the paragraph mark with a comma. Now I just want it to grab the numbers at the end of the description and put it in the amount field. Example of my list: Shampoo 15.00 Blow dry 10.00 Manicure 15.00 In th…
-
- 2 replies
- 1.6k views
-
-
Hi, and sorry in advance for my bad english. I have recently installed Filemaker 11 and I am having a bit of trouble with a very simple task. I have selected the "People Management" starter solution, that has 3 tables (employee, goals, issues). Below the name of the employee, there are different fields and even below, the goals and issues tables. I just want to create new fields that come below the name of the employee, for example, between "last name" and "office phone". I have entered in "manage database" and created a new field, supposedly inside the "employee" table, but in the end the field comes below everything, and in black font. I would l…
-
- 1 reply
- 952 views
-
-
I cannot get my head around a particular problem but I am sure there is an easy solution. Can someone help or knock up a small database I can download and look at? Here is an example of what I am trying to achieve. 3 fields, 1 spanish, 1 french, 1 english They each have value lists assigned to them containing the numbers written in each language, so the English field would have 'one', 'two' and 'three' as its values, if I select 'one' as the value for the English field I want uno & un to appear in the Spanish and French fields, alternatively if I select an entry in another language I want the corresponding entry in the other language fields to be d…
-
- 6 replies
- 2.3k views
-
-
Hi all, I might look foolish asking question,but i am new to filemaker pro,so here it goes. I have three tables 1.student 2.team 3.semester student and team have a join table : stu_team. with student and team primary keys in it. The stu_team table is connected to the semester table , to keep information about which student was in which team in which semester. this is the relationship graph: relationship graph now i created a layout with the table as semester and it looks like this: layout i want to use this layout such that i should be able to see all the students in the given semester by choosing the team name. …
-
- 9 replies
- 3.3k views
-
-
Not sure if this is possible, I'd like to have two checkboxes for each value. I've attached an example in PDF. The values are just used for display and print purposes. I know I could work around the issue by creating two value lists that are checkboxes, put them next to each other and on the one checkbox item only display the actual checkbox not the text. I hope this makes sense! Thanks in advance. Caroline DatabaseColorblockex.pdf
-
- 4 replies
- 1.4k views
-
-
A field has a button applied to it. The first thing I want the button to do when the user clicks it is to record the name of the field. How can I do this? [color:red]Get ( ActiveFieldName ) or [color:red]Evaluate ( Get ( ActiveFieldName ) ) fail to return any value for me. The field is set to allow entry in browse mode. Many thanks in advance.
-
- 5 replies
- 1.4k views
-
-
This one's giving me a brain hernia so maybe a seasoned FMP vet has an answer for this one... I have a field (with about 30 items in it) set up as a checkbox and I want to give the user full authority to edit the list without using "Allow entry of other items" since the new item--entered using "Other..."--doesn't appear in the list when added. Fine there. The problem at that I want to be able to record the checked list of items somewhere so in case the list is changed they still have their stored, original choice selection(s) that can be used in a report. Example: List items: [ ] apple [x] orange [x] pear [ ] banana If the user decides to r…
-
- 1 reply
- 1.2k views
-
-
I have a calculation field (Buyer's Premium) in the sub-summary of an invoice that adds a Buyer's Premium charge to the invoice based on the 'Total', summary field. I then created a summary field to total the Buyer's Premium. I want the total of the Buyer's Premium show up in a trailing grand summary. A total shows up, but it is incorrect (greatly inflated). What am I doing wrong?
-
- 0 replies
- 852 views
-
-
My FMPA8.5 is having problem recognizing layout theme installed and repeatedly asking me to re-install (which I did). Any idea how to resolve the problem? Please refer to the attachment which I wasn't able to upload earlier. The error message appear when I try to create a new layout. Theme_files_error.zip
-
- 4 replies
- 1.4k views
-
-
I'd like to be able to view a webpage in webviewer and manually download linked files. If I right click on a file, I get a normal dialog box where I can select "download linked file". However, nothing happens when I select it. No download. No prompt of where to save it. Is this an issue with my set up, or is it simply not possible to download files manually from webviewer? Any ideas?
-
- 0 replies
- 1.7k views
-
-
I would like to display several fields in a tabular format where one of the fields contains varying amounts of text. I would like to have the layout diplay all of the text in the text field, wrapping it until all is displayed, and then starting the next record. Something like this: Blah 1 Blah 2 The Text to Display ------ ------- ---------------------- data1,1 data1,2 XXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXX data2,1 data2,2 XXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXX data3,1 data3,2 XXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXX …
-
- 7 replies
- 1.9k views
-
-
If I have a user who does not have permission to view the layouts in a folder. Is there a way to remove the folder from view. The user does not see the layouts inside the folder but does see the folder. The user then wants access to what's in the folder because he/she sees the folder. It would be nice to have the folder not visible if the contents are not accessible to the user. Thanks
-
- 4 replies
- 1.3k views
-
-
So there may be a very simple fix to this question, but I seem to be overlooking something. As you can see below, I have a very simple report. It consists of a leading grand summary with title and date range. Its main contents are a sub summary that takes all the records in a found set and catagorizes those records based on any promotions that were given. It also has a trailing grand summary that totals all of the record amounts for loads, yards and promotions given. The last column represents a ratio of promotial $'s given per yard. The question I have is in regards to the final column. The field SumPromo.Yrd is a calculation the devides SumPromoAmt by SumQty. T…
-
- 2 replies
- 1.4k views
-
-
I'm a newbie so please forgive this question. I have looked through all the threads on this but so far haven't found something that works. I have a field with a drop-down menu which I want to use to show/hide fields let's say the field is called select_tab with drop-down selections of A, B, C, D. In my tabs I have tabs A, B, C, D, E respectively. If I understand correctly, tab E (not being on the menu of select_tab) is to be used as the default tab and left with no contents. Tabs A, B ,C, D all have some fields which I want to display ONLY if the corresponding letter is selected in select_tab Having messed around with all the scripts I've fo…
-
- 3 replies
- 3.4k views
-
-
Hi, I am trying to copy a .GIF image that has loaded in the Web Viewer and paste it into a container to store it for use later. It is an image that is dynamic so I need to store it separately. Have tried GetLayoutObjectAttribute ( "webViewer"; "content" ), but not had any success in pasting or setting the container to the image. Has anyone any ideas, or is this not an available function....? I can right-click / control-click and copy the image, but I want to be able to script this. Many thanks, Crispin
-
- 10 replies
- 5.5k views
-
-
I could swear I've read how to do this, somewhere, before, but now I can't find it. My problem is this: I have a Value List called PeopleNames which uses values from first field "Person::id" and second field "Person::name". "Include all values" and "Show values only from second field" are both selected. Now, in my layout, where I use this value list to select a particular person (which I use for filtering a list of things), I want to also include at the very top of my menu of PeopleNames an "empty" value, or one that says "*ALL*" or something like that. * I don't want to have to create a blank dummy entry in the Person table (with Person::name = "" or Person:…
-
- 0 replies
- 1.8k views
-
-
This could probably go elsewhere, but the Portal is where the problem shows up. Using Version 11, client & server. The Details: - We have multiple Contract Files, each with its own associated Payments File. Leftover archetecture from Version 6. - We have a Payments List Layout, in each Contract File. It has a Portal to the Payments File, Sorted Descending by Payment Date. - Has always worked fine, Version 6 & mostly in 11. Always works for me. - Each Contract File auto launches the Payment File, in a Start Up Script. Payments File is set to "Open/Hidden" (problem ??). The Problem: - At times, the Payments Portal is empty. No Payments show…
-
- 6 replies
- 2.1k views
-
-
I would like to add a drop down list in the header that lists the various fields I want to be able to sort by. Prefer that when the drop down is clicked, it auto sorts... however a dropdown with a SORT button is also ok. I cannot figure out how to accomplish this. I know I need a value list of all the field names I want to sort by... but I am lost from that point on... Does anyone have any examples they can post to me so I can see something like this in action and dissect it?
-
- 1 reply
- 1.9k views
-
-
Hi. I've been trying to come up with the best way to approach this situation: My table has a numeric value, call it "price". The price is a currency value, but the currency in which the items are priced can be variable. I'd like for users to be able to type in a currency value and a number into a field on the layout, for example "$50" or "£30" or "GBP 30" or "USD 50" etc... - and to have that automatically stored as two items: (A) the numeric value (50 or 30 etc) and (: a link to an entry in the Currency table (i.e. the currency-code or some other unique ID in a table of all currencies). So the question is how to parse that user input... Or maybe …
-
- 4 replies
- 1.3k views
-
-
Dear All, I Have an odd inquiry: Is it possible to format the height of a cell according to the amount of information within it? I know that I can adjust the height of rows in a table layout. But if I need more room for some cells and less for others, is there way to automate custom sizes for each. Please see attached image "FMP_inquiry_1" to see what I mean. Is there a way to align information in between cells in a table rows? This alignment depends on the University name, is there a way to automate the placement of other information based on this field? Background information: We are using FMP to consolidate records for all of our gr…
-
- 3 replies
- 1.2k views
-
-
I would like to add a button in a portal to add pictures to a record. I want the button to take the user to a new layout with another portal where multiple pictures can be added for this record. Is there a way I can do this?
-
- 2 replies
- 1.3k views
-
-
GetLayoutObjectAttribute ("webviewer", "content") Does not work for www.pricerunner.co.uk could it be they are blocking it? Any work around?
-
- 9 replies
- 3.6k views
-
-
I have 2 portals on a layout that are displayed across multiple users. These two portals represent the status of a particular item, one portal represents unapproved and the other represented denied. What is the best way to ensure that if a user sitting on the layout is always seeing up-to-date information? I can script a refresh window script to refresh every 5 seconds or so, but that seems a little inefficient. Thoughts?
-
- 0 replies
- 1.2k views
-
-
I've created a layout that contains a header and body. Whenever I go into preview mode the layout always says that there are two pages even though the second page only contains header information. How do I fix this so that if the user prints it only prints the page with the relevant information?
-
- 2 replies
- 1.3k views
-
-
I am trying to view a PDF in the webviewer. I think this used to work, but now I am only getting black boxes where the PDFs should be. The same url works great in Safari. Mac OSX 10.6.3, Safari 5.0, FileMaker 11 Maybe this is a Safari 5 issue? Any body else having problems? Thanks Todd
-
- 2 replies
- 1.9k views
-
-
I would like to control whether an object is showing or hiding. Objects like fields, text objects based on merge fields, portals, etc. What I am trying to accomplish - without building additional developer layouts - is the ability to show or hide information about the file based on Account Name. For example, I have kludge a calculation that will display "developer" helpful information that will display if the User logs in with the Developer Account. Seems to work - but the layout gets extended to the right to display this information because the merge field that displays the data needs to exist. So, in "Developer Mode" this is great. However, in normal Use…
-
- 12 replies
- 4.6k views
- 1 follower
-
-
This seems like the easiest thing in the world to do, but for some reason I am unable to script a sort of a set of related records via a portal row. What I want to do is have a portal that, upon record creation, displays the order that the records are created in. After the user closes the window, any subsequent time that they go into the layout to view the child records I want a script to sort the records contained in a portal by name. For some reason trying to manually sort the records using ctrl+s or by using the Sort Records script step is not working. The only way that I can sort the records is by actually going into layout mode and selecting "Sort Portal Reco…
-
- 3 replies
- 3.5k views
-
-
This should be pretty easy. I'm trying to find a way to always insert the current year into a block of text but am unsure of the text command to use. So the result of, "The current year is @@" returns text of "The current year is 2010"
-
- 2 replies
- 999 views
-
-
I've read many post and can't get it to parse data from all three rowset. I need the row name, characterID, corporationName, and corporationID from each rowset. How do I make it go to the next rowset so I can get the data. This is the first time I've tried to parse. <?xml version="1.0" encoding="UTF-8" ?> - 2010-06-15 19:37:28 - - 2010-06-15 19:39:32 Thanks for any help
-
- 0 replies
- 1.8k views
-
-
Hi, I would like to create a value list based on a calculation so that the list only shows the classes available to an employee based on which classes they are allowed to take. There are fields in the employee info db for each training with Yes or No marked as to whether they need to take the class. My thought was to create a calculation field to display only the classes marked as yes and then make a value list based on that field. I used this calculation for the field: If ( RTK = "Yes" ; "1" ; "" ) &¶ & If ( Waste Handlers = "Yes" ; "2" ; "" ) &¶ & If ( Back = "Yes" ; "3" ; "" ) &¶ & If ( Eye = "Yes" ; "4" ; "" ) However, th…
-
- 2 replies
- 2.2k views
-
-
I wonder if this can be done to avoid the use of validation calculations? I want to find a VL filter that will prevent double bookings of room_names in the same time_slot; ie. once a room_name is chosen for with a time_slot in one record, that room_name no longer appears in the roomVL in other records. Table1:rooms comprises 8 "room_names" Table2:Schedule date room time_slot time_slotsVL use "custom values", 8:00, 9:00, etc. roomVL based on relationship, Table1::Table2, "use values from field" Table1:"room_names". So, for example: the user chooses the time_slot first (from time_slotVL) and then room_name from roomVL .... re…
-
- 2 replies
- 2.1k views
-
-
Hello, I am having some trouble with the syntax in the Web Viewer. I would like to set up a custom web address for the website www.alexa.com where the search bar on Alexa.com is automatically populated with the search name from my data base. This is how the syntax of the alexa URL would look if example was the name of my search term: http://www.alexa.com/search?q=example&r=site_screener&p=big top However, I want the web viewer to populate the search name from my table called Company Names and Field called Name Can anyone provide me with the correct syntax for this. Thank you!
-
- 2 replies
- 1.7k views
-
-
Hi guys I need some advice on performing what I assume is a basic function. I have a dataset of patients with their postcodes(zipcodes). I need to determine how many live at any given postcode and ideally display the count of each given postcode on a graph. I can think of ways using relationship with a given post code as a match field but that would involve creating thousands of relationship. Is there an easy way of doing this? Joseph
-
- 2 replies
- 1.4k views
-
-
Hi all, I have three table :student, team and semester. student and team have a many-to-many relationship and student and semester have a many-to-one relationship.I want a layout that can display all students in a particular team at a particular semester. That is when i choose a semester from a drop down list , i should be able to see all students who are in a given team during that chosen semester. Please help me on this one!! thanks, sunshine3
-
- 0 replies
- 1.1k views
-
-
Why is it that when I insert a portal in a layout sometimes I see a table with all my empty lines and fields and in other times when I insert the portal it just creates the lines as needed. I have changed the view from list to table to forms & I can't figure out the difference
-
- 1 reply
- 1.3k views
-
-
Greetings, I'm trying to beef up my current solution and can't seem to figure a good way to do it. currently I've got a Database hosted on server advanced where people access it through IWP. I have a results layout with a self-join relationship that shows the results of any search in that portal. The user then just clicks on the portal and it takes them to a details page for that record. This works great for searches but when I want the user to see all the records (5000+) it takes such a drain on the server to populate the entire list that it takes for ever and most people will want to view all when they first get in. I'm thinking of having it filter and create p…
-
- 4 replies
- 1.6k views
-
-
I don't know if this belongs here, but there's sth I wanted to know your opinion about. Don't you think a feature similar to HTML frames would be useful - dividing the screen in vertical spaces as well as horizontal ones (we already have those)? For example you'd have the ability to have a left hand portal and in the middle a list view. Now it also comes to my mind that those layout-parts would be nice if they were based upon different tables. Am I asking too much/impossible/unnecessary programming burden from our friends at FM?
-
- 4 replies
- 2.1k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online