Sinky
-
Posts
25 -
Joined
-
Last visited
Everything posted by Sinky
-
Hey, no need to trouble yourself further with this. The solution you offered works perfect. Thank you once again!
-
You're right, that's my mistake. There should be space after 2nd full stop.
-
Sorry I should have been more specific. The imported text is a transcription of speech via speech-to-text app. Because of this, the very first letter is always capitalized but other first letters of sentences are not. The first character after a full stop is never a punctuation character. However, there are carriage returns. Here is an example of text: Woke up early. did twenty push-ups plus 3 minute plank. skipped lunch. gym after work.
-
Thank you for quick reply. I would make it simple. The first letter after the full stop should be capitalized. There is space between the full stop and first letter. I hope this helps.
-
Hi! I have a question about the capitalization of sentences via calculation. I have a text field to which I usually import certain amount of text (cca. 10 sentences) in the form of sentences but without the capitalization of the first letter in a sentence. Is there a way to capitalize the fist letter of each sentence via calculation? Any help is appreciated!
-
Checkbox value via script issue
Sinky replied to Sinky's topic in Script Workspace and Script Triggers
HI! Tnx so much for your answer. After some testing I went with the first solution you proposed. It's not precisely what I was aiming for but it did open some other possibilities which nicely fit into my plan. BTW... (not related to the current issue)....is there a way FM can recognize hidden status of an object or a field that can be used in a script? Something like IF Object 1 is hidden THEN..... Tnx once again! -
Hi! Hope that someone can shed some light on the following issue: I have two checkboxes from the same table. First one is a text field with Auto-enter calculation which says if Checkbox 2 contains certain value, Checkbox 1 should be empty/unchecked: Case ( Checkbox 2= " EXPELLED"; ""). It works fine. However if I decide to override Auto-enter calculation, meaning having both Checkboxes checked and then uncheck Checkbox 2 making it empty, Checkbox 1 gets also unchecked although Checkbox 2 in fact does not contain value "Expelled" defined in the calculation. What am I missing? Any help is appreciated!
-
The filed was on the Form layout. Well, you're right.... I can't recreate the problem but I don't understand how I managed to solve it. 😑
-
For what is worth, I think I found the source of the problem. Table::Years field was not included in the Table view layout.
-
You're right....so, the field contains one value which is chosen via drop-down list attached to the list Tnx for trying!
-
Yes...it's global field. It's called "years" because it's a dropdown list that contains a list of years.
-
Hi FM people! I have one problem which is probably simple to solve but so far solution eluded me. I have a dropdown text field which offers a list of years (Table::Years). This is global field. I have very simple find script: Enter Find Mode [Pause: Off] Set Field [Table::Order Date; Table::Years] Constrain Found Set [ ] Table::Order Date is a date field. Idea is to perform find according to the value chosen from a dropdown list. However, this does not work. I'm getting "provided find criteria not valid". But, if I enter manually one of the years from the list, It works. Same is valid if I write down a year in the script e.g. Set Field [Table::Order Date; 1980]. Set Field [Table::Order Date; Table::Years] itself works when in browse mode, but in find mode, nope This is I guess a format issue, so I tried several combinations changing fields to text or date but without success. Any help is appreciated
-
Count list of values from Summary list field
Sinky replied to Sinky's topic in Calculation Engine (Define Fields)
Great! Thank you for taking the time to help me and provide some insight. I will look into your instructions and figure the rest out. Respect! -
Count list of values from Summary list field
Sinky replied to Sinky's topic in Calculation Engine (Define Fields)
Charting is one of many aspects of FM with which I don't have much experience. What I'm about to say therefore might not sound reasonable. One reason why I would like to avoid charting by the found set is because I'm trying to build a dashboard with several charts and I would like that these charts are independent from the sort or find changes in a table view. Therefore I opted for delimited data. That being said, your calculation works like magic and provides exactly what I had hoped for. Thank you a million times! 🥳🥳🥳 -
Count list of values from Summary list field
Sinky replied to Sinky's topic in Calculation Engine (Define Fields)
Sure. But I would like to design the charts according to delimited data. So far, the summary list fields and ValueCount ( FilterValues ( MyList ; MyItem ) worked really good. However, now I stumbled on a situation where MyItem is not anymore an item from fixed list of values but an item from the list of values that can be expanded with new values. You probably have a better suggestion. My idea was to look for a way how I can automatically generate a list of sums according to the current state of the value list. Do you think that something like Fast Summaries would be of any use for this? -
Count list of values from Summary list field
Sinky replied to Sinky's topic in Calculation Engine (Define Fields)
Sure. But I would like to design the charts according to delimited data. So far, the summary list fields and ValueCount ( FilterValues ( MyList ; MyItem ) worked really good. However, now I stumbled on a situation where MyItem is not anymore an item from fixed list of values but an item from the list of values that can be expanded with new values. You probably have a better suggestion. My idea was to look for a way how I can automatically generate a list of sums according to the current state of the value list. -
Count list of values from Summary list field
Sinky replied to Sinky's topic in Calculation Engine (Define Fields)
Hi! Thank you for replying so fast! I updated my profile, sorry about that. Yes, you're completely right. The thing is, I was wondering is there another way how to do this by calculation and avoiding the usual procedure. Besides, I would like to have, in the end, the list of sums of each item type so I can use it for charting. -
Hi guys! I hope someone can help me with this. I have a SUMMARY LIST field which contains types of items eg. (shoes, shoes, sneakers, boxers, jumpers, boxers, jackets, shoes, sneakers...). These items are also listed in a value list (boxers, jumpers, shoes, jackets, sneakers) Is there a way how I can generate a count list of items by and in order of the value list? Taken the example above, this count list would look like this (2, 1, 3, 1, 2). The commas here should actually be the carriage return. Tnx a lot!
-
Hi people! I have a field which validation is set to Always, Allow user to override during data entry unchecked, unique value, custom message checked. When validation fails the message box offers two options: revert record and OK. Is there a way to trigger particular script if I choose OK? or is there a way to get the message with only one option (revert record) to choose? Much obliged!
-
Hi! I have a calculation field in a portal which shows the value according to ActivePortalRowNumber. Each row has a special determined value. When I manually enter the value in the field before the calculation field and thereby make a particular row active, my calculation field automatically shows the designated value. Great! But, if when I do the import from Excel, all data gets nicely imported and the portal shows the imported data but the calculation field is without value. I guess the importing process is not making a portal rows active so the calculation is not working. Any ideas how this can be solved? Many thanks!
-
You're completely right. I messed something up. Anyway, I used your suggestion and after some trial-and-error moves I found the solution. So thank you!!!!! I'm using both methods because the script I was working on supposed to be a part of the much larger script so I was simply trying out different things.
-
Hi people! I hope someone can shed some light on the following issue. I made a simple script for button to import the data from .xlsx and update a field. Script works good but I have a problem with the last step. If xlsx contains the data for import, field gets updated and record is not shifted. Fine. However, if the .xlsx has no data to import, FM automatically shifts to the first record. What I would like is that in the latter case record is not shifted or in other words... I press the button, there is no import because there is no new data, current record is not shifted. I tried with Go to Record as the last step but none of the offered options (first, last, previous, next) does the job. I guess I should use calculation option but I'm completely clueless what to put in. Tnx in advance!!!
-
Hi! Thanks for the reply. Yes the page has an API but they charge it a lot so I decided to look for an alternative solution. In the end I found workaround that surprisingly functions but is far from the simple solution I was hoping for. In short: FM exports omitted record as csv, starts the Imacro which fills out the web form using the csv, extracts URL of the resultant image and copies it, FM Paste function pastes URL to particular filed and Insert from URL function takes over the URL and transfers the image into the container field. All this on the click of a button but the procedure is a bit messy and definitely not bulletproof. As far as I could see the Paste function works only if the target field is present on the layout and this I would like to avoid but obviously it is not possible in this case.
-
Hi! I hope someone can shed some light on the following issue. I am looking for the way how I could fill out web form using data from several FM fields, submit the form and copy/paste the resultant image to a container field. While URL of the web page that shows the form is always the same, URL of the resultant image changes every time the image is generated (therefore Insert from URL function is not really applicable or I don't now how to use its full potential) I did some research and found various ways how this could be possibly done: 1. Export fields to CSV and use Imacros or similar macro recorder to finish the job 2. Use various plug-ins like Troi URL plug in 3. Somehow interact with Web viewer inside FM 4. Use API integration However, since I'm truly a rookie when it comes to web integration, I don't really know what to pick or even is there a better way. I would appreciate if I could get some advice on this issue. I'm not really looking for the simplest solution since I'm ready to devote myself and learn how to properly apply the solution, but the most elegant one. In my ideal world, a click of a button and the picture is in the field, would be perfect. Thanks in advance!
-
Hi people! I'm trying to set up multiple conditioned calculated value to a field using Case or If functions but It gets too complicated for my current filemaker skill level. Here's the deal: - I have field SUPPLEMENTATION that should have auto-enter text value based on the calculation which includes other 4 fields ( VITAMINS MORNING; VITAMINS EVENING; MINERALS MORNING; MINERALS EVENING) and multiple conditions - When field VITAMINS MORNING or/and VITAMINS EVENING is not empty, value of field SUPPLEMENTATION is "Swanson" (Condition 1) - When field MINERALS MORNING or/and MINERALS EVENING is not empty, value of field SUPPLEMENTATION is "Now" (Condition 2) This one I managed because conditions exclude one another but from here on it gets complicated because condition 1 and 2 are combined. When field VITAMINS MORNING or/and VITAMINS EVENING is not empty in combination with not empty field MINERALS MORNING or/and MINERALS EVENING, value of field SUPPLEMENTATION is "Swanson and Now" (Condition 3) Final calculation should include all 3 possible conditions. This one is simply beyond my comprehension. Please help!
