consecultive date entry in subform
dear all, I created a sub-form for people to input their working/education experience. Since it is required to have a consecutive date record, so we have to make sure the "start date" in the next entry are one day after the "end date" in previous entry. for example. the "end date" in first record is 20/01/2001, then the "start date" in second record must be 21/01/2001. I am not sure if in zoho can do coding on it and realize it. If anyone can shed some lights that would be much appreciated thanks
Update more than one selected records ?
Hi experts, How to update Status = "Paid" where Invoice_No = "test" ? BTW, I managed to update 1 instead of 3 records using the script below: Please advise, many thanks. :) // Assume rec = "test" rec = Invoice[ID == input.Invoice].Invoice_No; for each sel in Delivery_Order[Invoice_No == rec] { UpdateStatus = Delivery_Order[Invoice_No == rec]; UpdateStatus.Status="Paid"; } Delivery_Order
Drop Downs
I made a drop down box with 3 choices to pick from. Each of the 3 choices has drop downs to choice from. I don't want to show the other 2 choice drop downs. Example This is under the drop down called Equipment. If I remove the 2nd IF statement. It works like it should. if ( (input.Equipment == input.Tractor) ) { } show Tractor; if ( (input.Equipment == input.Harvester) ) { } show Harvester
Mail Merge with Creator
Hi I am very new to Zoho Creator. We are looking to use Creator to store a database of information. We wanted to be able to use this information in a Word mail merge. Specifically to print labels and create documents that use specific information from individual records. Is this possible? Thank you.
Update data from multi check List
Please see the explanation below: 1. Select "Supplier 1" from dropdown list. 2. Select 3 records which are DO0003, DO0004 and DO0005 (Lookup from Delivery Order Table). 3. Click Submit. 4. How to update the status from "Pending" to "Ready" for the selected records which are DO0003, DO0004 and DO0005 ?
how to close a stateless form
I have a stateless form that popups up on a condition. one of the buttons is to close the form. it dose not close. what am I missing.. openUrl("#Script:dialog.close", "same window");
OT - Creator is really good - but not well explained... (not complaining as such)
I do really like Creator and it has a lot of depth but some of it is quite buried. This is not a complaint - just a concern. Example; the "Pages" can (if I knew) really customise the look / feel of an application and I have been reading through the documentation and I think it is all there - but just a case of working through it all... I mean in Pages there is a little tiny icon in the upper right where it shows all the fields you can embed into your page. And in Reports there is a whole report writer
Can you change a selection of dropdown list to affect another?
I am creating a School List, and when i select a certain school i want a second drop to give me the name of the classrooms at that school. For Example: i choose Diamond Elementary i want the second drop down to give me AM and PM selection but if i choose Lincoln i want it to give me the selection of 12AM, 12PM and 15AM, 15PM is that possible?
drop downs
I have a drop down that has Tractors and Harvesters for a choice. When they pick tractors. Then I show the tractor drop down. That works fine. But when they pick harvesters. It then shows the tractor drop down list. I used script build on the main drop down called eguipment. If they only pick tractors I can make that work. But when I add the Harvester then it shows both drop downs with tractor disable. Please help if ( (input.Equipment == input.Tractor) ) { } show Tractor; if ( (input.Equipment
Reports disappeared from Creator iPhone app
Very strange the other day when loading up the ZC app to discover that all but the form and one report had vanished from the app menu. They're all there when logging on to the web version and am wondering if anyone else has encountered this problem or has an answer to the problem?!
How do I populate an email by clicking a URL in a mobile view
I would like users of the mobile version of my application to be able to click a link within a record that invokes an email to be sent to pre-selected email addresses and includes inputs from the record in the body of the email. Example: A record is created by an administrator that represents one step from a checklist describing how to install software. In that record, 4 contacts with email addresses are assigned using a multiselect lookup dropdown. They are support personnel for that step. A user
HTML special Characters
Hi All, I want to include the up arrow ↑ and down arrow ↓ html special characters as part of a text string for a field value. However, when I try to add the html entity name, the string just shows the characters and not the symbol. Perhaps special characters are not supported in field values? Thanks in advance for any help.
Deluge script
Hi I am new to creator and deluge script and would like some guidance. I am trying to create a rule that automatically enters a defined value in a field based on users selection. The User selects a measure The required volume field is populated. Any help would be appreciated.
Sendmail Custom Action
Hi All, I'm very new to Zoho and coding in general. I'm looking to create a custom action that will allow the user to select a record or multiple records and email it to an email address they specify (or at least to themselves if that's not possible). Is this possible? Can I email the record using a record summary template? Tim
Schedule Report Not Showing Images
How can I get images to show on a scheduled report? I have selected a report as an attachment on a daily schedule. It is only showing hyperlink addresses. I have shared and published the report and associated reports. Is this not possible? I need to get this fixed ASAP.
How can I put a message on a screen that is dependent on the combination my form inputs
I'm struggling to create my first application and would appreciate some guidance. I want o create a small 'expert system' that displays a different answer based on different combinations on inputs. I can create an entry form easily enough. But I'm lost to know what to do next? thanks
Pivot chart creation
Hi, Is there any way to make the following chart from Zoho Creator? . Thanks Satya NHM
Hide/Show Logic for Form Buttons in Stateless Forms
I've come across a number of situations with stateless forms where it sure would simplify things to have hide/show logic for the submit button. Essentially this takes the place of form validation rules for a full form. Cheers, John Whitney
Radio or Dropdown for number
Hi. i would like to gather public opinion by providing radio or dropdown button and in the end it sum up their feed to give feedback. But the problem is the radio is string only. How do i performance mathematic to the feedback. Thanks
Is it possible to move a record from 1 form to another?
Hi guys I have set up a simple form which I want to use for inventory purposes. Each item is stored at the warehouse for a certain amount of time, before it is bought back to the production unit for work to commence on it. I would like the ability to move a record from the form that shows all of the items stored at the warehouse to a seperate archive form of records that shows all of the old items that are no longer stored at the warehouse. Is this possible? Many thanks Tom
Move records from one form to another
Hi Is it possible to move entire records from one form to another? Or is it possible to archive entire records with the ability to look back over them? Many thanks Tom
Re form field for SS NUMBER AND PHONE NUMBER
Sir, I need to have a form field for phone number and ss number please help me mdspine
com.adventnet.persistence.DataAccessException: [Rename_Table_In_Path] Column 'TABLE_NAME' cannot be null
This is the returning error when restoring an app. Does someone know what is it?
On Validate allow either the Added_User or an adminuser to edit
on validate - I want to allow either the Added_User or an adminuser to edit a record. Other users should not be able to edit the record. I've tried a few different statements at "on validate" but cannot get them to work. I am an admin and I attempt to edit another users record as the test. So far, test failed. Any help is welcome. Two examples are below of statements I've tried to use. >> I've tried this if (input.Added_User != zoho.loginuser)||(zoho.loginuser != zoho.adminuser) { alert "You
Look up fields as numeric field?
I have added few look up fields that look up email addresses based on a name selected from another look fields. When I try to set up an email notification on Add, on Success, these email address look up fields show up under numeric fields list. So my email notification errors out. How do I fix that?
Phone validation script
Hello, I am using the following validation script to change some phone numbers that are being sent to one of my forms. if (!input.Phone_Number.matches("[0-9]{10}")) { alert "Enter the numbers only (Example : 1234567890)"; cancel submit; } else { input.Phone_Number = (((("(" + input.Phone_Number.subString(0,3)) + ") ") + input.Phone_Number.subString(3,6)) + "-") + input.Phone_Number.subString(6); } While it works when the phone number comes in as all numbers (i.e., 5557771212), I also
PDF conversion for multi-page dynamic pages
Hi, I have a dynamic page generated from data in a form that fills in a template. This works fine and displays well rendering all HTML as it should. The issue I'm having occurs when I try to use the PDF exporting functionality. Since some pages extend over multiple pages, text at the bottom of the page overflows failing to respect margins and any padding. I have created a print-only style sheet that defines margins for the pages and padding for specific elements but the overflow is constant. Can
How to sum related records?
Hello, I have two tables: one list my works and another one relatated counts worked hours. I would like put a formula in works table that sum all worked hours for selected work. Thank you
Customer Portal quetions
I'm investigating for use by an organization where I volunteer: I'm assuming I can parse data by customer so that multiple customers using the customer portal can't access each other's information. Correct? Can the survey feature be used within the customer portal? Meaning that surveys are presented, responses are captured, results are displayed all within the customer portal. Is the customer portal branded with my company name/logo, or zoho? Can I use my own domain for the customer portal? Thanks
Update Multiple Lookup Fields
Hi. I have fields which are lookup fields which are numerous and need to be updated with the same data. However, the condition fields are also lookup fields. Is there an easy way to do this? the script would be if(lookup field1 == "text1", update all lookup field2 with "text2") Thanks
Creator does not seem to have CRM's workflows?
One of the things I like about Zoho CRM is the "workflow" - Creator says "workflow" but it is programming. It is a shame it could not replicate the CRM "workflow" module. Does anyone else see any utility in it? Thank you Brynley
Criteria from multiple fields for lookup
I know similar situations have been addressed, but I'm having trouble implementing a solution. I am working with 4 forms right now. Crops_form Section_form Planting_form Harvest_form One record in Crops_form is related to many records in Planting_form One record in Section_form is related to many records in Planting_form In the Harvest_form, there is a single-select look-up field "Crops_field" which looks to the Crop_form a multiselect look-up field "Section_field" which looks to the Section_form
Make fields smaller? (lots of fields on a form = lots of scrolling to see the fields)
Hi there Is there any trick to squeeze more fields onto a Form? One of my Tables has about 25 fields and the standard way Zoho lays them out means the user has to scroll down to see them. I don't see this being possible but thought I'd ask anyhow. I have also tried to break the Form up by making some fields looked up in a different table - but this would be a 1 to 1 relationship. Thank you Brynley
Zoho.support.create function call
I submitted a support request last week, but, not unexpectedly, there has been no follow up from Zoho technical support. I am hoping for better response on this forum. I am trying to integrate several Zoho products (Creator, Support, CRM, Projects, etc.) into a workflow. At this point, I need to have Zoho Creator submit at ticket in Zoho Support via integration task/call function zoho.support.create. When the function is executed, the ticket gets created correctly. However, the data contained in
Security of data?
what safeguards does Creator have for the security of the information
On User Input - Submit Form
Is it possible to submit a form on user input? We're incorporating bar code scanning with Creator and having to manually click submit slows down the process. We want scan, then scan, then automatically submit if both values are not null.
eomonth function not working properly
Dear ZOHO , while using Date-Time functions in zoho creator I noticed that the eomonth() function is not working properly. It returns wrong values for dates in February. If February has 29 days eomonth(<date_in_february>,0).toString() returns “YEAR.03.02” / 2 nd of March and if February has 28 days eomonth(<date_in_february>,0).toString() returns “YEAR.03.03” / 3 rd of March. Best Regards Michael
Has anyone elses creator program stopped working?
As of today, Our creator pricing tool has stopped working correctly. In every instance it gives the error below, even though we have made no changes to it since it was working. Anyone else having an issue with this?
How to delete unconfirmed users
I shared my application with another user, but I made a mistake and I inserted the wrong email address so she didn't receive the invitation. So I reinvited her using the right email address and everything worked fine, but now I have the old email address between the unconfirmed users and I would like to delete it. Is it possible and how? Thanks, Michele
Domain validation
Hi I have ".photography" extension domain email ,i try insert the email like as " name@abc.photography " but its not inserted in form Thanks Satya NHM
Next Page