bavltd

Amazing, thank you. I've managed to understand enough of it to tweak it and get it working!

Hi I'm trying to create a moderation database that can feed a screen in a conference from a twitter rss seach term. I have got the rss feed by using pixsy - http://search.twitter.com/search.rss?q=%5B%23capitalstb%5D I have created what I believe is a valid XSL file to map the elements I need from the feed into a table. My script is Import Records [http://search.twitter.com/search.rss?q=capitalstb; capital_twitter.xsl; Add; Mac Roman] I've tried running the xsl from a local file and from a local http server but still get no entries, so I guess the xsl mapping isn't correct. Can any one help? Thanks Jonathan capital_twitter.xsl.zip

hi sd, I have attached what I have done so far. I am really trying to fix the following two problems. 1. Copy multiple records from a portal into the "clipboard table" so that they can be pasted (re-imported) back 2. Add a subtotal line to the portal which will total all the entries between the current line and a previous subtotal. I think i have everything else working although I would welcome any comments on how I shouldn't have done it! The logic works for my brain but may not be the best. I have used zippscript to update certain fields with calculations. I haven't included the contacts etc referenced by the file either, but it should be ok without.

The "memo" entry is really just another portal record with no amounts in it, just the product description field. I've managed to do the insert row with a script and also the running subtotal using a summary, but am stuck on the copy/paste functionality. Everywhere I have read says that copy/paste from the menu doesn't work, so I though about creating another table to act as a clipboard and use a lookup to insert data from the original table. My problems now are: How do I get the information back into the original portal with the new line numbers - I can't use a lookup in the same way as the fields already have lookups in. Do I have to do lots of setfields? How can I select multiple rows from the portal and copy them as I would in excel? I guess I need to get some way of calculating the end selected portal and creating a loop starting with the first selected portal and running for x times. How do I show multiple selected portal rows to the user?

Hi All, I would like to create a quoting system that is similar to the Quotewerks system available for PC which we currently use - www.quotewerks.com. I have created a database with two tables. One contains details about the customer etc, and the other contains the products related to that quote. They are linked via a QuoteID field. I have created a layout with a portal and all is great however I would like to be able to do the following in the portal: 1. Insert a new "row" in the middle of the existing portal list (like I would in a spreadsheet) 2. Copy and paste rows (copy a row, insert a blank row and then paste the copied row into it) 3. Be able to insert a row that would either show a running subtotal (addition of all the rows from the start to this point) or a subtotal (additon of the rows above this point to the last subtotal line). 4. Be able to insert a "memo" type line which only contains text & no costs. 5. Be able to select which lines get output to the final printed copy. There are some clients we have that we don't itemise costs for. The section in the entry system would start with the memo line and so the print out would just show the memo line and the subtotal for that section. Having looked at the tables in quotewerks (based on access) there is a linetype field which tell the system if the line is an item, subtotal or running total. There is also a line order field which gets updated when the quote is saved to reflect the edits that have been done. Any suggestions how to approach this would be greatfully received. Thanks Jonathan

thanks for your help Mark

Thanks. I will give it a go. Can I create a vb script dynamically from a calculated field and run it or does it have to be external? Can I create it and export to a temp file and run that?

I would like to have a button on a page that will create a folder within a directory on our server for a job database. The structure is as follows: Company Work Drive - Company Folder on Network Drive (there are three companies that use the same server) Clients folder - Name of folder where clients are stored Client Company folder - a Folder for each company Job Folder - Where documents are stored. Created from Job ID & Job name fields In windows the structure would be serverCompany Work DriveClients FolderClient Company FolderJob Folder (serverDataClientsACustomerJob#12) I would like the script to check to see if Client Company folder exists, and if not create it based on the value of that field. I would then it to check to see if the Job folder exists, otherwise I would like it to create the Job Folder within the Client Company Folder. Finally I want it to open the folder. Hopefully that makes it clearer. I have seen this done in an access database using vb script, but don't know how to run vb script in FM. Below is the vb script. The field names are slightly different, but hopefully it is clear. VB Script Private Sub Create_Directory_Click() 'On Error GoTo Err_Create_Directory_Click Dim strclientpath As String Dim strjobpath As String strclientpath = Me![DocLocation] & "" & Me![Company] & "" strjobpath = Me![DocLocation] & "" & Me![Company] & "" & Me![OurCompanyInitials] & " #" & Me![JobID] & " - " & Me![Job Description] & "" If Dir(strclientpath, vbDirectory) > vbNullString And Dir(strjobpath, vbDirectory) > vbNullString Then Exit Sub ElseIf Dir(strclientpath, vbDirectory) > vbNullString Then MkDir strjobpath Exit Sub Else MkDir strclientpath MkDir strjobpath

Hi I've created the following applescript to create folders and open the resulting folder based on field info from two tables "tell application " & QMK & "Finder" & QMK & "¶"& "set clientsfolder to folder "& QMK & Our Company Data::Company Client Folder & QMK & " of folder "& QMK &Our Company Data::Company Folder&QMK& " of disk " & QMK & Our Company Data::Company Drive & QMK & " as string" & "¶"& "if not (exists folder " & QMK & Contacts::Company & QMK & " of folder " &QMK&Our Company Data::Company Client Folder&QMK&" of folder " & QMK&Our Company Data::Company Folder&QMK & " of disk " & QMK & Our Company Data::Company Drive & QMK & ") then " &"¶"& "make new folder at folder clientsfolder with properties {name: " & QMK & Contacts::Company & QMK &"}" & "¶" & "end if" & "¶" & "set jobfolder to folder "& QMK & Contacts::Company &QMK & " of folder "& QMK & Our Company Data::Company Client Folder & QMK & " of folder "& QMK &Our Company Data::Company Folder&QMK& " of disk " & QMK & Our Company Data::Company Drive & QMK & " as string" & "¶"& "if not (exists folder " & QMK & Our Company Data::Company Initials &" #"& Job ID &" - " &Name & QMK & " of folder jobfolder) then " &"¶"& "make new folder at folder jobfolder with properties {name: " & QMK & Our Company Data::Company Initials& " #"& Job ID &" - " &Name &QMK&"}" & "¶" & "end if" & "¶"& "set jobfolder1 to folder "&QMK&Our Company Data::Company Initials&" #"& Job ID &" - " &Name & QMK & " of folder "& QMK & Contacts::Company &QMK & " of folder "& QMK & Our Company Data::Company Client Folder & QMK & " of folder "& QMK &Our Company Data::Company Folder&QMK& " of disk " & QMK & Our Company Data::Company Drive & QMK & " as string" & "¶"& "activate" & "¶"& "make new Finder window to jobfolder1"& "¶"& "end tell" I would like to make a similar version for Windows. Can anyone help as I'm completely lost in the windows world? Thanks Jonathan