measy
Forum Replies Created
-
Hi Kim,
thanks for your reply.
I checked my site: no conflict detected.
I’ll send you my video-recorded test privately (Premium).
Best regards
Hi Kim,
YES it does order by table name, if you click on the column title, BUT it doesn’t by default, and it looses it if you click somewhere else and then back to Designer.
My version is 5.3.17
Thanks.
Hi Peter,
thanks a lot for your reply, and ok, we’ll wait for this feature to come ๐
The longer your list, the higher the appreciaton to your valuable plugIn.
Best regards,
Marco
Hi Kim
thanks for your reply.
Aiming to “zip” the message as possible, I missed to specify UPDATE ONLY CHILD.
As usual, in my business perspective, end users should be able to select Parent records, and update/insert only child records.
Best regards,
M.Hi @sarasotasam,
could you find a solution to your question?
I’ve got a similar issue.
Thanks in advance for any update.
let me explain better: to the best of my understanding of your issue, you already successed in “display your table in front-end”: that’s exactly the content of your column, as stored ๐
good luck with your research, and let us know, in case.
Hi @laudag
I’m not in WPDA support, but it seems you’re trying to read what your form as “encapsulated” in one column.
This is exactly how it’s in your plugIn table, it’s not dependent on WPDA (neither any other data-access pluging).
You should be able to idenfify “tags”, then write your own SQL code to “unzip” these infos in separate columns, finally usaeable as separated values…
Good luck ๐
Hi Peter,
thanks for your reply.
Couple of tentatives run this morning, no result.
Reading carefully your reply, I noted in “The lookup code column that is store in your presence table first“:
store, but I need to insert presence table (new record) data.
Is this the issue?
Hi Kim,
thanks for your reply (yeah, a bit late ๐ ):
the issue is no more opened, views being not usefull for parent/child forms.
This topic canbe closed, but linked to the other one: Parent-Child (view mode)
Best regards,
M.
.
Hi Kim,
thanks for your reply (&demo).. but, sorry, doesn’t help.
Maybe I missed to specify in my previous message: “When you access the page to VIEW”, I ment the child page.
The latter – in my env – re-open the full set of columns in the Parent (in view mode) on top of the Child.
Roughly said, if you’re interested in VIEWING NOT INSERTING details (child data), you don’t need the full parent “recap”, but just a few.
Hope this is clarify my request.
- This reply was modified 3 years, 3 months ago by measy.
Hi @px0507,
forminator under DataAccess forum? ๐
Hi @txeteweb,
I’m not a WPDA team, just an enthusiatic user, (looking fot lookup ideas..).
To the best of my knowledge, (at least in free version)
- Is it possible to show/hide columns depending on other column value? No
- Is it possible to create a radio button, similar to checkbox but excluding other options? No
- Iโve built parent/child related tables. When I create a project and add pages (??), some of this child tables must have a unique row for its parent table. How can I limit inserting rows to a table? Usually, a Parent Child: 1:1 means…one table is enough ๐
- Is it possible to create default text to be inserted when creating a new row in a table? If so, can different users create their own default text? YES, in the table definition (ie, WPDA Designer)
Hi Kim,
thanks for your reply, but unfortunately I doesn’t help that much:
I’m aware of templates/sets but you missed the “View mode” in subject title:
- assume you have fat (meaning lots of mandatory columns) in master Table;
- assume you want to create a Parent Child VIEW ONLY Project-page (Form)
When you access the page to VIEW, the system shows the full set of mandatory columns (you cannot UN-check them in template settings).
In my understanding, templates do not match this requirement (VIEW_MODE, Master with few columns, and Details in Child), being “driven by” table constraints, which is OK, But – at the same time – I’m not allowed to have a VIEW as Parent. Roughly said, theres should be an option to set column visible for template_view_only mode.
This is important to us, for readibility of users.
Best regards,
M.
Hi Peter,
thanks a lot for your suggestion on hyperlink usage (great! ).
I tried to replicateย your idea to my โcasBoxโ case:
- PARENT (VIEW): cashBox_id, balance(coins in the cashbox ๐ ), In (-) ย and Out (+) transactions balances:
CashboxA, Balance=100, Ins=130, Outs=30
CashBoxB, Balance=1000, Ins=3550, Outs=2550
- CHILD: (Table): list of transactions per CasBox_Id (A or B)
making the Balance column an Hyperlink in Premium Data Explorer/Colums Settings
I got a red message โโฆError: contact the Pluging Development teamโ, or similar.
I argue itโs connected to the VIEWs approach, meaning you cannot Design a View in WPDA, but writing an SQL CREATE OR REPLACE VIEW code in WPDA SQL Queries (views are not listed ย in WPDA Designer list), while I was able to try and set the Hyperlink type in the view column Balance, via WPDA Explorer.
Any help more than appreciated.
HI @stuartdareukcom,
to the best of my knowledge, yes you can!
ADVICE: manipulating WP/plugin tables is generally NOT recommendable!
- Use Data Access Explorer
- select Database and choose the right one
- once you found the right table in it, you can create a Table via Table builder
- test it and publish the table in a page via standard WP [/shortcode]
Hope this helps,
regards
- This reply was modified 3 years, 3 months ago by measy.