Transfer info from old to new filemaker project
- or -
Post a project like this2251
€50(approx. $54)
- Posted:
- Proposals: 2
- Remote
- #1892742
- Completed
Description
Experience Level: Entry
I have a contact system for my repairs in Filemaker Program. Which has all the records(contact name,device,repair details) in one table. I made a new system now and i need to trasfer them in the new system(FM 2018). I made a script to trasfer them but i have a problem with this script. It dublicates the names of the customers and in same customer i will see 2 or 50 times in the contacts table. This problem is made because in the new system (FM2018) i have 3 tables. 1 table for contacts,1 for device and 1 for repair details.
I need someone to make me a script which will check if the customer name is already in database so it dont dublicate it. Also the person that will make this i will suggest it for some projects more in the new FM2018. Because the files are personal info i will send them only to the programmer which make the script.
My script:
Freeze Window
Go to Record/Request/Page [ First ]
Loop
Go to Layout [ original layout ]
Set Variable [ $ΟΝΟΜΑ; Value:FM Lab Experts::t.name ]
Set Variable [ $ΕΠΙΘΕΤΟ; Value:FM Lab Experts::t.last ]
Set Variable [ $ΕΤΑΙΡΙΑ; Value:FM Lab Experts::tetairia ]
Set Variable [ $MODEL; Value:FM Lab Experts::tmodel ]
Set Variable [ $SN; Value:FM Lab Experts::tsn ]
Go to Object [ Object Name: "p_portal" ]
Set Field [ ΠΕΛΑΤΕΣ::ΟΝΟΜΑ; $ΟΝΟΜΑ ]
Set Field [ ΠΕΛΑΤΕΣ::ΕΠΙΘΕΤΟ; $ΕΠΙΘΕΤΟ ]
Go to Object [ Object Name: "s_portal" ]
Set Field [ ΣΥΣΚΕΥΕΣ::ΕΤΑΙΡΙΑ; $ΕΤΑΙΡΙΑ ]
Set Field [ ΣΥΣΚΕΥΕΣ::MODEL; $MODEL ]
Set Field [ ΣΥΣΚΕΥΕΣ::SN; $SN ]
Go to Layout [ original layout ]
Go to Record/Request/Page
[ Next; Exit after last ]
End Loop
I need someone to make me a script which will check if the customer name is already in database so it dont dublicate it. Also the person that will make this i will suggest it for some projects more in the new FM2018. Because the files are personal info i will send them only to the programmer which make the script.
My script:
Freeze Window
Go to Record/Request/Page [ First ]
Loop
Go to Layout [ original layout ]
Set Variable [ $ΟΝΟΜΑ; Value:FM Lab Experts::t.name ]
Set Variable [ $ΕΠΙΘΕΤΟ; Value:FM Lab Experts::t.last ]
Set Variable [ $ΕΤΑΙΡΙΑ; Value:FM Lab Experts::tetairia ]
Set Variable [ $MODEL; Value:FM Lab Experts::tmodel ]
Set Variable [ $SN; Value:FM Lab Experts::tsn ]
Go to Object [ Object Name: "p_portal" ]
Set Field [ ΠΕΛΑΤΕΣ::ΟΝΟΜΑ; $ΟΝΟΜΑ ]
Set Field [ ΠΕΛΑΤΕΣ::ΕΠΙΘΕΤΟ; $ΕΠΙΘΕΤΟ ]
Go to Object [ Object Name: "s_portal" ]
Set Field [ ΣΥΣΚΕΥΕΣ::ΕΤΑΙΡΙΑ; $ΕΤΑΙΡΙΑ ]
Set Field [ ΣΥΣΚΕΥΕΣ::MODEL; $MODEL ]
Set Field [ ΣΥΣΚΕΥΕΣ::SN; $SN ]
Go to Layout [ original layout ]
Go to Record/Request/Page
[ Next; Exit after last ]
End Loop
Thanos G.
80% (2)Projects Completed
2
Freelancers worked with
2
Projects awarded
33%
Last project
18 Sep 2023
Greece
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies