Dynamic Choice Field reference in a function

Gianluca the main message is, that you (in my opinion) can't pass the dynamic choice field. That means, you have to pass the selection of the dynamic choice. And the selection of the dynamic choice is a number ... it's the id of the selected record. You can get the id of the selected record with 

idOfSelectedElement := number(FieldE)

Inside the function, you have to get the corresponding record to get any data, because you only pass the id and not the real record. I'm not sure if the ids are numbered globally unique, but that doesn't matter. To get the record you have to use the record command. And record needs to know which table is used (<table of selection>)

selectedRecord := record(<table of selection>, idOfSelectedElement);
... do stuff with selectedRecord, which is actually the object you need ...

If not clear, please tell me

Gianluca it's a bit difficult if I don't know have enough knowledge about your structure and the names of your tables, but I try.

First of all, you call the function already with the result of the dynamic choice selection. So in the main script, where you call CF, it should look something like this:

... stuff being done ...
... I don't know if CF returns any value, but let's assume it does ...
... and let's assume, you already have all parameters to pass ...

result := CF(first, second, third, fourth, number(nameOfYourDynamicSelection));

... and the rest ...

And "nameOfYourDynamicSelection" is the name of the field that contains the dynamic selection. Now, the id of the selected record is passed to the function CF.

Inside the function it should now look like this (and I assume, that the dynamic selection is pointing to a table named "tableofselection")

function CF (FieldA: text, FieldB: text, FieldC: date, FieldD: number, FieldE: number) do
    let selectedrecord := record(tableofselection, FieldE);
    CompleteFormula *the actual formula that uses FieldA to FieldD and selectedrecord*;
end

--> You pass the id of the selected record to the function CF. Inside the function, you get the record that contains the data and only then, you can use the content.

Actually, there's a second way to solve the issue (there's always a second way) - maybe it's simpler. You extract the necessary data before calling the function CF. What type of data do you exactly need from the dynamic selection? Is it a number, a string, ...? Then you just define FieldE with that data type. And before calling CF, you extract that data from the requested record. 

If you're still unsure, you have to tell me, what kind of table is used for the dynamic choice and which field you like to use.

Gianluca It's all fine 

However, you're one step ahead of me, when it comes to exporting ... I can't export the database I modified - don't know how ... So I'll copy everything into this answer.

You say the second way works, but forces you to create an extra field. I don't have an extra field, just a temporary variable for the search result. Here's the global function:

function CF(LastName : text,FirstName : text,Sex : number,BirthDate : date,CodiceComune : text) do
    if LastName = null or FirstName = null or Sex = null or CodiceComune = null or BirthDate = null then
        ""
    else
        let xPCog := replace(upper(LastName), " ", "");
        let xConCog := replacex(xPCog, "[AEIOU]", "g", "");
        let xVocCog := replacex(xPCog, "[BCDFGHJKLMNPQRSTVWXYZ]", "g", "");
        let xCog := substr(xConCog + xVocCog + "XXX", 0, 3);
        let xPNom := replace(upper(FirstName), " ", "");
        let xConNom := replacex(xPNom, "[AEIOU]", "g", "");
        let xNom := if length(xConNom) > 3 then
                extractx(xConNom, "^(.).(..)", "$1$2")
            else
                let xVocNom := replacex(xPNom, "[BCDFGHJKLMNPQRSTVWXYZ]", "g", "");
                substr(xConNom + xVocNom + "XXX", 0, 3)
            end;
        let cfparz := xCog + xNom + substring(text(year(BirthDate)), 2, 4) + item("ABCDEHLMPRST", month(BirthDate) - 1) + switch Sex do
            case 1:
                format(day(BirthDate), "00")
            case 2:
                text(day(BirthDate) + 40)
            default:
                ""
            end + CodiceComune;
        let xCarList := "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
        let xParFact := [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9];
        let xDisFact := [1, 0, 5, 7, 9, 13, 15, 17, 19, 21, 2, 4, 18, 20, 11, 3, 6, 8, 12, 14, 16, 10, 22, 25, 24, 23, 1, 0, 5, 7, 9, 13, 15, 17, 19, 21];
        let sumPD := sum(for c in replacex(cfparz, ".(.)?", "g", "$1") do
                    item(xParFact, index(xCarList, c))
                end) + sum(for c in replacex(cfparz, "(.).?", "g", "$1") do
                    item(xDisFact, index(xCarList, c))
                end);
        let finalC := item("ABCDEFGHIJKLMNOPQRSTUVWXYZ", sumPD % 26);
        cfparz + finalC
    end
