Jump to content

R2D2

Members
  • Content Count

    171
  • Joined

  • Last visited

Community Reputation

0 Neutral

About R2D2

  • Rank
    member
  • Birthday 04/07/1968

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    High Sierra

Recent Profile Visitors

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

  1. Hello! Our work shifts are (for some historical reasons) made and maintained on Excel. During years the number of employees has expanded a lot and so the number of working slots. It is VERY frustrating to find your own shifts from an Excel sheet. Unfortunately this data in Excel is very unorganized and almost chaotic. Now I have an idea that I could somehow import that data to Filemaker so, that I would not have to manually go thru every cell. The original Excel is a shared document in Google Drive. I can download it locally and modify it freely. So, could it be done combining Filemaker script, maybe Apple script and Excel Visual Basic? I'm not very familiar with Apple script or Visual Basic.
  2. Thank you, Comment! I'm sorry that the screenshots were partially in Finnish. The Positions are in the left column (black), dates at the top and the assigned persons will be there below each day (now there is just codes for the shift planning purposes). The codes will be replaced with names, but person who will use this as a planning tool, wants to build "rotations" and uses codes for this. But I'll try to find the answer from the virtual lists.
  3. Mmmhhh... I don't get it... Now I have 3 tables: Shifts (each separate shift is listed here. Like: Packing, 9am - 5 pm, persons name in a), Personnel (names etc.), Calendar, where the dates are created to the future, and then relations to shifts. In Calendar each position and shift are shown in a separate line in a list view.
  4. Hello! Thank you for your reply! I agree that there is no easy way. Unfortunately this will be an online application, so printing will be just an option for users. That auxiliary table sounds interesting. How could this be done with it? Most of the users will use this via webdirect. Can it adjust row height?
  5. Hi! I still have no idea how to do this. So briefly again: I have every day about 15-30 different working stations in 3 shifts. Usually there is only 1 person working in one station at the time, but sometimes there could be 2 or even more. And sometimes even 10 persons are scheduled to a training day. How could it be possible to show whole weeks schedule if there is a various number of workers in one shift? Any help, please...
  6. Hi! I'm planning a job schedule application. There is about 36 different "work stations" or "positions" each day (the left side in a picture) and the dates are in top (Monday to Sunday) In every shift or position there is usually only one person, but occasionally there can be several in one duty (up to 10). I cannot figure out how this can be shown in a listing. If I reserve extra space for possible extra person to each field, the whole list would become a mile long. I have been thinking of repeating fields but it would not solve this problem. Any ideas?
  7. Ok... Actually it seems that problem was in STAFF::tUserName field because for some reason it was left empty in my data. Comment's test file worked perfectly. And now this resetting works also in my file. I used $$pswd only to test if that was the reason. Now it is changed back to $pswd. Thank you so much for your help!
  8. Right after I commit line: Reset Account Password [ Account Name: STAFF::tUserName; New Password: $pswd ] [ Expire password ]
  9. The exact error message (in Debugger window) is that "Last error: 5". During the script (when not debugging) there is no error signals. E-mailing works, but the account does not reset (i.e. new password does not work, only the old).
  10. Hi! I'm trying to create a script which in case of user has forgotten his/hers password resets the account with a new random password and e-mails it to recipient. Here it goes (Don't mind the dialogues, if you don't speak Finnish : Show Custom Dialog [ Title: "Resetoi salasana?"; Message: "Tämä nollaa käyttäjän unohtuneen salasanan.¶¶Oletko varma, että haluat jatkaa?"; Default Button: “Peruuta”, Commit: “Yes”; Button 2: “Resetoi!”, Commit: “Yes” ] If [ Get ( LastMessageChoice ) = 1 ] Exit Script [ ] End If Set Variable [ $$pswd; Value:Middle("123456789abcdefghijklmnpqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ!?"; Round (Random * 61; 0)+1; 1) & Middle("123456789abcdefghijklmnpqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ!?"; Round(Random * 61; 0)+1; 1) & Middle("123456789abcdefghijklmnpqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ!?"; Round(Random * 61; 0)+1; 1) & Middle("123456789abcdefghijklmnpqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ!?"; Round(Random * 61; 0)+1; 1) & Middle("123456789abcdefghijklmnpqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ!?"; Round(Random * 61; 0)+1; 1) & Middle("123456789abcdefghijklmnpqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ!?"; Round(Random * 61; 0)+1; 1) ] Reset Account Password [ Account Name: STAFF::tUserName; New Password: $$pswd ] [ Expire password ] Send Mail [ Send via SMTP Server; To: STAFF::teMail; Subject: "Salasana resetoitu"; Message: "Salasanasi on nyt resetoitu" & ¶ & ¶& "Uusi salasanasi on: " & $$pswd & ¶ & ¶& "Huomioi, että järjestelmä erottelee pienet ja isot kirjaimet" & ¶ & "Salasana tulee muuttaa ensimmäisellä sisäänkirjautumisella järjestelmään"; Name: "Administrator"; Email Address: "xxxx.yyyy@gmail.com"; Reply-To Address: "xxxx.yyyy@gmail.com"; SMTP Server: CAL:: tgMailServer; Port: CAL::tgMailAccountPortNmbr; Use SSL; Authentication Type: Plain Password; User Name: CAL:: tgMailAccountName; Password: CAL::tgMailAccountPswd ] [ No dialog ] Show Custom Dialog [ Title: "Resetoitu"; Message: "Käyttäjän " & STAFF::cLastFirstName & " salasana on nyt resetoitu.¶ Uusi salasana on: " & $$pswd & ¶ & "Käyttäjän tulee vaihtaa salasana, kun kirjautuu seuraavan kerran järjestelmään."; Default Button: “OK”, Commit: “Yes” ] Commit Records/Requests [ Skip data entry validation; No dialog ] But I keep getting error code 5 (Command is invalid (for example, a Set Field script step does not have a calculation specified)) every time in step "Reset Account" and the account fails to be resetted to new password. I also tried to create a text field where new random password is temporarily stored and then used is Reset accoount step but without success. If I use a "static" new password in that step (for example: "New Password" every time), it works. What is wrong in that script or can I get around this some how? Thanks again in advance!
  11. Eos, Thank you! I appreciate your help! Try to figure out that tomorrow. Propably it is best to build the whole system from a scratch again.
  12. Ok... That makes it a bit clearer. But what is the difference in Schedule between id and id-staff -fields?
  13. And here is my present relationship model. There is (for testing) both correlation and non-correlation relationships. Neither of these work. (I hate to be so stupid... )
  14. Thank you, Eos! I tried your solution and it worked - once. I made a test bed for this and in there it did work. But when I tried to implement it to original file it doesn't. I think that I try to make relationships among wrong files. So, to be sure, could you explain the correlations with names. I assume: CAL --- Calendar DutyWish (DW+DNW) --- Schedule Personnel --- Staff What is "Staff_notScheduled" you mentioned in that relationship?
  15. Hi! Thanks for reply! I'm afraid also that my model will not work. Maybe I'll just combine those two tables (DW and DNW) to one and add one field to distinguish wheter it is DW or DNW wish. I wonder why I did 2 tables at all... Maybe there was some idea then. But thanks!
×
×
  • Create New...

Important Information

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