Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


siroos12 last won the day on January 8

siroos12 had the most liked content!

Community Reputation

13 Good

About siroos12

  • Rank

Profile Information

  • Gender
  • Location

Contact Methods

  • Website URL
  • Skype

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Win 10

Recent Profile Visitors

2,147 profile views
  1. CF to index a TimeStamp List

    Sorry for my misunderstanding. Please try this: Set Variable [ $source; Value:"2018/06/01 9:00 AM" & ¶ & "2018/06/01 9:10 AM" & ¶ & "2018/06/01 9:40 AM" & ¶ & "2018/06/01 9:50 AM" & ¶ & "2018/06/01 10:40 AM" & ¶ & "2018/06/01 10:50 AM" & ¶ & "2018/06/01 11:00 AM" & ¶ & "2018/06/01 11:40 AM" & ¶ & "2018/06/01 11:50 AM" & ¶ & "2018/06/01 12:00 PM" & ¶ & "2018/06/01 12:10 PM" & ¶ & "2018/06/01 12:20 PM" & ¶ & "2018/06/01 12:30 PM" & ¶ & "2018/06/01 12:40 PM" & ¶ & "2018/06/01 12:50 PM" ] Set Variable [ $unit; Value:600 //10 minuets in secounds ] Set Variable [ $counter; Value:1 ] Set Variable [ $index_counter; Value:1 ] Set Variable [ $index; Value:"" ] Set Variable [ $max; Value:ValueCount ( $source ) ] Loop Exit Loop If [ $counter > $max ] If [ $counter ≠ 1 and GetAsTimestamp ( GetValue($source;$counter) ) - GetAsTimestamp ( GetValue($source;$counter-1)) = $unit] Set Variable [ $index_counter; Value:$index_counter+1 ] Else Set Variable [ $index_counter; Value:1 ] End If Set Variable [ $index; Value:GetValue($source;$counter) & "=" & $index_counter ] Set Variable [ $Results; Value:$Results & ¶ & $index ] Set Variable [ $counter; Value:$counter+1 ] End Loop Show Custom Dialog [ Message: $Results; Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ]
  2. Okay, lets see what other folks would suggest. mean while I will think about any other solutions and will let you know if came across any ideas.
  3. Yes, put the filter applied to portal in relationships and then show the appropriate field on the layout. see attached: Sources on report- No portal.fmp12
  4. I think it is easier for us to have a real sample file, Please see attached: Sources on report.fmp12
  5. You can make a relationship between the Sources table and your target table using the fk_RecordId = RecordId. Then you will be able to show related fields from Sources table on a report layout based on your target table.
  6. I would suggest to have one single table called "Sources" to record "sources" of each field. So you may have below fields on that table: - ID - Field name - fk_RecordID - Source - Created by user - Creation Timestamp - etc. Then use script step get(activefieldname) to determine which field is active. This is the field that you want to assign a source to it. By having the name of active field, you can create a new record in the "Sources" table and set the Field name by result of get(activefieldname) and set fk_RecordID to the target record ID from your table. The Source table can be either related to your target tables or not. This way you can save one record per field of any table in this table called "Sources" and have it added to your reports later on. The logic is some how same as audit logging.
  7. This is what @Beverly suggested in another post: Date ( Month ( Agreement Start Date) + Agreement Period ; Day ( Agreement Start Date ); Year ( Agreement Start Date ) ) FileMaker will handle the corrections for leap years and days, too! Here is the link to that post: https://community.filemaker.com/thread/172829
  8. Can you elaborate it a bit more? As far as I understand, you have a date field which is the agreement start date. Then you have a number field which is the agreement period (months). Now you want to calculate the agreement end date ?
  9. CF to index a TimeStamp List

    You would need to sort records based on the time stamp field and run a looping script using the "GetNthRecord" function. Use below calculation to get the time stamp value from previous record : GetNthRecord ( MyTable::TimeStamp ; Get ( RecordNumber ) - 1 ) Set above as a variable, then compare it with time stamp value of current record. If the difference is more than the defined break period, then reset the index and set the index field. Obviously the very first record after sorting based on time stamp would skip the loop as there is no record before it. Hope I was clear enough.
  10. Move characters

    Search for "-" in the filed. This would find all negative numbers no matter if the "-" is in correct place or not. When you got the found set, replace the field content with below calculation: "-" & GetAsNumber ( MyTable:MyField )
  11. Removing Characters Past X

    Use Left() Function: Left( MyTable::MyField ; 21 ) you can use it as a calculation of a new calculation field, pointed to your target field or you can replace the target field content with above calculation.
  12. Insert cursor in first field

    Hi, Use below script step on layout enter script trigger: Go to Field [ YourTable::YourField ] [ Select/perform ]
  13. As NLR suggested, use int () function in a simple script and trigger it on the target field "on save" trigger option. So the script would be like Set field [target table::target field ; int (target table::target field)] Or Set field [target table::target field ; int (Self)]
  14. Hi all, Using BaseElements Plugin, I can send emails with attachments, but, the from parameter seems to be constant and does not change based on value of a filed. Here is the variable I use: BE_SMTP_Send ( Emails::from; Emails::to; Emails::subject; Emails::body ; ""; ""; ""; ""; $AttachmentPath) So whatever I have in "Emails::from" is ignored in the sent email. Any Idea? Regards,
  15. Hi Chris A few years back, I made a solution for a car dealer to scan car VIN number and drivers license before they let cars go out for test driving. There are apps on Apple store which support interacting with FileMaker using url requests. By following online instructions, it would take you s few hours to set it up. Barcode scanners just scan the text of the Barcode, it is up to you to parse them based on different standards. So you might find a way to retrieve the standard of the code for each state and pars their code accordingly. Although it might be a bit slow to open a third party app, scan the code and post it back to fmgo, it is still way faster than typing the information. I would suggest buying ring Barcode scanner which are very tiny and handy and pair them with ipads via Bluetooth (if you can rise budget for it, about 80 bucks each on amazon) Best of luck,

Important Information

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