203 Posts
9 years ago
4
Topic
Hi, In my previous topic I solve partly my problem.
If you want, you may read the topic:
http://www.seblod.com/community/forums/forms-content-types/in-a-form-is-possible-in-output-to-have-some-fields
Now, I ask all sebloders a further help, this is the question: Is possible copy a field from a select dinamic that I get by a concat fields ?
Example: with concat fields I get a unique field that contain: firm, address, city...... Then, I would like to copy firm in firm1, address in address1, and city in city1... etc..
I need to copy these fields in the form, so I can doing further questions to system through search and type.
Many thanks in advance for reply. Best regards, Louis
If you want, you may read the topic:
http://www.seblod.com/community/forums/forms-content-types/in-a-form-is-possible-in-output-to-have-some-fields
Now, I ask all sebloders a further help, this is the question: Is possible copy a field from a select dinamic that I get by a concat fields ?
Example: with concat fields I get a unique field that contain: firm, address, city...... Then, I would like to copy firm in firm1, address in address1, and city in city1... etc..
I need to copy these fields in the form, so I can doing further questions to system through search and type.
Many thanks in advance for reply. Best regards, Louis
693 Posts
9 years ago
3
Level 1
Hi Louis,
I think you have a couple of options.
If you continue with your current method, you can use the Code Pack, and Add Code Before Store, to parse the address from the select dynamic field and then save into the individual fields. It seems like there is duplication of fields using this method.
As far as the search goes, you should still be able to search terms on the Select Dynamic field.
Another method is to use the Select Dynamic Cascade, instead of concatenating the fields?
The results of the individual storage fields, could be used in the search.
regards,
Randy
I think you have a couple of options.
If you continue with your current method, you can use the Code Pack, and Add Code Before Store, to parse the address from the select dynamic field and then save into the individual fields. It seems like there is duplication of fields using this method.
As far as the search goes, you should still be able to search terms on the Select Dynamic field.
Another method is to use the Select Dynamic Cascade, instead of concatenating the fields?
The results of the individual storage fields, could be used in the search.
regards,
Randy
203 Posts
9 years ago
2
Level 2
Hi Randy, many many thanks for your reply.
I think that the second method is better, but I need further clarification.
In practice, I must use 2 forms, namely:
1) a first form where I create a registry of the institutions:
The form will need to select the province, then select the city and then enter the name and address of the institution. Clearly provinces and cities are already loaded in two separate tables.
2) a second form I have to select the provinces, cities and choose the institution for insert further data. OK.
Now, how do I select the right institution if I do not see the address? Address and istitution name are in different fields in the same file.
Besides, you have to know that there are some istitutions with the same name in the same city.
Therefore, how do I select the institution and simultaneously see the address?
This is a my doubt and my problem because I have 3 tables only: provinces, cities and institutions.
I hope to be clear, if you have any doubt do not hesitate ask me, I look forward to receive your reply.
Best regards, Louis
I think that the second method is better, but I need further clarification.
In practice, I must use 2 forms, namely:
1) a first form where I create a registry of the institutions:
The form will need to select the province, then select the city and then enter the name and address of the institution. Clearly provinces and cities are already loaded in two separate tables.
2) a second form I have to select the provinces, cities and choose the institution for insert further data. OK.
Now, how do I select the right institution if I do not see the address? Address and istitution name are in different fields in the same file.
Besides, you have to know that there are some istitutions with the same name in the same city.
Therefore, how do I select the institution and simultaneously see the address?
This is a my doubt and my problem because I have 3 tables only: provinces, cities and institutions.
I hope to be clear, if you have any doubt do not hesitate ask me, I look forward to receive your reply.
Best regards, Louis
693 Posts
9 years ago
1
Level 3
Hi Louis,
The Select Dynamic Cascade, should do exactly what you want. In your first form you set up the institution with the province, city and address.
In the second form the Select Dynamic Cascade will narrow down the results with each selection. Then the final results will be stored with the second form. Finally, you will be able to use those fields in searches.
Have you had a chance to see the demo for the Dynamic Cascade? I think this is basically what you want, only with 2 more fields - address and institution being the other 2 selection options.
Hope that helps,
Randy
The Select Dynamic Cascade, should do exactly what you want. In your first form you set up the institution with the province, city and address.
In the second form the Select Dynamic Cascade will narrow down the results with each selection. Then the final results will be stored with the second form. Finally, you will be able to use those fields in searches.
Have you had a chance to see the demo for the Dynamic Cascade? I think this is basically what you want, only with 2 more fields - address and institution being the other 2 selection options.
Hope that helps,
Randy
203 Posts
9 years ago
0
Level 4
Hi Randy, today I have already purchased select dynamic cascade. I will inform you ASAP about his use.
I know that if I have any doubt I can count on your best support.
Meantime, you receive my best regards, Louis
I know that if I have any doubt I can count on your best support.
Meantime, you receive my best regards, Louis
