Create sql to show in a list

Discussion in 'Community' started by gatticlaudio, Aug 9, 2018.

  1. gatticlaudio

    gatticlaudio Claudio

    Level: Community
    Hello, I need help to show a list of records that contain 6 data. Example, payment 1, payment date 1, payment 2, payment date 2, payment 3, payment date 3.
    What I want to do is show them one under the other, that is:
    payment 1 - payment date 1
    payment 2 - payment date 2
    payment 3 - payment date 3

    Any suggestions?

    Thank you very much.
     
  2. Sophist

    Sophist Well-Known Member

    Level: Community
    This is not about creating SQL - it is about the template that you use to display a list.
     
  3. gatticlaudio

    gatticlaudio Claudio

    Level: Community
    With what template can I build that?
     
  4. Sophist

    Sophist Well-Known Member

    Level: Community
    Have you tried the DIV template to see whether it can do what you want with some custom CSS?
     
  5. gatticlaudio

    gatticlaudio Claudio

    Level: Community
    yes. what I want to show in 3 rows, are 3 amounts that I have in the same record ...
     
  6. Sophist

    Sophist Well-Known Member

    Level: Community
    Oh - so you have a single row in the list which has the size fields.

    Then you should create a separate groups for each of the 3 payments and the groups will be displayed in the details or form templates on separate rows.
     
  7. gatticlaudio

    gatticlaudio Claudio

    Level: Community
    When you referred to separate groups, do you mean to build 3 lists, each containing the column that interests me?
     
  8. Sophist

    Sophist Well-Known Member

    Level: Community
    No - inside the list, create 3 new groups - Payment1, etc. and put the elements for each payment into the matching group.

    Then sequence the groups correctly inside the form and you should get them on separate lines the way you want.

    Or you could put them in a single Payments group, and set the group to have 2 columns.
     
  9. troester

    troester Well-Known Member Staff Member

    Level: Standard
    Maybe a bit missleading. It's not done in list settings. Go to Groups, create a new group and select the FORM the group should belong to.
    Then you can select this group in your element settings.
     
  10. Sophist

    Sophist Well-Known Member

    Level: Community
    Sorry - yes it was misleading. ;)
     
  11. gatticlaudio

    gatticlaudio Claudio

    Level: Community
    Good day, I armed the group with 3 elements and in Design - Columns I put 2, also the 3 elements for each line are still visualized.
    It's like groups do not work in the lists.

    Thank you.

    upload_2018-8-14_9-13-7.png
    upload_2018-8-14_9-14-0.png
     
  12. Sophist

    Sophist Well-Known Member

    Level: Community
    You said that they were in the same record - which implied that you wanted them on separate rows when displayed in the Form. Putting the elements in Groups allows you to split elements into rows and specify the number of columns when displayed in a Form.

    But now you are talking about how they are displayed in the List which is a completely different problem.

    I know that English is probably not your first language, but can you please explain clearly what the problem is and I will try again to help.
     
    Last edited: Aug 14, 2018
  13. gatticlaudio

    gatticlaudio Claudio

    Level: Community
    Ok sorry. never talk about Form. What I need is to show in a List, 3 data that are in the same record, but one under the other. Thank you
     
  14. Sophist

    Sophist Well-Known Member

    Level: Community
    Then you need to put them into a repeat group rather than have separate elements for them.
     

Share This Page