end

And here's the code for the CF field

let xComune := text(BirthPlace);
CF(LastName, FirstName, number(Sex), BirthDate, first(select Comuni where Comune = xComune).CodiceComune)

Now, if you directly want to enter the BirthPlace into the CF call, that would like like this (change in the parameter list and the Comune-part):

function CF(LastName : text,FirstName : text,Sex : number,BirthDate : date,BirthPlace : text) do
    if LastName = null or FirstName = null or Sex = null or BirthPlace = null or BirthDate = null then
        ""
    else
        let xPCog := replace(upper(LastName), " ", "");
        let xConCog := replacex(xPCog, "[AEIOU]", "g", "");
        let xVocCog := replacex(xPCog, "[BCDFGHJKLMNPQRSTVWXYZ]", "g", "");
        let xCog := substr(xConCog + xVocCog + "XXX", 0, 3);
        let xPNom := replace(upper(FirstName), " ", "");
        let xConNom := replacex(xPNom, "[AEIOU]", "g", "");
        let xNom := if length(xConNom) > 3 then
                extractx(xConNom, "^(.).(..)", "$1$2")
            else
                let xVocNom := replacex(xPNom, "[BCDFGHJKLMNPQRSTVWXYZ]", "g", "");
                substr(xConNom + xVocNom + "XXX", 0, 3)
            end;
        let cfparz := xCog + xNom + substring(text(year(BirthDate)), 2, 4) + item("ABCDEHLMPRST", month(BirthDate) - 1) + switch Sex do
            case 1:
                format(day(BirthDate), "00")
            case 2:
                text(day(BirthDate) + 40)
            default:
                ""
            end + (
                let xComune := text(BirthPlace);
                first(select Comuni where Comune = xComune).CodiceComune
            );
        let xCarList := "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
        let xParFact := [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9];
        let xDisFact := [1, 0, 5, 7, 9, 13, 15, 17, 19, 21, 2, 4, 18, 20, 11, 3, 6, 8, 12, 14, 16, 10, 22, 25, 24, 23, 1, 0, 5, 7, 9, 13, 15, 17, 19, 21];
        let sumPD := sum(for c in replacex(cfparz, ".(.)?", "g", "$1") do
                    item(xParFact, index(xCarList, c))
                end) + sum(for c in replacex(cfparz, "(.).?", "g", "$1") do
                    item(xDisFact, index(xCarList, c))
                end);
        let finalC := item("ABCDEFGHIJKLMNOPQRSTUVWXYZ", sumPD % 26);
        cfparz + finalC
    end
end

And the function call looks like this:

CF(LastName, FirstName, number(Sex), BirthDate, text(BirthPlace))

I tried it and it works:

I think the second way (in this reply) is nicer, because the function call is clean

Gianluca "first" changes a lot. The select command always returns an array of records. In your case, this array always has only one single record. But it still remains an array. By using first (and that's safe, because your array only has one element), you get the record and from that you can get the string (i.e. the field). Otherwise it wouldn't be a single string.

Great that it works.

Gianluca You should add that request to be able to use a keyboard to access a reference field to the Christmas Wish List post. I too wish that was possible.

I would consider Dynamic choice fields sort of a Ninox "soft link" between records. While you can follow the path it is not very direct as a reference field. So it depends if you need the link or not.

Gianluca I think your reasoning for keyboard access to reference field is better.