Search options (Page 63 of 101)

Hi Dustin,
It's possible to import data into MVD either directly from Excel or as a CSV saved from Excel.  How easy it is depends on your data structure but it's a one-off set up and after that, you just click a button.
But it might be worth you investigating MVD a bit further - entering data directly into MVD doesn't have to take any longer than Excel (it could just be the familiarity of Excel over something new).
You can actually use MVD rather like Excel with an editable tablegrid (but you wouldn't really be playing to its strengths).  Depending on how you structure your application and how you design your forms, data input can be quick and data validation is relatively easy to set up.
Attached is a dummy project that I knocked up to give you a quick feel for things you can do with MVD.  Just open the .vdb file in MVD and then run it.
I've arbitrarily shown a left hand tablegrid with School Weeks and a right hand tablegrid with Pupils.  Click on rows in either tablegrid to display the relevant information in the middle tablegrid.
I've chosen to enter data by school week no' - to add a record, just click the 'add' button and select from the comboboxes (which are all searchable so, for example, just typing a couple of characters quickly finds the relevant entry).
Hopefully, this gives you some ideas,
Regards,
Derek.

Hi Jean,
Glad to be of help.
You can also do the same thing in a script - for example 
sqlexecute('select firstname||" "||lmiddlename||" "||lastname||" "||email from people where id ='  etc etc) which can avoid lots of 'selects' and then joining fields together.
Of course, if you use this to output to a tablegrid, you then need to loop through the tablegrid, so a calculated field is often simpler.
Derek.

Hi,
The easiest way is to use a calculated field to concatenate the first and last names (see attached)
Derek.

Hi Kristof,
Not sure without seeing the actual project, but can you copy the company information that you need to show to calculated fields and then use the calculated fields in the report?
If not, I think you might have to use reportsql rather than report.
Derek.

Hi Kristof,
If you can attach the project and indicate the newly added field, I can have a look and see if I can spot anything.
Derek.

Hi EHW,
I was hoping someone else would be able to check it out with their configuration.  I'm suspecting that it might be an issue specific to Windows XP.
Thanks for your help,
Derek.

Hi Dmitry,
Please see the attached screenshot.
The white bar between the start and end dates makes the dates unreadable.
I'm using MVD5.5 / WindowsXP
Thanks,
Derek.

Hi Terry,
Is the attached the sort of thing that you mean?
Personally, I think it would be more readable if the highlighted colour extended across the entire selected date range rather than 'whiting it out' but I think that's something that Dmitry would have to review - I remember trying to change it a while ago but had no success.
Derek.

Hi Hedan,
Not sure if I understand your question correctly, but does the attached help at all?
When you display your combobox, you can concatenate a number of fields together (enclose each one in { }). 
So in your example, you can show both the record id and the country.
If you then make the combobox searchable, when you add or edit, you can either enter an ID or value to select the correct record.
Derek.

Hi Agusecc, Dmitry,
An alternative might be to use a calculated field to show the day of the week.  Then the calculated field can be used in your report just like any other data fields.
Please see the attached as a simple example.
Regards,
Derek.

Hi Manix,
If I understand your question corrrectly, putting the 'onchange' event against the calculated field itself won't work because a calculated field, by definition, can only change if the fields involved in its calculation are themselves changed - the 'onchange' event needs to be placed against these fields, not the calculated field. 
Please see attached which uses a small script so you can see the changes to the calculated field real time.
Regards,
Derek.