Search formula fields in another table
Buenos dias, tengo una tabla (Medidas) en la cual tengo 50 campos numericos y 50 campos de formula, en los campos de formula tengo esta formula, si Pos1 >= 0 y Pos1 <= 6000 entonces
styled("REPLACE", "red")
else
if Pos1 >= 6000 and Pos1 <= 6500 entonces
styled("Plan Substitution", "orange")
else
if Pos1 >= 6500 and Pos1 <= 7500 entonces
styled("OK", "green")
else
styled("Measurement Missing", "blue")
end
end
end
dependiendo del valor que le ponga me dara una respuesta como se puede ver en la formula.
Me gustaria que desde una pagina nueva pudiera hacer un llamado a la tabla (Medidas) y que me traiga los campos de formula que estan con el resultado para planificar la Sustitucion es posible. Gracias
Traducido con www.DeepL.com/Translator (versión gratuita)
7 replies
-
Wow, 50 fields and 50 formula fields. That is a lot. May I recommend that you check out this post. Cause searching 50 fields is a big pain the butt.
In short, my first suggestion would be create a subtable of Medidas. Or maybe there is a way with a dashboard that eliminates the need for the Medidas table all together. But I would need to know your DB and your work flow better.
-
Buenos días, adjunto la base de datos. Cada 3 meses leemos los capacitores y los registramos. Mi idea es tener una vista de los que tienen lecturas bajas. Gracias de antemano. -
Take a look at the attached DB.
The big change is the new Readings table and data subtable. There is also the Systems table with the attached subtables as well.
The first thing you see in the Readings table is a dashboard to enter in your data, the first tab. The second tab, Information, has two view elements that show systems that should be SUSTITUIR or Planificar Sustitucion.
The data table stores all of the individual readings for each system and since it is a subtable where all records are linked to the dashboard, you can quickly do searches.
I don't know if you are entering in data for all Systems at one time or doing it one at a time. But this is just to show you how it could be done.
-
The Table is very good, the truth is that it is almost perfect, I use the machine field to be able to relate each measurement with a machine, which would be STS 3, STS 4 and STS 5 and somehow in one view have only the alarms to replace and plan replacement. Regarding my programming level, I have been programming some tables for a year but not this level even though I have some very good jobs -
If you feel like the post has been answered please mark the the post answered.
Content aside
- Status Answered
- 1 mth agoLast active
- 7Replies
- 72Views
-
2
Following