Ask Your Question

In Base, how can controls that do not store data in the database, only for macro evaluation, be created? [closed]

asked 2014-09-25 22:50:43 +0100

Michael J. Evans gravatar image

updated 2016-03-06 21:45:15 +0100

Alex Kemp gravatar image

This is my use case:

I would like to have a custom search form. It would have a dropdown populated by a macro which contains an enumeration of possible result tables, and one to a few three additional inputs (depending on the selection) for Postgres text search, or exact matches on some commonly used list types.

This form must be fully parallel, both among multiple users, multiple sessions from a single user and multiple search queries from a given end user within a single session. There is no need, nor desire, to store /any/ data from that form within the database.

Results would be displayed in a table control beneath the input area. Selecting a result would spawn the type of form for that result, which I haven't yet looked in to but I imagine is both possible and a normal thing (as all fields in said form would need the exact behavior I'm having issues disabling for the search form).

PS: I don't believe it's actually applicable, but the ask question guidelines request some version data: EN 4.3 Base, Windows 7 English.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-06 21:45:29.516123

1 Answer

Sort by » oldest newest most voted

answered 2014-12-03 13:26:02 +0100

PChitnis gravatar image

There is a nice work around described in Base Handbook Chapter 4 Forms page no. 107. Have a single record table with desired number and types of fields in addition to an id auto-increment key field. Link to this from the form with additions disabled. Controls on the form linked to this table can be used to call up macros.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-09-25 22:50:43 +0100

Seen: 172 times

Last updated: Dec 03 '14