0

Search with Multiple Choice problem

Fred

I use these Formula and work but the problem is I have only 3 items in the table Tipo de Documento and need to use aleatory case number. I try one by one I'm lucky to find the case number, and if I insert another Tipo de Documento have problems.

switch number(Busqueda) do
case 1:
    (select Documentos where 'Tipo Documentos'.Clase = "Plano" and 'Ganado REAL' = null)
case 4:
    (select Documentos where 'Tipo Documentos'.Clase = "Actividad" and 'Ganado REAL' = null)
case 8:
    (select Documentos where 'Tipo Documentos'.Clase = "Documento" and 'Ganado REAL' = null)
end

26 replies

null
    • Fred
    • 2 yrs ago
    • Reported - view

    1) click on the + and type in a name for the view and select form

    2) ctrl+click on the all view and select Delete View

    now you only have 1 view.

    Also dashboards only have 1 record so there is no need for a table view.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 yrs ago
      • Reported - view

      Fred Great 

Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 26Replies
  • 259Views
  • 3 Following