LiveCode Forums.

you can
set the dgtext[true] of group "mygridgroup" to myTabAndCRDelimitedList -- true means to use the first line as labels

set the dgtext[false] of group "mygridgroup" to myTabAndCRDelimitedList

. The data will not be edited by the user. Only displayed. For now I was importing the text file in the properties (content) section. It asked if I had headers and I clicked yes.

Haven't messed with datagrids in a while and I swear I can't remember the dg stuff for more than a week.

all the bands that played on monday

JoeZimmerman wrote:thanks for the help everyone. I'm still having issue figuring this out. I did come across the DataGridHelper and was going to give it a try later tonight. Im still having issue though understanding some things.Here is my plan so you can see my train of thought. I've been tryig to build this app for 2 years now. i started in plain xcode and just hit too many hurtles so now im trying livecode. I want this data grid to list the info but also just list some of the items. I know a database would be the best route but i dont want to get that deep into the programming just yet. SO i was going to make different text files and have buttons load the text files into the data grid. So in theory i want to have a buttong for "monday" and it would load all the bands that played on monday into the datagrid, and so on. And if someone clicked on the row it would open a second card that dispalyed all the info for that row not just what the form showed. So thats my program in a nut shell. I could pay someone to do this for me but like i said i've wanted to do this myself and have been trying for 2 years (off and on) and just run into learning walls and this time I just want to get over it finally.

Here is my text file (sort of)
Artist (tab) Day (Tab) Time (tab) Stage (tab) Image(url)

here is what ive tried so far
1. I tried setting up the griD as a table and added the column names in the properties menu and then switched to over to "form" - would that work or will it ignore the column properties I set up once I change it to a form grid?
Just tried it, and no you can't set up your column info and then switch on the fly to form view.

2. I tried setting up the form based off the sample in the Datagrid tutorial: creating-a-list-of-people. I clicked on the load file and imported my text file. It asked me when i imported if the file had headers and I clicked yes.
#######When you set up the form view, did you select the datagrid, then click "row template"?
Then in the window that opens, click the group that is shown there, then click the "edit group" button, then add your fields for the text data as well as an image object for your image, and name each field and image object to match your proposed data?
(fields artist, day, time, stage. image imageurl, and set the image to the size you want it to appear and lock its size and position in the inspector so that it doesn't resize on image load.)
Also make sure to remove the field named "label" that is the default for the template. Or just rename it and use it as one of your fields.
After which, you need to click "edit group" again to leave group edit mode and then close the window that was opened when you clicked "edit row template" initially. You'll be prompted to save, do so.
At this point your template should be set up to receive the data, but you need to adjust the behavior script to actually USE the data.

With the datagrid selected click the row behavior button in the inspector. This will open up the behavior script for your form datagrid.

Find the "fillInData" handler
There is an example already there that shows how to set the text of field label (which doesn't exist anymore) So, you need a line for each item of your data that you want to display (that you created a field for)
set the text of field "fieldname from your row template" of me to pDataArray["the name that appears in the header line of your data"]

For the image I believe you can do

put URL pDataArray["the name of the column header from your text for the image"] into image "the name of the image" of me

You will have to fix a few other things too. The basic script had the field "label" that you will have changed, but there are references to it elsewhere in the script.

You will want to modify the layoutcontrol handler so that the positions of your fields and image are set on the fly as data is populated. So you'll want to change the reference to the label field, and add any changes needed to make your information display correctly.

You'll also want to look at the resetdata handler, it should be pretty obvious what to do there. (again there is an example using the label field, just add lines for each field, and "put empty into image "imagename"" and remove the label field reference.

Once you get it all cleaned up and how you want it to be, compile the script.

########

both of these worked fine if I switched the datagrid back to a "Table" style but I couldnt get the data to populate when i had it set to form.

Ill download the datagridhelper tonight when i get home from work and give that a shot. I really am dying to finally get this app made.

3. I havent even tackled the issue of trying to import the text file because I can't get the form to work. Once I get that hurdle done I'll need to find more examples of how to load the grid from a text file. I see the example in the lessons but I dont understand where the file is actually loaded. For someone not familiar with the code its hard to figure out. I see set the dgText [ pFirstLineContainsHeaders ] of group "Data Grid" to pText but how do I tell pText=MyFilename.txt where Myfilename.txt is my tab delimited text file.

thanks again all I really appreciate all the help

JoeZimmerman wrote:Thanks again Sturgis. I'm going to have to step away and try some more tomorrow. I swear i followed the same steps you posted but i must be missing something as I just cannot get it to work. 1 thing I should mention that maybe causing an issue is I'm not using all the columns I imported when I create the form view. I have stuff in all the columns i mention but when i build the form i only trying to use the (artist)(time)(stage) to keep it simple at this point . does that matter? Im going to try it with a text file that has just those 3 next. I downloaded and tried the datagridhelper demo but the form builder part is locked down so it does me no good at this point.