How do I get the last value entered into a form to carry forward until it is changed?
Hi - I have a small manufacturing business and am working with creator to develop apps to collect data at various work stations vs filling out paper forms and manually entering the data. A lot of the entries will be repeated and do not want to have to re-enter them every measurement. For example I have an order number, width and length field - the order number and width field will be the same but the length will vary for that job. Thanks for the help.
Formatting a sub-form - help needed!
Hi I have a form into which I need to insert another form (ie as a subform). This second form has six fields, however when it is inserted as a subform I only want to display two of them. It seems that this can be done using CSS (see https://help.zoho.com/portal/en/community/topic/subform-formatting). Can anybody give me some suggested code for this, and advice on where to place it? Just use any form and field names you like; I should be able to tweak it to suit. If it works I'll make sure to report
Set value of field in task + Convert simple SendMail task to Custom Action on report
Hi All! Hope someone might help me on this. I have a form called “New_Services” This form has 2 equal functioning tasks placed at: 1) OnAdd+OnSuccess 2) OnEdit+OnSuccess The task performs a very simple script The form has a dropdown field with 3 options. When the user selects option 1: “if” dropdown equals “choice 1” then “SendMail” (the SendMail gets the “to:” field from a lookup to:Driver[ID == input.Driver].email_driver) And displays a “success message: email sent” When the user selects option
download my Creator
Hi Is there a way to download what i have created on Creator? I would like to download my app in order to protect it in case of loss is it possible? If not how can i protect it ?
limit of fields
Hello the world is there a maximum quantity of field per form? because i can't add a new radio, the field is "adding" forever only the checkbox is adding well is that normal? thank you
triple column
Hi Is it possible to create a triple column as it is possible to create a double column on the form of zoho creator? thank you
Skip errors when inserting rows
I need to write a Deluge script to insert 10,000 rows into a form from another form. How do I skip error rows when "unique key" condition is not met, but continue with the other rows? Thanks. Also looking for a full Deluge training manual.
A too long form
Hi everyone, I have a form which is very long and complex, i would like if possible to segment it into several forms. For example, based on the Conditional output of form A, the sister form : form B will be prefilled and/or precreated The forms should be in a certain manner be interconnected to each other's My problem is : 1 I don't know how to interconnect to Form 2 i don't want to create millions of records for the same implementation thank you
Notes visible in a Report
Hello India ! Does anyone knows here if it is possible to show a note of a form on a report? thank you
Check if a string can be converted into numeric
Hi, Is there a way to create a function to check if a string can be converted to numeric ? isNumeric I'd like to convert kg in lbs but I want users to write "N/A" or other text instand of numeric values. I setup 2 fields. If the user write text, I want to copy text, If he enter numeric value, I want to convert. Thanks for any tips. Pascal Veilleux
edit entry by record ID only having link
hi how can user edit zoho creator's entry by record ID only - if user has only a link to this record - user do not authenticate himself on creator.zoho.com https://www.zoho.com/creator/help/views/editing-records-via-record-id.html so - how to edit record without authentication and only have a link ?
Lookup fields
Hi. I have 2 forms. In 1st form i collect all data about land plot (number, cost, status, square etc) - it's form like databes - only for administrator. In 2nd form i want to add lookup field "Status" ( dropdown type: sold / free) from 1st form for manager. But i can't do it, i don't see this field in lookup type.
Creator mobile app landscape mode
Is there a way to get the Creator Mobile App to: Display in Landscape Mode? To pan right to see more columns?
radio
hi Does anyone knows How i could code the following : " if there is a change of choice in radio/dropdown.. then " I want to disable a field if a change of choice is done in the radio/dropdown I could code for choice A do that and for choice C do this, but i don't want because the Choice may change a lot in the futur thank buddy
STRING and STRING LIST
Hello the world I got a problem that blocked me for hours. A is a STRING If ( A == row.STRINGLIST) { hide field } How can I match with String and a Stringlist. Because obviously they are not the same kind of data thank in advance
date
Hi here :) How can I in term of coding reset the date field For example If ( A >2) { " reset the date at its initial value ( empty field) } thank a lot for your expertise
How do pre-fill fields in a form invoked via "allow new entries" + control
Single or Multi-select relationships are great... and the + button is useful for adding new data into a related form. However it would be REALLY useful if fields in the related form could be pre-filled with data from the parent form? Also, you cant select related records in the picklist and view/edit them... you have to go find them in the associated report (for the related form) and edit them there :( or... When using sub-forms is there a way to control which fields (in the sub-form) are included
How to translate the view?
Hello Is there a way to translate the expressions such as search or filter in the view mode? Thanks, Vera
Complex report criteria
I have a report based on a form, with some criteria to create which are quite complicated. Basically the criteria for the report need to be: select * from FORM_A where value of FORM_A.FIELD1 in (array/collection of values of FORM_B.FIELD2 from FORM_B [FIELD4 >= '1974-01-01']) Which means, for each record in the FORM_A, if the value of FORM_A.FIELD1 is contained in the collection of values from the selected records from FORM_B.FIELD2, then display the FORM_A record in the report. Is this
custom actions
Hello, Im really not a zoho creator expert, but I am using it for quite a long time.. Now I would like to explore more than basic actions and started to mess with custom actions in reports. Maybe its stupid and newbie question: I have 2 custom actions (buttons in report) and i would like to have one instead of them. First is: void Vybavene(Nova_uloha Vybavene) { Vybavene.Protokol = true; } and second: void VytvoritProtokol(date Do, date Od, string Uloha, string Technik, string Z_kazn_k) {
Look Up Current URL in Workflow Automation
I have created a URL field in my reports for the URL of the current project. I need this so I have a link in Advanced CRM directly back to the original project. So I've made a workflow automation that will fill in that field when the project is created. Now I just need to know how to use the current URL to fill in that URL field.
Hide button "Add new" in subform
I've always read that hiding the "Add new" button from the subforms was not possible, even with online help. I even searched the forum and they say it can not be done. (Hope I was wrong) I show you how I found a way to hide it with a simple ruler. 1. In automation, create a new task: 2. Create a new ruler: Result subform: If they already have it in good time. Otherwise I hope you find them useful. Note: I am also coultando the "X" that deletes a row. Greetings from Cusco - Peru.
HTML link to record summary
I am attempting to create an html link in an html page to open a record summary in a pop up. I am certain that this is fairly simple but I cannot get it to work. I have tried many versions of the following example: https://creator.zoho.com/<username>/<appname>/record-summary/<viewname>/583654000005625549/ Is the <viewname> the deluge name of the record summary, or is is the name of the report the record summary is contained within, or? I have tried many variations, clearly not enough, but end up
converting a text box
Need to convert a text (single line) box to a date box without losing any of the old data. Old inputs are like 06/12/1943.
Quickly create insert, collect, update DS code for your forms
Link to Code snippet Ok, so I just got so tired of writing lengthy Zoho form field scripts full of the same code over and over! ZC doesn't have any feature to dump field names onto the text editor for easy script writing. Nor do they offer anyway to dynamically reference input names through meta programming methods (code that makes code, DSL's). So if you want to generate insert, collect, and update code really quickly you might be interested in this javascript snippet. Read the comments in the
Name server zoho
Ho attivato il dominio, con il file sul mio server. Devo aggiungere il record MX, ma nel mio ospite mi chiede anche il nome host di Zoho, come faccio a trovarli?
Importing only unique values from another form
I need to import rows from one form to another. The two forms share the common unique key; I want the duplicate rows during import to be discarded, and only the unique/new rows to be imported... how can this be achieved? Thanks!!!!
zoho creator string field - search for multiple criteria
I saw this a a limitation in the api, but can I do it within a report? For example if I have a form that asks for the first name and I have multiple submissions, can I then run a search on first name for more than one name? Like to show me all records that have he first name "John" and/or "Bob"? If so, how do I do that?
Zoho Creator iOS app Offline access of forms
I am trying to access an app through iOS Zoho Creator and work in offline mode. No matter what I try, I am only able to get 1 or two forms in offline mode, rest won't appear. Following the instruction, I opened each data entry form and submitted a record each from the mobile device in wifi or 3G but when I tuen off the wifi or 3G not all these forms are visible. Is there anything / any steps I missed? Is there a form which addresses these issues in Zoho Creator mobile app? Is the App fully functional
Customer Portal Login page redirect to open in new page
Hi, I want to use Zoho Creator's Customer Portal embedded in my WP website. Unfortunately Iframed embedded login page redirect to open portal in new portal page instead of Iframe. I discussed that with Zoho Customer Representative and learn that is a default action. Any idea, work around tips to force the page open in my WP page? thanks
Account moved to trash
Hi In some reports the account name appears duplicated. I have sent to trash one of them ti items and the account has disappeared.(both) How can I recover the account from the trash ?? I cont' see the Trash Thanks JM
validate UploadField { script manual mandatory }
Hey community im just curious is there a way i can validate an upload field with a manual mandatory script if.UploadField does not contain = ".png, .jpg" { cancel submit; } or if = null / "" / 0 or something along this line ??
uploads sent to Box.com?
I use Box.com to store files. Id like attachments uploaded on Creator apps to get sent to Box.com. I can't use Box.com upload embed script because ZC doesnt support javascript. Box.com also accepts uploads via email attachments. Is there a way to get the notification email on form submission to include the file as an attachment rather than a link to send to Box.com?
Formula to count number of connected records
Hi. We have a courier business and use Zoho Creator to record our runs and jobs. We have two forms to record runs and jobs. One run can have many jobs. I need a formula field in the run form to count the number of jobs allocated to it. Any ideas please.
Google Drive with Zoho Creator
I would like a "File" field to store files actually on Google Drive. The pointer to fetch the file should be pointing to a google drive location or index. Can this be done?
Getting Form Reports / Submissions into Box.com?
OK so I need to collect many forms for various reasons - so each ZC form submission equals one form for me. I need to store these documents in Box.com. Box allows upload of files via URL or email attachment in addition to manual uploads. If I create forms in ZC - what is the easiest way to have these files uploaded to Box? Can the notification email on submission include a pdf file that gets emailed to Box? Can I bulk export multiple form entries to separate PDFs for upload to Box? Any marketplace
Passwords
I have a few ZOHO Creator databases. I need to change my password on all of them, but not sure where to find that option.
Can't get into any Creator databases for two days now
Suddenly, I cannot modify any of my 9 databases. I can see the data but can only SEARCH. If I click on SIGN IN, and I successfully sign-in, nothing changes. I still only can search. Without being able to get into the databases, I cannot get into ACCESS THIS APPLICATION (?) so I can't make any changes to the format or fields or try to see what the problems are. PLEASE help ASAP.
Update records in Zoho Creator
Hi, When a subscription is cancelled on Zoho Subcriptions, I want to automatically update a field in Zoho Creator and change the field value to "cancelled". Please assist. Regards, Siya
Zoho Creater + WooCommerce + Zapier
I'm running an ecommerce clothing brand, and I'm trying to integrate my WooCommerce store orders with Zoho Creator using Zapier. I've gotten through most of the process, but I'm struggling to figure out how to have my attributes and variations come through to Zoho. Here's an example... Each item of clothing listed on my website is a unique color. No single product has multiple color variations within it, only sizes. Through the Zapier connection, I'm looking to have these fields imported to my Zoho
Next Page