I'm new to Formspider, but its great so far, but the following maybe a show stopper for us...

I have 2 panels side by side based on the same datasource displaying different fields. What I'd like to achive when I scoll records in either panel the other panel scrolls as well... similar to ORacle forms and a stacked/tabbed canvas.... is this possible?

we have a lot of Oracle forms that have this sorta layout and the "people who make decisions" what to keep this layout moving forward

Cheers

asked 07 Jan '15, 04:02

apacheuk's gravatar image

apacheuk
1391225
accept rate: 0%


Hi,

As you mentioned correctly an API to make this work doesn't exist in Formspider just yet. I was wondering though why you think this is necessary if both panels are side by side? Can't these two Grids be merge into one Grid? What do we lose if we merge them?

One other option that I can think of is to do away with scrolling. If the Grids show a certain number of rows and navigation among the rows is done via paging buttons then both grids would always show the same rows but different columns.

And finally, we can add a feature to make this work. We were thinking to add a similar feature for scrolling Panels. That has some use cases. We haven't seen a use case where grids need this feature. So I am curious why you think you can't achieve what you want by just having one grid that shows all the columns you need.

Kind Regards, Yalim

link

answered 07 Jan '15, 04:52

Yalim's gravatar image

Yalim ♦♦
2.8k5
accept rate: 21%

ok, maybe I should explain my use case a little better :)

What have is the following fmb...

a multi row block displaying 10 rows with a scrollbar. that multi row block is split into a normal canvas with the primary key that is based on 4 fields next to it I have a tabbed canvas that has 4 tabs on it, each tab contains columns from the multi row block. when I scroll down through the records the data is correctly synced across the tabs, so that when forms gets the next 10 records the tabs are refreshed with the new 10 reords automatically.

Also when I highlight a new current record the same record is highlighed on the tab pages

I'd add a screenshot but security restrictions at work prevent me from doing that

I'm thinking multi tow block = datasource canvas = panels

link

answered 07 Jan '15, 05:13

apacheuk's gravatar image

apacheuk
1391225
accept rate: 0%

edited 07 Jan '15, 05:17

Ok. So I guess, the reason you are doing this is because there are too many columns to show in one grid. That's fair.

Like I said Formspider lacks the API to scroll other grids when a grid is scrolled but this API certainly can be added.

One alternative solution is to ditch the scrolling and just use paging in the main grid and the other grids. This way, if you go to the next page on the datasource, all grids will show rows from the new page.

If you change the current row on any grid, you should be able to sync the other current rows. That should not be a problem. Formspider has API's for this.

One other alternative is to show column values only from the grid's current row in the tabs. So you'd have your main grid with the PK and 4 fields(or more) and then the tabs would only show data for the current row in a single row block fashion. This way you get back your scroll but this reduces the functionality of the screen so I think this is the least favorable solution.

Kind Regards, Yalim

link

answered 10 Jan '15, 05:21

Yalim's gravatar image

Yalim ♦♦
2.8k5
accept rate: 21%

I'm going to be demo'ing some simple screens today as a starter and I know the question will be asked :/

But just out of interest how quickly could something like the syncing were talking about be added to the formspider API?

link

answered 12 Jan '15, 02:36

apacheuk's gravatar image

apacheuk
1391225
accept rate: 0%

Maybe a stupid question, but in a model-controller-view system like formspider wouldn't ONE datasource on which multiple grids are based upon do exactly that?

  1. Refreshing the datasource certainly will refresh all grids.
  2. changing the "current row" in the datasource will propagate to all grids, or not?

At least ORACLE Forms did that. Items, that have "records-displayed" set to 1 would always show the value of the respective current row of the block (=datasource). Items that have "records-displayed"=10 would show ten rows among them the one which is current-row.

In Formspider a Grid should only be a "View" of the "model". Changing the model should aftec all views based upon it.

There should be only one current (highlighted) row, defined by the datasource.
If the programmer wants a second grid that can scroll independent og the first he can always base it on a second datasource.

btw.: It worksd nicely with textfields: A 10 records grid shows only the first x characters of a 4000 varchar2 column, due to space limitations. A separated, single, text-area below the grid shows all characters of the current rows column. Automatically synched to the current row.

link

answered 12 Jan '15, 03:10

dipr's gravatar image

dipr
1561327
accept rate: 0%

ok... I'll have a play around, maybe I was missing something when I tried it originally.

Like I said I'm new ;)

link

answered 12 Jan '15, 04:24

apacheuk's gravatar image

apacheuk
1391225
accept rate: 0%

little demo went well... thinking we may get the go ahead to purchase for an upcoming project... so I'll probably be asking a few more questions :)

link

answered 15 Jan '15, 04:50

apacheuk's gravatar image

apacheuk
1391225
accept rate: 0%

Hi,

Great to hear that the demo went well. I hope you'll move forward. Please let us know if there is anything we can do to help.

I am not answering your Grid sync questions because it seems like you have resolved them. Basically, the way you described it, is the way it works (or supposed to work anyway :-) ). If you encounter a problem, please let us know.

Kind Regards,

Yalim

(29 Jan '15, 01:26) Yalim ♦♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×85
×64
×7

Asked: 07 Jan '15, 04:02

Seen: 2,247 times

Last updated: 29 Jan '15, 01:26


© Copyright Gerger 2017