juuser
Well-Known Member
Hi,
I have a scenario like this:
Table Categories
elements: category_id, default_revision_time
Table Documents
elements: Categories.category_id, revision_time
If I change the databasejoin element (Categories.category_id) value on form Documents, I would need to update the "revision_time" element to "default_revision_time" from table Categories according to that particular document category.
I could retrieve this value easily with Calc element, but that doesn't allow user to select the value which is different from default.
With element Javascript I'm not capable of retrieving the needed value from Categories table.
Thanks in advance!
Martin
I have a scenario like this:
Table Categories
elements: category_id, default_revision_time
Table Documents
elements: Categories.category_id, revision_time
If I change the databasejoin element (Categories.category_id) value on form Documents, I would need to update the "revision_time" element to "default_revision_time" from table Categories according to that particular document category.
I could retrieve this value easily with Calc element, but that doesn't allow user to select the value which is different from default.
With element Javascript I'm not capable of retrieving the needed value from Categories table.
Thanks in advance!
Martin