Set values to null if fields are hidden and not relevant
Hi all, Let's take a radio button R1 with options Yes and No. If you click on Yes, another radio button R2 appears with options A and B. Then you click A. But then you realize that you made a mistake and you wanted to click No on R1. You click on No, R2 disappears because it is relevant only if R1 is Yes and you submit your form. The problem is that R2 still has the value A, which is wrong because A is only valid if R1 is Yes. How would you do to set it to null if this case happens ? I did resolve
Calculating Differences between Records - Limitations?
Hi, I'm trying to understand if ZOHO can handle this. Tanks have daily gauges - in Feet, Inches and Quarter Inches. I'm wanting to calculate the differences between records to report on daily production. I have created a formula field that takes (feet *12) + inches + quarter inches. I'm not seeing a way to use pivot charts (or any other report) to calculate and graph these changes. Am I am missing something simple? Thanks,
Dashboard Templates for Zoho Creator
Do you have to propose me or are there some ready dashboard templates for zoho creator applications? I know that there are some templates when I create a new page but my question is if there are somewhere more creative templates for zoho creator (paid or free).
Sendmail Limit approaching 500, do I get a warning email?
I have multiple forms which trigger sendmail actions and I am concerned that as my volume of subcribers increases, I will approach my limit of 500 emails per day. Will I get a warning email saying "You have reached your limit of 500 emails per day. Please log on to Zoho Creator to review your Usage Log Details and optionally add a $10 for +500 emails per day to your account."? I would rather not have to script this to count every sendmail action and then email zoho.adminuserid when limit is reached,
Email Orders
I presently have a view to show me Orders. I would like to know if there is an easy way to add an Email function to the left drop-down lists (Edit, Print,View). If not is there a custom email app all ready that I can you on selected orders? Sample to mail; WO Number 7134 Status After Service Call Complete Customer Name wtfcu Date Jun 16,2014 Terminal ID Model 5890E CPM/BNA Reported Problem Other Error Details they are having problems with the bottom part of ATM that is opened using a key - they cannot
How do I add multiple keys fields to a single form?
Sorry for such a basic question, but how do I specify multiple key fields for a single form? E.g., an apartment is uniquely identified by the combination of (1) the building number, and (2) the unit number.
auto-filling form field from url
hi, guys! how can i make creator's form so that 1) there will be a number of hidden fields and a number of seen fields? as seen - phone field, for example 2) hidden fields auto-filled from url string url example - Google Adwords URL http://www.okdekor.ru/?url={lpurl}&adwnetwork={network}&adwplacement={placement}&adwadposition={adposition}&adwcreative={creative}&adwmatchtype={matchtype}&adwkeyword={keyword}&adwdevice={device} hidden field with name "adwnetwork" - auto-filled with content of "{network}"
Can a Form in Application A be referenced in a Zoho Page in Application B
I have a set of forms (tables) that are common and needed in a number of applications within a Zoho account. I would like to avoid duplicating the forms and its data in every application. These tables reside in Application A. Now when I am creating forms in Application B, I can reference these tables of Application A in Look ups without any issue. However, if I try to write Deluge code in HTML pages in Application B, it does now seem to work. Here is how I am referencing form of Application A in
How to set default values of multi-check field?
so, a form has a multi-check field, with n items. What code do I put in the on load, so that some of the items are checked by default when the form loads?
For Each Builder is Broken
Cheers, John Whitney
Null Check in FX
Hi, Just created an overtime form for staff, but my Zoho is somewhat rusty after several years. Hours are calculated between a start date:time and end date:time: "Minutes" <((End_Time - Start_Time) / (1000 * 60)).round(2)> "Hours" <(((End_Time1 - Start_Time) / (1000 * 60)).round(2) / 60).round(2)> From these Minutes, I calculate how many hours were worked and if the person is eligible for 1.5xpayment or 2xpayment. "Overtime 1.5" <((Minutes - 450) / 60).round(2)> "Overtime 2" <((Minutes
Image note displaying when creating PDF from url
I created an HTML view with our Logo Image in the header. It appears when viewing the report, but not when directly creating a PDF from a zoho creator url. The source of the image is from a Zoho creator view <td width="60%"><img src="https://creator.zoho.com/ghsagjv/projects/Genre_LogoView/Image/image-download/1400541422986_GHSAGLogo.png" alt="" /></td> Screen shots are attached, that shows the same HTML page being opened in print view, and coverted directly to pdf. The pdf is created with a small
Deluge Field name moved
I love it! Thanks for moving the deluge field name closer to the display field name!
From Free-Flow Scripting, see: View names and Functions
When I'm in Free Flow scripting, I can use the Refer Fields link to reference forms and fields. That's great but I'd also like to reference: Functions with their parameters View/report names (which I need to reference using share/unshare)
Permalink (Publish) form - unable to customize
First off it's been about four months since I setup a permalink to any form for public access so I realise the interface for this specific instruction set has changed in that time. OK so from my form I select Permalink and in the dialogue I select Publish, to make it public then hit Customize. I'm dropped back to the editor window and am shown a preview which updates as I change fonts, fields sizes, etc within the customization pane on the right side of the browser. The problem is the Publish URL
Functional-based URL strings with lists
In regard to functional-based URL strings at https://help.creator.zoho.com/Functionality-based-URLs.html I have a question about calling a view based on a list, generated from check-boxes on a form. Let's say the criteria is PET and the user can select any of Cat, Dog, Bird, Cow, Snake. How do we call a view based on PET={Cat, Snake} for example? Something like http://creator.zoho.com/admin/users/#View:User_View?PET={Cat, Snake} ?? John M. Whitney
Function Script Disappearing
I have a script to create a concatenated string (thanks Cyril). It works great in workflow under On Add/On Success and On Edit/On Success. What I would like to do is to put this script into a function and just call it in the workflow that way. I tried creating a new function and added the script. I saved it and called it in the workflow. No go when run. Blank. I go back to the script editor and the script is gone except for the bit on top for the string. Tried it a few more times, same result. Also
iPhone App won't display reports in calendar view
I cannot get the Creator iPhone App to display a report that is calendar view. It closes the App when you try to open it. I have tried several reports. Works on Android App. Is this an issue?
On insert access
Hi, I have created a custom action on the form A, that execute a custom function that insert a new record in a form B: void richiestaApi(string dominio, int registrarID, int operazioneID) { insert into B [ Added_User = zoho.loginuser Dominio = input.dominio Operazioni_disponibili = input.operazioneID Registrar = input.registrarID ] } I have also created a script On insert On access on form B, but it is not executed, even if the new record has been correctly created. If i
View an uploaded file without downloading?
So, once a user uploads a pdf, is it possible for a user to click and view the pdf in a new window, rather than downloading it and then opening?
is it possible to insert a data field into an alert?
I would like to reference a field in an alert box, how do i do that, is it possible?
Subform Fetch/Lookup
I am having a problem setting up a fetch lookup to a form that uses a subform. I have attached some screenshots to help me explain. Here is my main form. The BOM subform section is added as I create the MMR(master mfg record) Once my MMR is setup I will need to create a BPR(batch production record) for each production run that will include everything from the MMR. Here's what I have so far on the BPR form I have the lookup MMR set up & it works to bring in the Product_Name But I get an error when
Function definition
The zc help shows this example for a function. What should the code look like if I'm adding in a 2nd argument? openUrl(“#Form:Add_Meeting_Attendance?meetingid=” + input.id + “”, “popup window”, “height=400,width=550″);
can subform include loginuser and dated posted?
Can either type of subform (the one that is embedded into a field, or the one that connects to a separate form), include columns showing the logged in user and the date?
Combining Multiple Related Data On One View In Creator
I need to combine data from multiple forms on one view, similar to your CRM Accounts view. I need to have a main organization record with sections for contacts, etc. under it. I searched the forums and knowledge base, but cannot find the answer.
FieldType: Multiselect vs Checkbox
What is the difference between these 2 fieldtypes: 1. Multiselect - and then I can choose dropdown or checkbox 2. Checkbox
Scanner Interface
Is there a way to scan a document directly to ZOHO and add user defined terms?
view only field
I have a parts_Used form that I want to show the current on hand quantity of a part. I only want to show the user the current on hand and not allow any changes to the field. Is this possible? The field I'm currently using is a numeric type.
how to hide admin email address?
hi use workflow rules and send email in manner "if this than that" when i tune email sending systems asks me to send email from admin email or to admin email in all cases systems asks me use admin email how can hide admin email from email body i need use admin email only for system needs on other hand - system do not accept using admin email only in bcc field i need hide admin email in from: and in to:/cc: fields.
Potential Misconfiguration in Maximum Number of deluge sendmail Statements
In my database, I have assigned a numeric "group" number to 259 records to control how many emails get sent using the following function: void NOTIFY(int Group_Number) { for each row in parent_database [Group == Group_Number] { sendmail ( To : row.Parent1_Email From : zoho.adminuserid Subject : "sample" Message : "yadda yadda" + thisapp.printout(row.user_key) + "yadda yadda" ) } } The function thisapp.printout(row.user_key)
How to filter report to exclude sub-form dates
I'm trying to create a list that identifies accounts that have no activity in the last 4 weeks. My main Accounts form has a sub-form for Activities, so what I was hoping would work is: show all rows from Accounts [!Activities.Activity_Date in last 4 weeks] but the use of ! to create a negative doesn't work. If I try to use >, it won't filter Accounts that have activity both before and after the 4 weeks. Is there a !> function, or some other means to say "not after" I've tried using other deluge
String and Date Handling from Multiple Fields into One (newb)
I need to do the following and was wondering if anyone could offer some Deluge pointers. I have a form with the following fields: Date (date) Room (drop down with three choices Room 1, Room 2, Room 3) Class Title (single line text) POS Title (single line string with 30 character limit) The task is to convert the Date, Room and Class Title fields into a string that will be fed into the POS title field in a specific format. Here is an example: Input Date: July 1, 2014 Room: Room 1 Class Title: Underwater
To view all the records displayed in a published report in a single page
Dear Sir, In our application, we have published a report to our vendors. From the published report, they have to write a script based on the data.In zoho, the maximum records to be displayed is only 200 per page. But our report has more than 250 records. So it traverse to the second page. Pls let us know, is it possible to view the second page of the report, without actually clicking the navigation button. Also, is it possible to include the page number of the report in the report url? Any suggestions
"Super Admin" role versus "Admin role"
I want some users to be able to administer the creation of new other users but not have access to be able to edit the application, is this possible??
Embedding Google map in iframe
I want to open a Url in an iframe, but the url is lifted from a value on the form. What is the syntax? I tried this, in the OnAdd.OnLoad script, but it doesn't work (I get a new window, that's blank). I want an iframe, that shows the info based on a url field on the form OpenUrl(input.Url, "iframe", "height=100,width=100");
How do I make a lookup field display information and not the ID.info
I have a "Contacts" field in a customer follow up form. This field looks up contacts in the contact form. Naturally if displays the ID.info. I've set a filter in the follow_up form to ID==site_ID. This should only display contacts that have the same ID as the ID entered in the Follow_Up form. The contact drop down selection box still displays the record ID.info. I've put this code in the "Contact" field On User Input. FollowUpContact = Contacts [ID == input.Site_ID]; Site_Contact = FollowUpContact.Full_Name;
how to create public variable
How do I create a public variable to store information in one form and then use it in another? I have three default fields in one form that I need to populate in another form. I've tried creating a variable but they are only valid in the form they are created in. Any thoughts?
List:Date help
I'm trying to create a list of dates between Start and End The first date should be input.Start The last date should be < = input.End The remaining dates should be 28 days apart fourWeeks = list:Date(input.Start.addDay(28)); gives me an error: Expecting TIMESTAMPLIST expression found TIMESTAMP expression thanks in advance
This record's Datefield = maximum prior date + 7
I have a form with dates.... When I add a new row, I want the Date_field to default to 7 days after the maximum prior date... How do I do that?
Show image in a page
I read all posts and documents related to showing an uploaded image within a page. Ifetched the target record and the link uploaded image link which is https://creator.zoho.com/sharedBy/appLinkName/viewLinkName/fieldName/image/1403695745088_Downgrade.png I replaced all fields manually to try it in a page but never shown the image. Moreover, I could not find any reference to the ViewLinkName field, what should it be replaced with? Any help?
Next Page