Jump to content

Coriolan_66

Members
  • Content count

    45
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Coriolan_66

  • Rank
    member

Profile Information

  • Gender
    Not Telling
  1. Since Bento iis no longer updated, I started my db for my students over with FM Go. Please consider three tables :students:, :subjects:, :aplications: During time, students have several aplications on various subjects, ok? In each application, students updates their address, email and... photo In students main layout I have successfully created a portal with sorted aplications over time. I also have a beautifil big portrait near the name and wish that portrait to display the photo of the most recent aplication available for that student. So :students::portrait is a container with calculated value GetNthRecord (:aplications::aplications_photo;0) I unchecked Auto-Enter/ do not replace existing value of field I also tried to set field as Looked-up value with "copy next higher value". No photo displais so far. Need help.
  2. Coriolan_66

    Protecting fields

    Not clear to me. The script works as if project is "closed", the message will appear, but after I change the value. Could you be more detailed please? Thanks
  3. Coriolan_66

    Protecting fields

    Im running a db on my iPad to tracking students projects. Once a project is "closed", I must protect the evaluation fields. Used an old script called "Lock evaluation_field". If (table_status="closed") Show Custm Dialog ("Sorry, cannot change the evaluation") Else Go to Field (evaluation_field) End If Well, the script lets me to alter the evaluation anyway. It doesnt lock the field. I think this script worked for me in the past for FM 10 Pro, as I pointed it out. Please help me to refine this. Many thanks once more :)
  4. Coriolan_66

    Tagging a record

    Hi comment, thanks for your reply. Have a joint table for tags is a bore and useless thing to work with. I created a file for you or someone make some sense with. Hope you can help on this. Composers.zip
  5. Coriolan_66

    Tagging a record

    Ok, just created the following :Nationalities name ::Composers nationality1 nationality2 Made a X relationship between the two tables Created a portal and filtered as name = nationality1 or name = nationality2 It worked. My question is, if this procedure is praticable for large amount of records, said 500+
  6. Coriolan_66

    Tagging a record

    What I want is to implement a tag system, nationalities is just a start. Checkboxes for 100s of tags is a bore. Suppose I want to assign Johann S. Bach, not only to Germany, but also to Prussia, Dresden, Leiptzig and Weimar, by the time independent States. Cant do that with checkboxes.
  7. Coriolan_66

    Tagging a record

    Ok, I am not thinking in a relational table :Composer to nationality And I dont want a multiple value checkbox field. It would be nice to have ::Composer ComposerID Composer_nationality1 (value from ::Nationality) Composer_nationality2 (value from ::Nationality)
  8. Coriolan_66

    Tagging a record

    Hello everybody, Can't get rid with the following question I created a database for composers ::Composers ::Nationality When adding Beethoven to Composers table, I realised he had two nationalities, German and Austrian. I have no idea how to relate my record to the national table. Please help. Cori
  9. Coriolan_66

    FM 11 charts

    Here goes a bar and a pie chart. I need to costumize the Y values to range 0 - 10. My pie chart doesnt work... test.zip
  10. Coriolan_66

    Please make a chart in here

    Ok. Another questions please: How can I costumize that chart title? I found that bold black font quite heavy...
  11. Coriolan_66

    Please make a chart in here

    Thanks you for the support. You have a wonderfull plugin and the alpha makes a really cool effect.
  12. Coriolan_66

    Please make a chart in here

    Ok, charts working now but I have a problem with the colours, as barChartSetSeriesColor doenst work at all. Test_Chart_3.zip
  13. Coriolan_66

    Please make a chart in here

    Ok, Im getting better, need some retouch with variables as bars wont display. Aid appreciated Test_Chart__2_.zip
  14. Just bought your chart plugin. I just need very simple things like a bar chart to display boys and girls in a classrrom. Can someone make it simple for me to understand? I guess you'll need to create a calculation field in Classes table, something like that Set Variable [ $result = Let( debug = pieChartCreate( "Gender distribution" ) and pieChartSetDataPoint( "boys" ; Class::Class_total boys ) and pieChartSetDataPoint( "girls" ; Class::Class_total girls ); pieChartShowGraphic( 360; 360 ) ) Please make it simple for me to understand, without error messagens and stuff. Thanks Test_Chart.zip
  15. Coriolan_66

    Countif function

    ValueCount( FilterValues( List( relation::Field); "7")) works great for static values (eg. words and strings). I want to count values greather than "7". I tried something like this ValueCount( FilterValues( List( relation::Field); "relation::Field > 7")) However, it returns me "0"
×

Important Information

By using this site, you agree to our Terms of Use.