# tottijohn

Members

45

## Community Reputation

0 Neutral

• Rank
member
• Birthday 06/24/1973

## Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

1. ## Calculating a text field

How can i not think of such simple solution? Gee thanks!
2. ## Calculating a text field

I have a text field which contains contents like "1A+22B-3C" or something like that. I created another number field so that i can get a sum of the text field, which will be "20" for the above example. How can i go about doing that? I tried using the filter function in the number field; Filter((text field);"0123456789+-*/") but could only narrow it down to "1+22-3"
3. ## Need help for a very simple qn

Yep that is the case, except table B is simply using Restaurant as the ID. This will be a example of my layout for table B. Its list view btw. Header Location A (Rates_A) Location B (Rates_: Location C (Rates_C) -------------------------------------------------- Body (Restaurant) (Rates) The location's rates will be the same in both tables, while the restaurant and it's rates can be added in the table B. The (rates) field in table A is different because i want to be able to keep a record incase the rates changes.
4. ## Need help for a very simple qn

Alright, thanks sd and lee for the reply, i will elaborate more. Btw, i can't seem to find the skill level setting in profile... wierd. Just fyi, i started using FM only 2-3 mths back on a almost daily basis. So probably beginner - novice? Basically in table A, i will be putting in destinations and restaurants with rates to calculate the total cost based on the no. of people. Thus table B will contains the gfield (rates) to be used in A. I can use TableB::(rates) in table A but i do need to keep records of the rates saved and not simply change whenever there is changes in B. Lo
5. ## Need help for a very simple qn

I have two tables, A & B with no relation. How can i make a field from table A to auto lookup a global field from B whenever i make changes? Any solution beside using script? Thanks
6. ## Getting information from related table

Thanks alot comment, finally got everything to work :D
7. ## Getting information from related table

Thats awesome! One more qn though, is it able to do a total of all the selected rates?
8. ## Getting information from related table

Sorry i don't get what you mean, can elaborate abit more?
9. ## Getting information from related table

I have a layout form, A, with several fields like the following; Restaurant Pax Rate Total 1. 2. . . 10. Each field is individual, meaning there is a total of 40 fields for the above example. The (restaurant field) is a dropdown valuelist from the next table, B. This table allows user to input the rate for each restaurant, so that the rate will be automatically fill-in when the user selects the restaurant in form A. For single record, i can simply relate both tables (restaurant field) and use the (rate field)from table B in form A, but for this case, i can't sin

Anyone?
11. ## Qns on global field & timetable

The Ray Cologon's method is really great! Almost flawless for my case. Thanks john

I have a layout whereby amendment/s to the record will create a new record. The old record is stored for reference but not displayed. Currently, when ever a new or amendment record is created, i used a field to display 'new' or 'update' to notify another user. But the downside is that it will still alert the user if the amendment done is not required to know by the other user. Thus, is there a way to alert the user which actual field/s is amended? I am thinking of assigning addition field to each main field but then it will be very messy that way.
13. ## Qns on global field & timetable

Global Field I have a layout, A, using global fields to verify first before saving into the table. There is a 'New' button scripted to clear all gFields so that user can input new entry. There is another layout, B, with similar functions, sharing some gfields too, which the 'new' button script includes. So saying two users are each using one layout. If the 'New' script is performed while layout B is ongoing, will it affects? Have been building the database on a comp, no chance to try it on multiple comps. Need to know this before proceeding. Timetable Which is a good way to
14. ## Calc for validating unique field?

That will be way cool right? Doesn't sound like a complicating function for them to add in anyway.
15. ## Calc for validating unique field?

I checked the 'unique value' under validation tab to prevent user from recreating duplicates, but i believe the error buttons (Revert, Yes, No) that appear when validationg fails are very unuser-friendly. Some of the users are limited to be unable to delete or edit records, only add. I can education them, but accord to murphy's law; "Whatever can go wrong, will go wrong" Thus is there any calc that can be use to mimic this function?
×
×
• Create New...