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.