Jump to content

MutantST

Members
  • Content count

    32
  • Joined

  • Last visited

Community Reputation

0 Neutral

About MutantST

  • Rank
    member

Profile Information

  • Title
    Director
  • Industry
    Photography

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Thank you again my Anonymous helper
  2. Hi All, Thanks for your help on this. I was running into problems with this script as I did not have the Subjectnameglobal on my layout. Now it is there, I am getting the results I require. By the way, does Char ( 9 ) mean? is that the number for a space character?
  3. This is what I am using at the moment and to no avail. Set Variable [ $Bookingid; Value:BookingTable::BookingID ] Go to Layout [ “Subjects” (Subjects) ] Perform Find [ Specified Find Requests: Find Records; Criteria: BookingTable::BookingID: “$Bookingid” ] [ Restore ] Copy All Records/Requests Unsort Records Go to Layout [ original layout ] Paste [ BookingTable::SubjectnamesGlobal ] [ Select ] Set Field [ BookingTable::SubjectnamesGlobal; Substitute ( BookingTable::SubjectnamesGlobal ; Char ( 9 ) ; "," ) ] Copy [ BookingTable::SubjectnamesGlobal ] [ Select ] Paste [ BookingTable::Subjectnames ] [ No style ]
  4. Mmmm, seems like I cannot use the script or function - Substitute ( gTextfield ; Char ( 9 ) ; "," ) in my script.
  5. Thanks for your comment. Unfortunate that the graph looks too small for you, although it looks fine on my screen. Luckily you saw enough information and have been able to comment. Thank you again, as the copy all records/requests works well and I am getting the required info from the tables. I am finding the formatting of the info problematic though as it brings back and pastes all the information in a Tab delimited format. Is there any chance you know how I can retrieve this info without the tabs/spaces included? Records returned as below . . Chelsea Devlin 21 021021021 cdevlin@propertygroup.co.nz Simon E 42 021145554 simon@inspire.nz Admin support
  6. Hi All, Hitting a wall at the moment with performing a find and with those found records, selecting some of the information and then for want of a better word "pasting" that info into another field. My example is: Photo shoot booking has been made. It has numerous related records of the subjects of who will be involved plus their contact details. I am trying to gather the subject name and contact info from this related table and have it available to paste into a secondary program like, word, ical or textedit. Are there any methods that you can suggest that may work?
  7. MutantST

    Portal not showing all the data correctly

    Webko, Thank you very much! Great to have it confirmed that I wasn't doing something wrong as such, but need to do a little research.
  8. MutantST

    Portal not showing all the data correctly

    The third ghost is not the problem, it is the two records are showing the same info above it. They should not have the same info as they are seperate enquiries with different data on those records.
  9. MutantST

    Portal not showing all the data correctly

    Here is the DB file attached. Account: FMFUSER Password: fmforums16 Thanks FMFORUM21-03-16.fmp12.zip
  10. MutantST

    Portal not showing all the data correctly

    If I post the Database to this forum, how long is that online for and how do I stand with intellectual property copyrights etc? I am assuming this will make my database available publicly? If I post the DB to dropbox then at least I still have full control over who sees it.
  11. Hi All, I have created a database and am hitting a wall with one of my portals. A brief structure of my DB is. Customer details (Accounts table) > Their enquiries (Enquiries table) > Send a quote (Quotes table). I require the portal to show 2 quotes from the account using information gathered in the enquiry. Both the quotes are showing up in the list and table view of quotes, but when I try to show them (including the related data) in the portal the duplicate info shows up. I have uploaded a video here and I have attached a relationship portion and the actual relationship. https://dl.dropboxusercontent.com/u/70042807/Simon-PortalHelpVid.mov Thank you for your help. Simon Relationship-EnquiryAndQuote.pdf
  12. Nothing, sorry. I know, how cool would that of been. I did try it first off but for some reason it does not work.
  13. Yeah, that is what I am going for. So it looks like I have to have the file stored internally to remove the remote part. Oh well, suppose I can put up with that. Will this script work if I use a different file type? say a word doc?
×

Important Information

By using this site, you agree to our Terms of Use.