0

Dynamik Choice field

Hello

I use the "Dynamic Choice" field, How to sort the display of information alphabetically? in the table everything is alphabetically, in "Choise"  sort by time added

Thanks

11 replies

null
    • Fred
    • 3 mths ago
    • Reported - view

    in the code for the dynamic choice field add order by fieldname

    select tablename order by fieldname
    
      • iliper LTD
      • iliper_LTD
      • 3 mths ago
      • Reported - view

       good morning

      in which field will they add it? it gives an error everywhere)

      • Fred
      • 3 mths ago
      • Reported - view

       In Dynamic Values:

      'GM TABLE'.Tables order by fieldname
      • iliper LTD
      • iliper_LTD
      • 3 mths ago
      • Reported - view

       Thank you, everything works.

      I have one more question. There is a button that makes a record in the table. It is necessary that after the record, this record opens.

      let me := this;
      let myName := item(split(text('Select a Table'), " "), 0);
      let myNumb := item(split(text('Select a Table'), " "), 1);
      let new := (create Tables);
      new.('Hourly Estimation' := me);
      new.(Name := myName);
      new.(Number := myNumb)

      • Fred
      • 3 mths ago
      • Reported - view

      you have to decide between

      openRecord(nid,string)

      and

      popupRecord(nid,string)

      openRecord() takes you to the table then opens the record, so when you close the record you are in the new table.

      popupRecord() just opens the record without taking you to a new table.

      Since you put the new Tables record in a variable and it is in nid form, because create() always returns nid info, you can do:

      openRecord(new)
      or
      popupRecord(new)
      
      • iliper LTD
      • iliper_LTD
      • 3 mths ago
      • Reported - view

       wow, thanks for explaining, I couldn't understand what was happening)

      Thanks

    • pascalp
    • 3 wk ago
    • Reported - view

    Hello,

    I have the same problem. I use the code (select Papers) order by Paper, but the result is as you can see in the image. I've tried (select Papers) order by text(Paper), but nothing changes.

      • Fred
      • 3 wk ago
      • Reported - view

      What kind of field is Paper?

      Can you post a sample DB?

      • pascalp
      • 3 wk ago
      • Reported - view

       I've just realised that the order is by putting words starting with a capital letter first, then those starting with a lower case letter. It's very strange.

      • Ninox partner
      • RoSoft_Steven.1
      • 3 wk ago
      • Reported - view

       can't you use: order by lower(Paper) ?

      • pascalp
      • 3 wk ago
      • Reported - view

      Thank you. It works.

Content aside

  • Status Answered
  • 3 wk agoLast active
  • 11Replies
  • 83Views
  • 4 Following