Sep 24th, 2011, 11:07 AM (This post was last modified: Sep 24th, 2011, 11:10 AM by croman91.)
Hello,
first thanks for this great tool. I am active on the german translation, already sended, i a few weeks i will translate it 100%!
My problem:
I have a Form called Car, there are some fields about the car like (cunstruction year, name, color, …….)
All Clients can access and view all submissions of Car Form but nothing can change of data.
I already make only one view for the clients.
Now i will integrate some custom functions viewed by all clienst for this car.
Some custom functions for the clients are: ( sended price for the car, make the Car as already readed, delete the car, ….)
To get this custom functions to work my idea is to make a special custom new SQL table like this: See attached FILE!
My problem is not PHP coding or SQL to solve this!
But i would like to use FT2 to get my idea to work. Is it any way to solve this by FT2?
It is important that every Client has a custom VIEW of the one car.
To solve this by making exactly this Views with the Form Tolols VIEWS interface and the two filters function it is in my eyes not possible! If it is...pleas tell e how?
My question is: Is it any way to combine the FT2 VIEW function and the filters to make a custom View for each Client?
I will not code it again, if exist a another way….
The custom functions for the clients i know i must code it. Thats not problem.
I dont know is the right way to use one of the extensions like the Hooks manager or submission pre-parser?
Thanks for any idea! And sorry for my bad english!
Your English is a lot better than my German. I took a German class early in the year before visiting Germany. When I got to Berlin, I forgot pretty much everything besides "danke". *sigh*... I think I need more classes.
So! Very interesting problem! It sounds like you need a module that hasn't been written yet - but it's high on my list: "Form Mapping" (formerly called "Extended Field Mapping") which lets you map data in one form to another. However, I won't be getting to it for at least a month (or possibly two)...
That module will allow you to reference data in one form to other forms, so you can have things like "orders" and "clients", and have a single client map to multiple orders. Or in your case, have a single "car" map to multiple "sales".
But quite honesty, until that module is available, I'm not sure how you can solve it without some custom coding.
Sorry I couldn't be more help... but do pop back in a month or two & I hope to have a working solution available!
Sep 30th, 2011, 7:26 AM (This post was last modified: Sep 30th, 2011, 7:50 AM by croman91.)
Hello Ben, thanks first for the fast reply...
So you were in berlin, that's great. I live in Frankfurt, which is located 600 km from Berlin. You know the city skyline with the only in Europe. Is very nice here.
To solve my problem, write your own module is probably the best solution. A filter can be applied between the two forms is perfect to realize my plan. Form mapping sounds very good. If you're planning to write it soon that would be great, otherwise I start to work. :-D
I translated the German language file to row 750 already. The rest I want to translate in a few days. It's the new language file for the form-tools version 2.1.2! I hope the fact more German users are attracted to.
I hope you manage the new module then in 1 to 2 months to write. If you have something new regarding the module then, write me back then. I could test it and give you feedback.
Please tell me one thing: Which is the best solution to put/place my custom functions on the Form site without hordcoding in the file edit_submission.php or view_submissions.php! I will use only buttons for my custom functions and use the jquery library. I love this library! These buttons i will paste it over the submission or at the right side of a submission. Can i use a extension to solve this. Or is the right way to write a own module for this group of custom function buttons? Otherwise i will hardcode it in the above files to integrate my custom buttons. Thaks for any idea.
Oct 3rd, 2011, 10:31 PM (This post was last modified: Oct 3rd, 2011, 10:31 PM by Ben.)
Hi Croman,
Yeah, Germany was very cool. I do hope to go back at some point - I'd certainly like to visit Frankfurt.
In terms of where you need to put your script, the best way would be to create a module - but that has limitations in terms of where your code could be executed.
Probably the *simplest* way would be to just create your own custom file, then require() it in the view_submissions.php and/or edit_submissions.php. That way, whenever you upgrade, you only need to add back in that one require() line. It's not perfect, but pretty simple.
And very cool about the translation! Thanks so much for your help! But is there any chance you could use our translation script for it? ("Open Translate") This explains how to submit translations. http://translations.formtools.org/help.php
I developed the translation script to allow multiple people to work on the translations simultaneously, each person improving and approving other people's translations. If you just send me the file, I don't know which of the versions should be good or not (plus I have to manually import the data). No worries if not, but if you can, I'd appreciate you using the tool!
I have finally completed the German translation. I also used your script translation, but unfortunately, the Open Translation script is a little buggy. Unfortunately I could not find anywhere how I can upload a file completely! Therefore, I used the contact form and send the file as text. For safety's sake I'll hang the German language file here in this messege.
How does it actually made with the filter between two forms? You'll soon bring out the filters I need so desperately? :-D
Or should I even go to work and try to write the filter?
No, unfortunately there's no way to upload an entire file through Open Translate. I'll have to see about getting your data imported into the script. But it may take me some time to figure out the best approach - and I'm very busy with other work right now.
Quote:How does it actually made with the filter between two forms? You'll soon bring out the filters I need so desperately? :-D Or should I even go to work and try to write the filter?
No, I'm afraid I'm not going to be getting to this any time soon. I am sorry, but there's soooo much other work I have to get done first. So feel free to go ahead and work on a custom solution yourself: I wish you the best of luck!
But is there any chance you could use our translation script for it? ("Open Translate") This explains how to submit translations.
I am sorry, but there's soooo much other work I have to get done first. So feel free to go ahead and work on a custom solution yourself: I wish you the best of luck!