0

Remove comma from dmc-print layout

I have a dmc-field which filters the 'Name' field from the 'Employees' table. By inserting the dmc-field in the print layout, each "Name" field is divided by a comma. I managed to get each result to go on a new line but I can't get rid of the "," even with replacex. Can someone help me?

Still regarding the "Name" field, I have inserted a table in the print layout and I would like to know if it is possible to view only one of the selected record for each row.
I mean, for the first row only the first selected, for the second row the second selected, and so on. If there is nothing then null
Otherwise creating a table in the print layout from values in a dmc field is impossible. I've currently overlaid the text on a designed table but it's not always aligned.
Thank you

 

4 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    can you post your code?

    or

    You can look at this post for some ideas.

    • thomas.4
    • 1 yr ago
    • Reported - view

    Hi Fred It's a dynamic value so I have in

    Dynamic Value Name:

    "
    " +
    Nome +
    "
    " +
    "" +
    "
    "

     

    and in dynamic value: 

    (select 'Dipendenti Walcher')[Attivo = 1] order by Nome

     

    In the print layout I've selected the dmc-field "Nomi dipendenti Walcher" but to see the values without commas, I have to edit the dynamic value name. I've tried with replacex but it doesn't work and I don't know if there is maybe an option to make a table in print layout or select in the print layout in the first row the first selected value, in the second the second one and so on...

    • Fred
    • 1 yr ago
    • Reported - view

    It looks like you are trying to use dynamic fields in a way that it is was not probably designed to do. The dynamic value name looks like it only controls the display of the records within the Ninox table. I've tried adding carriage returns like you did and noticed no changes in how Ninox displays the dynamic choice field.

    Here is an example of how using a for loop and a dynamic multiple choice field can get different results:

    dMC is a dynamic multiple choice field.

    noJoin is a formula field that does not use the join() command.

    withJoin is a formula field that uses the join() command.

    The noJoin code is:

    let crtn := urlDecode("%0A");
    for loop1 in numbers(dMC) do
        record(Teams,loop1).Name + crtn
    end
    

    The withJoin code is:

    let crtn := urlDecode("%0A");
    let x := for loop1 in numbers(dMC) do
            record(Teams,loop1).Name
        end;
    join(x, crtn)
    

    I'm not sure if this helps at all.

    I do not do any printing so I have not played with the new dynamic print forms, so I can't give any ideas on that end.

    • thomas.4
    • 1 yr ago
    • Reported - view
    Fred said:
    let crtn := urlDecode("%0A");
    let x := for loop1 in numbers(dMC) do
    record(Teams,loop1).Name
    end;
    join(x, crtn)

    HiFred ! I modified for my parameters this formula and it worked perfectly! Thank you!!!! 😉

    I didn't know the join-function 😅

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 4Replies
  • 119Views
  • 2 Following