Trying to understand the Forms
Understanding Forms(or trying to) from the very scratch including what might be obvious.
I always make data lists in a spreadsheet.
1) Columns [ID#, Hospital_Name, Hospital_phone] are "Data Lists"in UNA?
2) and each row is the "Data Item"?
How is ID 1 connected with the other data in that row? Every list seems independent. Or do I have to be sure that every Data List is in the right order?
Would it be an idea to be able to upload a spreadsheet to UNA, which then automatically converts it in to Lists and Items?
It is much faster and easier to apply 2500 units of data to a spreadsheet than it is to apply to UNA. (Maybe SQL?)
-
Your suggestion is a little wrong. The "Hospital list" is the "Data List" and every record from there - "Data item". Via Studio->Forms->Data items you may add the new units where is enough to write a Name of the new hospital. Or you may export your data via MySQL like our countries example.
INSERT INTO `sys_form_pre_values`(`Key`, `Value`, `Order`, `LKey`, `LKey2`) VALUES
('Country', 'AF', 1, '__Afghanistan', '');
So here is: Country - name of your Data list, 'AF' - value, 1 - order id of this item in the list, __Afghanistan - a language key for translation for different languages.
-
Okay thank you very much. See? I was VERY wrong. if I had proceeded I would probably have thrown the laptop out the window in frustration. So you saved me the expensive of a new laptop...
-
Comment by unknown is hidden. -
Just a "Wow" :-) I'm glad that your laptop continues to live :-)
-
Hello Sandeep!
I guess this manual will be useful for you https://github.com/unaio/una/wiki/Browseable-categories
-
Lets say a list of colors.
The first is to create a new list. We call it colors. Then we add 'blue', 'green', 'red'.
Go to "Forms" and select "Data Lists" Choose "Custom Module" in the dropdown.
Then "Make new List". This is the Name of the list column in a spreadsheet. [Colors]
Then select "Data Items"
In the dropdown, select "custom" and you should be able to see your new [Colors]. Select it and start adding each color Red, Green, Blue
Now, how to set it to practical use, is still a mystery to me. The use of lists and tables is of immense importance, but many refrain from doing it, because they are insecure about working with SQL and then make the PhP code to apply the data to the site. so normally people just make a huge pile of pages and add a navigation system. This slows down the site as a whole.
My guess is to use one of the skeleton blocks on pages to lure forward the data, but I actually have no idea and have not been able to make anything work yet.
My suggestion is that someone in the team could make blocks specifically aimed for handling forms data. Show the data from as a list or add data to a list. As it is now, it's as confusing as Pali language. -
Hi Pethol!
If you have a ready Data list then it can be inserted into any new field. During the creation of a new field, you may see the a "Values*" parameter. And there you may see all available lists which can be used there. See little more details here with a small demo: -
Woah! Nice! Thank you!