Jump to content

Delta Tango

Members
  • Posts

    51
  • Joined

  • Last visited

About Delta Tango

  • Birthday 10/08/1986

Delta Tango's Achievements

Contributor

Contributor (5/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

0

Reputation

  1. Wim, Thanks for this post. I was trying to figure out myself how to create a folder using the send event script step, but using a parameter to pass the folder name to be used. The thing is I cannot use GetTempFolder function because the users don't have access to create files on our server anywhere else but a specific directory, hence the need for this. So I wanted to create a script that would create a folder for that user within that folder where they do have access privileges. Example: ServerNameWorkFilesTemp Is the folder where they can create files. I wanted to create a send event script step that creates a folder within that location for that user to generate his files for the session. So I wrote this calc for the send event step using your given example: "cmd /c mkdir ServerNameWorkFilesTemp" & Get(AccountName) Would this be the correct syntax? It worked the first time but the second time it crashed filemaker. By the way, what does the /c do? Thanks!
  2. Here's one that I use. I got this from a Filemaker Book. The field is a text field with auto-calc, replace existing contents. the name of the field is Record History. This is it's function: ************** Evaluate ( Quote ( Get ( CurrentTimeStamp ) & " | " & Get ( AccountName ) & " | " & Get ( ActiveFieldName ) & " | " & Get ( ActiveFieldContents ) & " | " & "¶" & Record History ) ; [here you put the fields that you want to trigger the script, separated by a semi colon] )
  3. You can use the Filter function to test if it returns the word. Check the manual on the filter function.
  4. Has anyone else had the experience of fields and items you put into a tab showing fine in layout mode, but when you go to browse mode, the items are on all tabs or scattered and mushed about the tab space? I've spent like 20 minutes trying to fix it but no matter where I place it in the tab, it show on every layout. Thanks
  5. I think if you go to the login page and see where the form redirects to, you can then push your username and password using the POST plugins for filemaker. Go to the plug-ins page at filemaker.com and look up POST. I think the company that makes it is called 360works.
  6. you would have to set up a privilege set that stated that. Records can be modified in that table when, and then the condition.
  7. Hey Everyone, I am creating a database that has 4 tables: customers orders orderitems catalog_items A customer will log into this site and ONLY the catalog items that have been applied to that customer's account can be listed. In other words, let's say there are 400 catalog_items but that customer only can sell 90 of them, that is all that will appear. I am debating what is the best way to do this. I could create a table called allowed_items that is the same as catalog_items but with an extra field that says who this is approved for, but that table will be huge, and there will be duplicates (if 5 customers sell the same product there will be 5 records). The other solution I came up with is to create a blob field in the customers table called allowed_items that just put a table or comma delineated list of all the items. I could also create a blob field in the catalog_items and list the users who are allowed. Does this seem reasonable? Suggestions are appreciated. Dave
  8. As far as I know, this is specially printed paper that does this. It is not something a regular printer can print.
  9. Let( [ startDate = yourfield; EndDate = your2ndField; Difference = startDate - EndDate ]; If( DayName(startDate) = "Thursday" and DayName(EndDate) = "Monday"; 1; Difference ) )
  10. Hi, This is just a matter of using if/else if script steps - You can use account name or privilege set, etc. If[Get(AccountName) = "joe"] GoToLayout "layout1" ElseIf[Get(AccountName) = "mary"] GoToLayout "layout2" EndIf Etc. You would then go to file, file options, and run the script at start up.
  11. You could write a conditional lookup using the lookup function. For example: If( Your Condition; Lookup ( lookupField ; "none" ); Lookup ( lookupField2 ; "none" ); )
  12. Bruce, thanks for the response. i am on a mac osX latest update (10.4.10). I am using the odbc administrator and the latest mysql odbc driver.
  13. when you say trigger the submit do you mean through a script or something? that is not possible that i know of. if you just mean so that the user can interact with the web viewer, there is an option for that if you double click the web viewer in layout mode, you can set this.
  14. your question is a little unclear. what exactly is the part you need help with?
  15. You are on the right track with Get(ActiveFieldName). Try using the evaluate function. You can add a parameter for fields that will trigger the calculation. So for example: Evaluate( If( myTriggerField > 5; 1; 0; ) ; MyTriggerField ) I don't know if this will work but it should. I know that if the trigger field is a calculation and not a regular field, it might not work. Let me know.
×
×
  • Create New...

Important Information

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