Create records from dynamic multiple choice
Hi guys,
I hit a bump trying something new:
I have a dynamic multiple choice field called 'Keuze kritieke fases'
I have a subtable 'Kritieke fases'.
I have a button that I gave following code on click:
let xCurrRec := Id;
for i in 'Keuze kritieke fases' do
let j := (create 'Kritieke fases');
j.(Omschrijving := text(i));
j.(Projecten := xCurrRec)
end
So the goal is to have the multiple choice list as an easy way to quickly input a few records (1 record per 'Kritieke fase'), but still be able to tweak the field 'Omschrijving' depending on the case.
Except I'm getting a very strange output... (Image below, I select 3 choices, I get one empty record and one with 3 completely different choices concatenated). Anyone ideas?
-
Joren Brouillard
Maybe these cascading dynamic choice fields could help you Joren :Steven
-
And here's the direct link: https://www.dropbox.com/s/qhrs8f6htf2sctj/Used%20Cars.ninox?dl=0
Steven
-
RoSoft_Steven
I think the difference between yours and mine is that I need the information from a MULTIPLE choice field, and I need to create one record per selected choice. In your example you create one record and populate different fields with different choice fields.
Did I explain that clearly? English is not my mother tongue... :)
-
Joren Brouillard
Ik dacht dat u records wou maken vanuit een dynamic multiple choice field. Dit is exact wat de tabel 'Fill Lines with DMC Fields' doet. Dit is misschien niet uw exacte 'use case' maar kan u wel een idee geven hoe dit kan.
Aarzel zeker niet om mij te contacteren bij verdere vragen.
Steven
-
RoSoft_Steven
Dag Steven,
Foutje van mijn kant, ik had niet door dat de magie in een trigger after update zat.
Hiermee is het gelukt, dit had ik nooit zelf kunnen uitvogelen! Hartelijk dank!
-
Joren Brouillard
-