Mike J

That option is greyed out. I would do that, this is why I think it's indexing issues on the SQL side

Hi ALl, I have some experience with SQL syntax and our DBA allows us to import records and not write to the SQL data source. I have a local FMP 12 identical to the SQL source. I can import all records in the first instance easily. However, there is no option when field mapping to only update related records then add new. Is there an SQL where statement or and indexing issue on the SQL side? Thanks Mike

Hi Vaughan The dictation feature on the iPad. I know storing it is easy in a container field. I was wondering if I could get the audio to text function. ON the iPad, if you dictate audio, it writes the text for you. Is that even possible to start the audio from the container field and have the iPad dictation listen to it and write the text. Kinda like Dragon Speak.

Hi all, Just upgraded from 11 and bought an iPad. I thought about using the dictation feature in a solution of mine. Is that even possible. The concept is to record into a container field while on the road. At a later point, review these recordings and have the dictation feature translate them. Any thoughts about how one would implement this? Thanks

Anything > than the screen width (if you want it to be to the far right or the screen height. I put mine 1 pixel 1 pixel 5000 pixel to the right.

Are these test scores over time? Can you expand on the what you are trying to do a little more. What do these numbers mean? How are they related? Why do you have the two numbers in one field?

Try this New calc field; output set to container called: b_Delete button Case ( Isempty (primary key)=1;""; not Isempty (primary key)=1 and delete status field = "delete"; table:icon delete; not Isempty (primary key)=1 and delete status field = "don't delete"; "" ) The first statement allows for this to not be seen if you have any portals with create records active on the relationship. The second/third statement looks at the status you have about whether a record can be deleted or not. In the case of adding a script, If (Isempty (b_delete)=1) Exit script Else Delete the record There are other parameters to consider, but this is the simplest I think. Please feel free to comment anything I may have missed. Thanks [see attached example] Mike Delete_Button_in_Portal.fp7.zip

Thanks Stephen! That is exactly what I was thinking. It was nice to see it in practice before I did some test versions and realized that the method was flawed. Got to love trial and error.

Many thanks for the example. I will take a look. I was leaning this way, just wanted other opinions. I agree the native FMP is not an option here.

Thanks..had a look. Very simple stuff. I was thinking about making the responses more complex though. I was trying to think about different responses to questions, where a response could be a list of predefined response (Example would be a series of respones were mutliple responses apply) and where an answer is binary (yes/no), or where an response are predifined ranges (date range to understand the experience of a particular person). Any ideas on how to mix in the different value lists types for responses. I'm thinking about scripting is based upon a question type (radio box; check box; text etc). Based upon this field, the respondant selects the response and if it is a radio button then only one response is declared in contrast the check box where multiple responses are recorded (in a separate user response table). Tried to attache file, here is an empty file for review Perspective is based upon the system I'm trying to gather data about. The survey is trying to assess what each user wants from a future application. Need to add some contacts and groups and questions. Answers are added and given a sort order from the question layout. Thanks Mike Survey_Clone.fp7.zip

Hi All, I'm trying to think about the development of a survey database. I need to create surveys from different perspectives, Admins to people into the nitty gritty. I tried to search the forum for some intro/samples already posted etc, with little success. Any links to some examples would help in the planning part. Thanks Mike

Thanks. The demo is what I needed. Just a filepath problem. I've never done it before from a script variable. Thanks Mike

Hi All, I want to generate an email that includes a report either as a PDF or an excel file. I want the script to automatically generate the file name. Current date_Text specific to the file (Username etc). However, when I try to use the script step save a PDF or excel, I get an error message. I think it is how I'm trying to save the file. I use a set variable step to set $Filename to generate the name. I just want to set it to the person's desktop (Win/Mac). Help?

Dear All, I'm wondering how you all create new serial numbers. Here is the background. We have a core service provider who require requests. Within the request is a list of histology blocks. A histology block (paraffin wax with tissue in it) can be sectioned like cheese. These sections are put on to slides for us to analyze or manipulate. These slides need the serial number because it tells you how far within the original block you cut into. Right now the button/script, From the histology block line item - GTRR to slides, sort by the serial field, capture the last serial number and add one and create new slide set field with new serial number. Obviously I have the controls and error capture to tell me if this is the first section from this block. If I create many sections in one go, then I just loop and add until my counter is 0. I'm at the point where I may want to duplicate the whole request. I like using the import records (GTRR of previous request slides), import found set back into the original table and apply the new primary request key to them, but then I lose my ability to serialize the slides. I forgot to mention, these slides come from different blocks and each group of blocks belong to a patient. My initial thought is to run through each block in that new request and loop through (exit after last). But some requests can have about 100 line items, each requires 5 new slides. Any thoughts or is this still to complicated and requires further explanation. Thanks Mike

Hi, Can you expand you your question. Is Table A a parent record of information that can also have children record information that is related to Table A. Or is it that you have records in Tables B and C and you would also like Table A to have a duplicate? Structure is the first thing to expand on. If you provide more details about the problem, then people in this forum (very smart minds here!!) can help you work though it.

Hi Comment, Would you mind exanding on the structure you suggested? Test table Results table Analysis Table? How would a results table allow for the programmer to define analysis for different tests? (Table names just a guess towards your structure suggestion?) Thanks Mike

Hi Stephen, That is correct, this is not a flat solution. They would create only one record in a related table. I have restricted editing of the parent because most of the data on the parent is hardly every edited or changed on a monthly basis. The unfortunate problem is the internet connection. Our IT group does not offer 24/7 service. In the event our connection goes down (onsite server issues or ISP lines), the only solution I know is for IT to file dump twice daily to a static IP that I can access. I am not allowed, for security reasons, to access the server rooms. This file dump will allow me to access data from this computer and and provide static data to our users so that they can take it to their work site. I'll look at the link you mentioned. I don't think the flagging records is an option in this case since everyone's static file will update the parent I control before it goes back online. Any other reccomendations would be helpful if others have dealt with a similar problem. Thanks Mike

Hi All, There is a need for our group to have small offline module files that can be with the user while away from our network. So two files: Module File and Parent File I have a subset of tables in the module file that pertains to the off site requirements. When off sight, the user can enter data, but can't created new records. When they return, they need to update the parent file by importing from the module file to the parent file. If the parent file is served on another computer or server, how would I initiate the script for export/import? Export: User is in the parent file, selects the appropriate records for export and initiates it from there. -How would I locate the parent file in a script step? Import: User is in the module file, initiates a button with a script that begins by looking for the parent file. -How would I locate the parent file in a script step? I'm good on all subsequent importing, match fields etc. It's the location part that I'm struggling with. What if the parent file moves to another server. How do I soft code (i guess this is a term)? Thanks for any assistance or links to other relevant topics that addresses this question. Mike

I think you are right!! M

Hi Comment, Thanks for the test script parameter. The reason for not using the native drop down calendar is two fold. It gets back to me letting the user select multiple dates to create an event. Unless there is another way of doing this? It also allows me to have one layout dedicated to this calendar for presentation as a pop up or displayed on the layout so that when you my users want to see the date and upcoming dates it is there. I'll try what you provided to see if it does what I require. Thanks again! Mike

Hi All. Hope the New year is treating you well!!! I would like some advice on how to break this calc down. This repeating field calc is used to display a calendar. I have buttons over top (result gives 40 days) with a script parameter from 1 to 40. What I want to do is select the date in a return delimited fashion into another field. I can't seem to grasp the math/parameters in this calc. Is there anyway you can break it apart for me? Thanks Mike Let( [ dateExtended = Extend( Login_Today ); // Change the field references in the Extend function monthDay1 = Date ( Month( dateExtended ) ; 1 ; Year( dateExtended ) ); day0 = monthDay1 - Mod (monthDay1 ; 7 ) - 1; theDate = day0 + Get ( CalculationRepetitionNumber ); dNum = TextSize ( Day( theDate ); 9 ) ]; //-------------------------------- Case( theDate = Get ( CurrentDate ); TextColor(TextStyleAdd( dNum;Bold );RGB(255;0;0)); Month( theDate ) = Month( dateExtended ); dNum; TextColor( dNum; RGB(200;200;200) ) ) //-------------------------------- )

Same problem with Macs here. Creating and printing PDFs.

Thanks Bruce, I tried this already. Thanks for your input and any other ideas you may have about the topic. Mike

Thanks comment! I will take a look and learn more about XML. I hope I can come back and expand on the question once I have a handle on the process. Mike

Hi John, I take a look at the Pivot Tables. I guess as a developer this is easy, but makes it difficult for the end user that is not computer savvy to understand a pivot table. Thanks for the links though. Mike