This topic is locked
[SOLVED]

 How can I add an unbound text field in the designer?

7/10/2020 11:20:23 PM
PHPRunner General questions
Myr0n author

I am looking for How can I add an unbound text field, close to the Save All & Cancel button.

The reason is that this unbound text field is to enter a pH number and later calculate the rest of rows that are showing in a grid, this unbound text field value it's necessary to save it in a table in the db if is in a valid range, if not will be discard.

The grid that I mentioned above, does not have a parent table.

Or is there a Plugin that does that?
Thank you.

Sergey Kornilov admin 7/11/2020

The easiest option is to add a dummy calculated field to your SQL query. Then you can display it on any page, use it in events etc.

select ...,

'' as dummy

from mytable
Myr0n author 7/12/2020



The easiest option is to add a dummy calculated field to your SQL query. Then you can display it on any page, use it in events etc.

select ...,

'' as dummy

from mytable



Based in your suggestion, I created a view including the
Select

userId,'' as dummyFieldfrom usersTable

I made a relation between the other table that has the userId

Now I have a parent and a detail.
Thank you so much