lable functinality
Here is my application 1) Child Names of a person I have to fetch from the database and for each field i have to asign the percentage of share . 2) And To add a another child i have to give link down to this fields "Add Another Child" once clicking on that link the new window will open then the person can add the another child information .that will automatically add here . Child Name1 ________% Child Name2
Linking two applications
Hi, I have an application which is a database full of work respondents. They fill in information themselves to be added my database. I was wondering if there was a way to create a new application that interacts with the first one so I can add information in a form about them and there previous work because they will not be able to change any information once they submit it and I will only be able to add the work they do for me in the future. So I would like something on the second application form
Trying and failing to Aggregate Records with the following criteria...
Here's my code: input.Spend = Credit_Cards[(TYPE == "Ad Spend" && PURCHASE_DATE.getMonth() == input.Date_field.getMonth())].sum(AMOUNT); This doesn't work. Can you tell me how to check the Credit_Cards PURCHASE_DATE field against the parent form's Date_field?
Free User to Enterprise trial
I initially signed up as a free user. I have been gradually building applications, which I plan to deploy using a paid version. I noticed recently that my account status changed to "Enterprise trail - 15 days". Will my account revert back to a free user account at the end of the trial period. Also I hope that all the changes I made remain, when I get back to the free user status. Thanks
Configure Custom Actions I only ever want an action to be performed on one single record
Am using functions and custom actions (In the header section of a view ) successfully Question For my view if i use "Execute action for collection of records" or "Execute action for each record" the user can click multiple records. In my case (booking rooms) i only want them to be able to book one room at a time so i a) Only want one record to be selected or b) Know if multiple records have been selected so i can check for it Any suggestions thanks
Send grid and creator?
Right now I export to spreadsheet every week, my creator list of emails. Then I mail merge with outlook and send through sendgrid. Anyone have any advice on how to "auto grab" my current list of emails ( instead of having to export manually)?
Need you help
Ruben I have not received your reply, please check to link https://help.zoho.com/portal/en/community/topic/need-help-for-deluge-script-builder Thanks Stanleyguo
Import App link not available!
where is it???
Insert record into new form
I need to insert a record into a different form in the same application so that 3 additional fields can be added by user and saved into the other form. I'm not sure where to start, please advise. Thanks in advance for your help.
Referencing forms in other applications
How to reference forms in another applications?
Does Stateless form submission bypass all other form scripts
Hi need to check I have a stateless form which is inserting values into another form as the form is referenced in the insert statement i am wondering if the insert will pass through any script (on add/load/submit/success. Reason, the stateless form submission has different rules than the normal form submission Thanks
How do I enable date specific search options when the date field is specially formatted.
Hi there, I followed this forum post: https://help.zoho.com/portal/en/community/topic/how-do-i-format-a-date-time-value-in-a-view And used this to format a Form date field into formula field: input.givendate.toString("EEE, MMM d, yyyy, HH:mm aaa") The problem is that in my View, the date specific search options are no longer visible. ie: Next 7 days, Previous 30 days etc. Is there a way to enable those for the formula field that is holding the formatted date? Thanks, David
Importing with a date that isn't auto-selected hides the "date format" option.
So, this is fun. I'm migrating data from an old Zoho account to a new one. Steps: Create a form that has a date field, where the label has a space in it. (In this case, "Confirmed On".) Add a few records. Export from Zoho to CSV. In the new app, start an import: CSV, local drive. Upload the exported CSV file, and click Next. The issue: "Confirmed On" isn't selected, even though the first row has labels, and the old form's label matches the new form's label exactly. There is no Date Format option.
When can I use zoho creator to develop mobile applications (full support for Deluge Script)?
Hi When can use zoho creator to develop mobile applications (full support for Deluge Script)? Thanks! Stanley Guo 2011-10-6
How do I post raw code into a Rich Text field without executing?
Currently, when I paste sample XML scripting into a records Rich Text field, the record updates with the tags removed. For example, I want to paste <name> john </name> after updating the Rich Text field shows as john I don't want anything to be executed in this field. I've put in a Plain Text field as a workaround, but even those tags disappear when in a records view mode. Please help! The whole purpose of us creating this application is to track XML protocol information. Thanks, Brent
Import - Delete if exists
Hi! I have downloaded some data from my application and made some changes en-masse because I changed the structure of my database. I now want to re-upload the downloaded file to the relevant form and update the data. From what I have read, it looks like using the Migration Tool is the best option as it allows adding of data to Zoho Creator. However, I have been unsuccessful in updating the data as I cannot match based on the field that I would like to match upon. I only get an option to match based
zoho creator Send Email issue
Hi I have created a zoho Form and when submit button of form is pressed an an email is sent automatically.It is working fine on my PC. But on my clients Computer It gives following error when submitted using IE or Safari "Error occurred Please contact application owner".But it is running fine on even client's pc on Firefox. So i m stuck with this issue because i m not being able to understand the reason of this error. Regards Rana Ammar
Update a records Subform value or values
Hi Have fetched a record which contains a subform and i want to update (maybe later add) a subform entry to that records subform fields Script builder shows me the subform in the collection variable but from there i am lost Is this possible to do ? What is the syntax procedure thanks
Record id question clarifications
Hi Am about to embark on another coding adventure but need check on the following 1) If you delete a record in a form will its record ID ever be used again when adding a new record to that form 2) Are record ID's unique to the entire application or are they only unique to a particular form Thanks
Lookup Field by ID
I have a form with lookup field "Employee" reference to the employee form by Internal ID. with Display field "Name" For some reason I cannot have 2 records referencing to the same employee. if I select Employee that is used on another record, Employee from another record disappears. Problem 2: maybe related to the same issue, I cannot delete record now. Zoho loops
How to sum a separate table
I have two forms, an Expense form and a Purchases form. I want to very simply set up the expense form so it is: Account Number Budget Spent Balance xxx-xx-xxxx $15,000 $1,294.56 $13,705.44 yyy-yy-yyyy $20,000 $0.00 $20,000 Very simply I want the Spent column to automatically pull the total sum of all the records in the Purchases form that matches that account number. I tried doing all this scripting
Group the views menu (in edit mode) by their form/html/stateless
It get's really difficult to find the view you are looking for the way the view menu is laid out right now. I think grouping the views by their underlying form, html, or stateless would be very helpful to developers. Thanks in advance for your consideration ;) -Stephen
filter for a lookup field in a view
I have a form with a lookup field "Employee" that references to the internal ID field. In Advanced display option, I selected Display As: "Name" When I create view for that form and select Employee, column, it properly displays "Name field, however when I try to use this field in filters, the displayed values are internal IDs. Displayed values in the filter should match to whatever is selected for display. Another option would be to allow filtering on referenced fields, It would be even better,
Tool tip to be list items?
Hi, Right now, the tool tip shows the "help" description you put in the field configuration. But can the tool tip be configured to show each list item when it is hovered over? In other words, I have a drop down list. But some of the items are longer than the field length which makes it harder to read them. Can the tooltip be used to extend each list item's text? I've seen this done before elsewhere, but can it be done in Creator? I'd rather do this than expand the length of the field, which
NView not defined in the Workflow
For the second time in two days (two different applications), I got this error message when attempting to save a section code ... NView not defined in the Workflow ... this last time, I restarted ZOHO Creator, navigated back to this section code and (without making any changes) attempted to Save it ... and still got this message. Please explain ... a) what this undocumented/undecipherable message means b) how does one get around this ? Gaev
My Functionality based URLs is not stable
Hi, My client have a html view which passing parameters in the html view url, and fetch records by using the parmeters. However, after keep on testing, there are 30% chance that we can't fetch record in category and subcategory. I guess I make some mistake in construct the url parameters. I already enable support access. Could you please help me to take a look? Thank you. My client also intensive enter a lot of symbol in the database which cost a lot of problems. For example, " (This is for size,
Dynamically adding items to a drop down box present in a subform.
Hello just looking to get an update for when functionality to dynamically add items to a drop down box present in a subform will be available in Zoho Creator. This would be very useful for the application I am building to manage product configuration selection for customer orders. Cheers
Deluge script in for Schedules
i have a problem with my schedule, that falls for deluge scripting limits.. But i don't understand why: i have made many attenction to the scripting to not update all record but only the necessary records.. Thanks for urgent reply..
Dynamic Picklists Within Subforms
I've started trying to integrate the new subforms into my application, but have found that my dynamically crated picklists, don't dynamically change, when they are used as a subform. Is there a way to keep the dynamic nature of my fields, while having them as a subform?
intermittent issue with notification bar failing to update
The service is very slow at the moment. For example, saving a short script is taking 30-60 seconds. (EDIT: To clarify - as mentioned below, it later turned out the script is in fact saving ok but the green notification bar is sometimes failing to update.)
Urgent - Comments disappear when Saved from Free-Flow scripting
I was doing a test of a script section code and needed to temporarily disable a set of Deluge commands ... so I wrapped the command lines within ... /*abcd and xyz*/ ... but when I returned to the section later (after Running the Form), the block of lines were gone !!!! I did another experiment with just the //for a single line of comments ... that line disappeared too !!! I hope this is just a case of ZOHO Creator keeping its perfect record of "Make a platform change ... break unrelated functionality"
ABS or Absolute maths function for Creator?
Hello, Can anyone advise if an Abs function, or equivalent is available within Creator. I can't seem to find one...it is available in CRM and Sheet...so I am curious why one hasn't made it into Creator. Hope you can help. Regards, Liam.
Regex Matching Modes?
Does Zoho support these modes in the replaceAll() and replaceFirst() regex engines? /i makes the regex match case insensitive. /s enables "single-line mode". In this mode, the dot matches newlines. /m enables "multi-line mode". In this mode, the caret and dollar match before and after newlines in the subject string. /x enables "free-spacing mode". In this mode, whitespace between regex tokens is ignored, and an unescaped # starts a comment. /g - Allow global matching (all occurrences of a pattern
How do I create a Record ID link to sync/pull multiple data fields from one or multiple forms in a different view?
I am new to Creator and have a fairly basic database application question but can't figure out how to do it on Creator. Typically in a program like Access, you can tie records together by a certain data field and then pull certain other data fields into a form or view without having to re-enter the same data every time you input a record. For example... In my database "Contact Info", I have two fields, one - "contact" and field two - "phone number". Let's say I've created a view (not a report)
How to best link records within the same form
To make my database truly effective I need to show the relationships between records within the same form. In Form1, I'd like to indicate that Record1 is comprised of Record2 and Record3. I would also need to indicate if Record1 helps to comprise another record in the same way Record2 and 3 do for it. If I were to view Record2 I would want to see that it comprises Record1 and whatever else it comprises. The ultimate goal is to clearly see all of these mapped relationships. I've tried a few attempts
Update Button in View
I'd like to do something that I'm sure is simple, but I just can't seem to figure out the syntax. Here's the setup: 1. Form A has 20 fields. 2. Form B is a stateless form that lets users edit 10 fields in Form A. 3. I need an Update Button in Form A View that invokes Form B (the stateless form) and populates it with the 10 editable Form A fields from the matching record/row. My specific challenge: I can add a button (custom action) to Form A View and get it to invoke Form B, but I can't do it in
Render Image Problem in Different Views
Hello, I put an "Upload Image" and a formula "Display Image" in the form A. And I write the code below into the formula: ((("<img width='64' src='http://creatorexport.zoho.com/DownloadFile.do?filepath=/" + Upload_Image + "&sharedBy=" + zoho.adminuser) + "&appLinkName=") + zoho.appname) + "&viewlinkname=Image_Upload_View'/>" When I go to the view A, I can see the image. There is no problem. But when I go to different VIEWS which I had duplicated from view A, I can not see the image. Could you please
More map variable love with insert into, mail to, etc
Maps are REALLY useful data holders. They can be passed and returned in functions, you can dump all form field values into a map really quickly, etc. Deluge already supports using maps in setting postURL, getURL headers, and post body data, why not expand this to allow a developer to pass a map to insert into or mail to? Example myMap = {"first_name" : "Stephen", "last_name" : "Rhyne", "Added_User" : zoho.adminuser}; insert into contacts(myMap) //or insert into contacts [ myMap ] Why add
Grid View
I have a Form with lookup field. Field selected on that lookup is ID ( Zoho ID of the referenced record). I have a grid view from that form. Making any changes to the data in grid view, removes values from lookup fields even though I edit not a lookup fields.
stringlist conditioning
Hi guys, I'm not into coding too much but i have an idea of the basics. I have a stringlist in my app, and when a certain value is selected (in combination with others or just that value) I want to enable another simple string field. Could you help me with the code? Thanx Cosmin
Next Page